Question: 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

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

83

70

2

74

64

3

63

65

4

87

67

5

58

43

6

60

42

7

87

77

8

98

88

9

68

48

10

71

56

11

92

86

12

69

69

13

53

54

14

88

83

15

50

46

16

103

83

17

78

63

18

61

61

19

67

53

20

92

74

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

Hint: Value should be between -0.09 and 1.11 Y Intercept for the Regression Equation =

Correlation Coefficient =

(Round to Nearest 100th, e.g., 0.9762123 = 0.98) Coefficient of Determination =

(Round to Nearest 100th, e.g., 0.95299 = 0.95) Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23: ColaConsumption (23)=

Unless otherwise stated, Round all answers to the nearest 100th, e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!