Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Question 4 options: Cola Consumption The following data were taken from a study

ID: 2923210 • Letter: Q

Question

Question 4 options:


Cola Consumption

The following data were taken from a study relating the Days High Temperature to the Average Amount of Cola Consumed (per capita) in a small mid-western town.

Observation

Days High Temperature

Average Ounces of Cola Consumed

1

79

115

2

91

139

3

92

139

4

98

147

5

71

97

6

91

126

7

103

163

8

94

132

9

77

123

10

69

101

11

80

96

12

58

76

13

67

116

14

91

118

15

75

124

16

59

84

17

66

100

18

103

140

19

80

115

20

90

149



Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following:

Slope of Regression Equation =

Y Intercept for the Regression Equation =

Correlation Coefficient =

Coefficient of Determination =


Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23:
ColaConsumption (23)=

Observation

Days High Temperature

Average Ounces of Cola Consumed

1

79

115

2

91

139

3

92

139

4

98

147

5

71

97

6

91

126

7

103

163

8

94

132

9

77

123

10

69

101

11

80

96

12

58

76

13

67

116

14

91

118

15

75

124

16

59

84

17

66

100

18

103

140

19

80

115

20

90

149

Explanation / Answer

I will be rounding off all the values to 4 decimal places. By using regression tool, the required values are:

Slope = 1.4564

Y - Intercept = 1.0116

Correlation coefficient = 0.8842

Coefficient of determination = 0.7818

For x = 23,

y = 1.0116 + 1.4564(23) = 34.5088

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote