Question

The table below shows the price per portion and the calories per portion for several different snack foods (source: USDA.gov).

Snack	Price Per Portion	Calories Per Portion
Chocolate Candy	0.24	262
Cookies	0.16	123
Corn chips	0.21	140
Crackers	0.16	114
Cupcakes	0.34	174
Danish	0.47	271
Donuts	0.36	235
Fruit Rolls	0.28	82
Graham crackers	0.14	102
Granola Bars	0.3	119
Ice Cream	0.39	196
Muffins	0.83	369
Pizza	0.63	252
Popsicles	0.34	80
Potato Chips	0.27	169
Pretzels	0.25	168
Pudding	0.38	152
Sandwich Crackers	0.2	183
Toaster Pastries	0.35	299
Tortilla Chips	0.21	161

a. Identify the scatter plot for the data.

Select your answer from one of the following options.

• a.Graph A
• b.Graph B
• c.Graph C

b. Use the Google Sheets command =CORREL to find the correlation coefficient r. Round your answer to 3 decimal places.

c. Use the commands =SLOPE and =INTERCEPT to find the line of best fit. Select the equation of the line of best fit from the choices below:Select your answer from one of the following options.

• a.y = 0.0015x + 0.0435
• b.y = 182.6x + 0.33
• c.y = 331.5x + 74.7
• d.y = 0.33x + 182.6
• e.y = 74.7 + 331.5x

d. Use the regression equation to predict the calories per portion for a snack that costs 0.24 per portion. Round your answer to the nearest whole number.

e. Chocolate Candy costs 0.24 per portion and has 262 calories. Using your answer to part c., calculate the residual for chocolate candy.

Answer 1

a) -

Scatter plot

b) -

b) Correlation coefficient r syntax is =CORREL(C3:C22,B3:B22)

0.715551023

0.716

Correlation coefficient r is 0.716.

c) -

c) slope of a line is given by syntax =SLOPE(C3:C22, B3:B22)

331.485428

331.5

Slope of the regression line is 331.5 .

intercept of line is given by syntax =INTERCEPT(C3:C22,B3:B22)

74.65149319

74.7

Intercept of regression line is 74.7.

Regression equation is -

Y = 74.7 + 331.5X

Option C is correct.

d) -

Predicted value for the calories per portion for a snack that costs 0.24 per portion -

Y = 74.7 + 331.5X = 74.7 + 331.5(0.24) = 74.7 + 79.56 = 154.26 154

calories per portion for a snack that costs 0.24 per portion is 154.

e) -

Residual = Y - = 262 - 154 = 108

Residual for the choclate candy is 108.