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
Get step-by-step solutions from verified subject matter experts
