This assignment is due Week 4
Please see attachment for assignment notes.
You now know the difference between correlation and causation. Although there are several different ways to make predictions, a regression analysis is one way to do so. The video above explains how to do a simple correlation, regression, and scatterplot in Excel.
Remember, you can always visit your Lifeline for more help. For this assignment, imagine you are looking for a link between soda consumption and weight. Here is your data set:
| Participant | Number of 12 ounce sodas consumed per day | Weight |
|---|---|---|
| 1 | 5 | 125 |
| 2 | 10 | 180 |
| 3 | 0 | 110 |
| 4 | 2 | 110 |
| 5 | 5 | 130 |
| 6 | 8 | 205 |
| 7 | 1 | 105 |
| 8 | 3 | 130 |
| 9 | 15 | 200 |
ASSIGNMENT INSTRUCTIONS
Following the instructions in the video, enter your data set on an Excel worksheet. Be sure and use the labels provided in the data set. Then:
- Perform a correlation and regression on the data in Excel.
- Create a scatterplot with a regression line for your data using Excel
- In a separate Word document, discuss your findings (3-4 paragraphs). Is there a significant relationship between soda consumption and weight? Explain how you know this. Using your regression, predict how a person’s soda consumption will impact their weight.
Submit your completed Excel worksheet and Word document.
0 comments