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 1.06 and 1.76 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 ) 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 1.06 and 1.76 Y Intercept for the Regression Equation = Correlation Coefficient = 100th, e.g., 0.9762123=0.98) Coefficient of Determination = 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 Leave a Copy of your Excel Spreadsheet in the DropBox