Discussion Post: 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:
A. 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.
B. 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.
The response must include a reference list. One-inch margins, double-space, Using Times New Roman 12 pnt font and APA style of writing and citations.