In: Statistics and Probability
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.
1:)
A. Run a regression of Calories (y-variable) on Carbs (x-variable). Be sure to include the scatterplot with the least squares line.
B. Interpret the slope of the regression in the context of the problem.
C. Interpret the R-square in the context of the problem.
D. Predict the number of calories for an item with 40 grams of carbohydrates. Type your answer in cell E4.
Data set:
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 |