Data Analysis: Correlation and Regression

Nov 21st, 2015
Health & Medical
Price: $10 USD

Question description

Data Analysis: Correlation and Regression

Review the instructions for your Final Paper in Week Five of your course or the “Components of Course Evaluation” section of the course guide. For this week’s assignment, utilize the following Excel data, which contains Body Mass Index (B.M.I.), Fasting Blood Sugar Levels (F.B.S.), gender, and clinic information for a group of children ages 10-14, to complete items four and five of your Final Paper:

  • Correlate F.B.S. with B.M.I. What correlation coefficient will you use? Why? Report the correlation coefficient and explain whether this is a statistically significant correlation. Explain what it means for two variables to have a statistically significant correlation. The steps for running a correlation in Excel are described in Section 8.4 of your course text. 
  • Run a simple linear regression predicting F.B.S. from B.M.I.  Report your results.  Does F.B.S. increase or decrease with B.M.I.?  What components of the output do you read and interpret to answer this question?  Write the regression equation and include it in your paper.  The steps for running a linear regression in Excel are described in Section 9.3 of your course text.  
Your paper should be formatted according to APA style. It must be a minimum of two pages and include graphs, tables, and outputs that are clearly titled and explained. Since this assignment will be used as part of your Final Paper, it is expected that any feedback provided by your instructor regarding this assignment will be incorporated into your Final Paper submission. 

Tutor Answer

(Top Tutor) Daniel C.
School: Cornell University

Studypool has helped 1,244,100 students

Review from our student for this Answer

Nov 21st, 2015
"Very Satisfied."
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1823 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors