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	69	67
2	61	49
3	52	46
4	89	88
5	76	94
6	97	96
7	90	82
8	102	110
9	104	103
10	86	81
11	68	62
12	94	84
13	58	56
14	69	76
15	99	94
16	85	87
17	75	78
18	83	80
19	94	116
20	50	69

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.18 and 1.48 Y Intercept for the Regression Equation =

Correlation Coefficient =

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

(Round to Nearest 100^th, 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