Week 4 - Assignment
Data Analysis: Correlation and Regression
Review the instructions for your Final Paper in Week Five of the course.
For this week’s assignment, utilize the following Excel data, which contains B.M.I., 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.
Week 4 Excel Dataset.xlsx
- 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. 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.