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.

Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following: Slope of Regression Equation = A Hint: Value should be between -0.33 and 0.87 Y Intercept for the Regression Equation = Correlation Coefficient = A (Round to Nearest 100th, e.g., 0.9762123=0.98 ) Coefficient of Determination = A (Round to Nearest 100th, e.g., 0.95299=0.95 ) Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23: ColaConsumption (23)= A Unless otherwise stated, Round all answers to the nearest "100th", e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00 Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following: Slope of Regression Equation = A Hint: Value should be between -0.33 and 0.87 Y Intercept for the Regression Equation = Correlation Coefficient = A (Round to Nearest 100th, e.g., 0.9762123=0.98 ) Coefficient of Determination = A (Round to Nearest 100th, e.g., 0.95299=0.95 ) Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23: ColaConsumption (23)= A Unless otherwise stated, Round all answers to the nearest "100th", e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00