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	68	73
2	77	61
3	85	67
4	96	83
5	64	30
6	80	56
7	69	57
8	59	53
9	94	79
10	90	79
11	50	53
12	59	47
13	97	80
14	82	64
15	70	65
16	104	80
17	91	75
18	99	101
19	104	84
20	98	91

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.75 and 1.45
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


Leave a Copy of your Excel Spreadsheet in the DropBox.

Save

Answer 1