Homework 10 - HW 10 Page 1 of 2 Homework 10 Linear...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: HW 10 Page 1 of 2 Homework 10. Linear Regression Conduct data analyses 1. Copy and paste the following five variables into a separate workbook page in the following order: PHYS/MENTHLTH, EMTSUPRT, LSATISFY, BMI, and AGE 2. Use Excel to conduct linear regression analyses predicting PHYS/MENTHLTH from the combination of EMTSUPRT, LSATISFY, BMI, and AGE How to conduct correlational analyses in Excel: Go to “Data” then “Data Analysis” then “Regression” and hit “OK” Click into the “Input Y Range” box and then highlight the actual rows for the column PHYS/MENTHLTH (e.g., $A$1:$A$758). (Highlighting the whole column will NOT work for Regression like it did for Correlation.) Click into the “Input X Range” box and then highlight the actual rows ACROSS the columns for the four IVs (e.g., $B$1:$E$758). (Highlighting the whole set of columns will NOT work for Regression like it did for Correlation.) Make sure “Labels” is checked, “Confidence Level” is “95,” and “New Worksheet Ply” is checked and hit “OK”...
View Full Document

This note was uploaded on 01/18/2012 for the course SSC 304 taught by Professor Stacy during the Fall '09 term at University of Texas.

Page1 / 2

Homework 10 - HW 10 Page 1 of 2 Homework 10 Linear...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online