# HCS 445 week 4 Assignment

Ashford 5: – Week 4 – Assignment

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 as outlined in the Ashford Writing Center. 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.

Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.

0 replies