Cola Consumption - *I am offering more points on this one because I also need an
ID: 403396 • Letter: C
Question
Cola Consumption - *I am offering more points on this one because I also need an excel spreadsheet on this one.*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 84 109 2 97 126 3 85 117 4 75 99 5 82 105 6 58 63 7 88 127 8 84 122 9 67 98 10 74 90 11 69 105 12 55 75 13 95 117 14 101 138 15 91 115 16 65 99 17 68 103 18 104 144 19 62 102 20 83 102
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.29 and 1.79
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 %u201C100th%u201D, e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00
Leave a Copy of your Excel Spreadsheet in the DropBox. Cola Consumption - *I am offering more points on this one because I also need an excel spreadsheet on this one.*
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 84 109 2 97 126 3 85 117 4 75 99 5 82 105 6 58 63 7 88 127 8 84 122 9 67 98 10 74 90 11 69 105 12 55 75 13 95 117 14 101 138 15 91 115 16 65 99 17 68 103 18 104 144 19 62 102 20 83 102
Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following:
Slope of Regression Equation = Observation Days High Temperature Average Ounces of Cola Consumed 1 84 109 2 97 126 3 85 117 4 75 99 5 82 105 6 58 63 7 88 127 8 84 122 9 67 98 10 74 90 11 69 105 12 55 75 13 95 117 14 101 138 15 91 115 16 65 99 17 68 103 18 104 144 19 62 102 20 83 102 Hint: Value should be between 0.29 and 1.79
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 %u201C100th%u201D, e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00
Leave a Copy of your Excel Spreadsheet in the DropBox. Observation Days High Temperature Average Ounces of Cola Consumed 1 84 109 2 97 126 3 85 117 4 75 99 5 82 105 6 58 63 7 88 127 8 84 122 9 67 98 10 74 90 11 69 105 12 55 75 13 95 117 14 101 138 15 91 115 16 65 99 17 68 103 18 104 144 19 62 102 20 83 102
Explanation / Answer
SUMMARY OUTPUT Regression Statistics Multiple R 0.88502995 R Square 0.783278012 Adjusted R Square 0.771237902 Standard Error 9.247881509 Observations 20 ANOVA df SS MS F Significance F Regression 1 5563.780377 5563.780377 65.05571663 2.1808E-07 Residual 18 1539.419623 85.5233124 Total 19 7103.2 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 13.39276946 11.88602456 1.126766094 0.274639226 -11.578842 38.3643804 -11.578842 38.36438042 Days High Temperature 1.189757159 0.147508007 8.065712407 2.18078E-07 0.87985434 1.49965998 0.87985434 1.499659981