excel assign 3

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:

 

Amount of Soda Consumed and Individual's Weight

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.

See PDF for videos.