The following table gives information on the amount of sugar (in grams) and the
ID: 3311833 • Letter: T
Question
The following table gives information on the amount of sugar (in grams) and the calorie count in one serving of a sample of 13 varieties of Kellogg's cereal.
Sugar (grams)
4
15
12
11
8
6
7
2
6
14
20
1
13
Calories
110
200
120
110
110
80
180
90
120
190
190
100
120
Find the predictive regression equation of the number of calories on the amount of sugar.
Carry out all calculations exactly, and round the final answers to three decimal places.
Which one?
Sugar (grams)
4
15
12
11
8
6
7
2
6
14
20
1
13
Calories
110
200
120
110
110
80
180
90
120
190
190
100
120
Explanation / Answer
The least square regression equation is ,
y = a + b * x
where , y = dependent variable
x = independent variable.
a = intercept
b = slope
In excel we can calculate a and b by using following commands,
For intercept(a) = INTERCEPT(KNOWNY_Y,KNOWN_X)
For slope ( b ) = SLOPE(KNOWNY_Y,KNOWN_X)
We get a = 83.413 and b = 5.341
We get the least square regression equation as
y^ = 83.413 +5.341*x
Option C is correct
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.