math plotting question
The following chart lists average boy weights from birth to about 12 months.
| Age in Months | Average Weight (lbs.) (boys) |
| 0 | 7.78 |
| 0.5 | 8.82 |
| 1.5 | 10.75 |
| 2.5 | 12.5 |
| 3.5 | 14.08 |
| 4.5 | 15.51 |
| 5.5 | 16.81 |
| 6.5 | 17.98 |
| 7.5 | 19.04 |
| 8.5 | 20 |
| 9.5 | 20.87 |
| 10.5 | 21.66 |
| 11.5 | 22.38 |
| 12.5 | 23.04 |
(Source: www.cdc.gov)
Write a response that completes the following tasks
- Perform the linear regression on the above data. It will be easier if you use Microsoft Excel (or equivalent program) to perform the calculations. This video will help https://www.khanacademy.org/math/probability/regression/regression-correlation/v/fitting-a-line-to-data
- State the slope and y-intercept.
- What does the slope represent in this case?
- What does the y-intercept represent in this case?
- Attach the scatter plot together with the graph of the line.
- State the correlation coefficient and interpret the strength of correlation between two data sets.
- Based on the model you created in part 1, what is the predicted weight of a 24-month-old baby boy?
- How realistic is the linear model here? In order to answer this question, consider a 30-year-old man. What is the predicted weight? How about 60-year-old male?
- The body of your paper should answer the questions posed in the problem, explain how you approached and answered the question or solved the problem, and for each question, show all steps involved.
- The conclusion should summarize your findings and what you have determined from the data and your analysis, with a broader or personal perspective in mind when applicable.
