In: Statistics and Probability
The chart below shows the caloric content and the sodium content(in milligrams) for
10 beef hot dogs (Source: Consumer Reports).
Calories,x 150 170 120 120 90 180 170 140 90 110
Sodium, y 420 470 350 360 270 550 530 460 380 330
(a) Graph a scatter diagram of the table and nd the equation of the regression
equation and plot it on the same scatter diagram to see the regression line.
(b) What is the correlation coefficient(r) of the model?
(c) If x=210 milligrams, predict the sodium level.
1. Bring ddata in to excel sheet
2.Select both x and y variable and insert scatter plot chart. Select any data point in the excel and add trend line. n the format trend line option choose "Linear" and also select "Display an equation on chart"
Linear regression Equation: y = 2.4715x + 80.813
(b) What is the correlation coefficient(r) of the model?
r = 0.91 (Positive and strong linear relationship)
(c) If x=210 milligrams, predict the sodium level.
y = 2.4715x + 80.813
y = 2.4715*210 + 80.813
y = 600 (rounded as whole number)
The prediceted sodium leverl is 600