Question

Calories	Carbs
780	55
420	34
520	45
290	33
600	47
480	35
290	30
290	35
230	30
680	45
420	35
560	53
740	42
400	40
250	31
230	24
240	32
370	33
450	47
790	56
520	41
640	42
530	57
410	45
330	32
460	27
920	53
180	11
280	16
350	39
380	37
470	45
610	58
400	44
370	40
620	67
580	67
310	30
420	47
640	50
550	66
510	66
290	25
290	30
520	67
470	67
170	28
290	62
160	16
600	106
400	37
390	64
350	64
710	56
420	47
370	32
430	32
540	49

Predicting Calories
Carbs	40
Prediction

Calories and Carbohydrates

The data on the left contains nutrition information on the number of Calories and grams of carbohydrates for 58 sandwiches and similar items on McDonald's menu.

Problems

1. Run a regression of Calories (y-variable) on Carbs (x-variable). Be sure to include the scatterplot with the least squares line.

2. Interpret the slope of the regression in the context of the problem.

3. Interpret the R-square in the context of the problem.

4. Predict the number of calories for an item with 40 grams of carbohydrates. Type your answer in cell E4.

Please help. I am terrible with Excel. My scatter plot keeps coming out wrong. I need help with the steps.

Answer 1