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. \begin{tabular}{|c|c|c|} \hline Observation & Days High Temperature & Average Ounces of Cola Consumed \\ \hline 1 & 53 & 59 \\ \hline 2 & 50 & 42 \\ \hline 3 & 89 & 78 \\ \hline 4 & 89 & 78 \\ \hline 5 & 97 & 94 \\ \hline 6 & 103 & 107 \\ \hline 7 & 71 & 84 \\ \hline 8 & 74 & 79 \\ \hline 9 & 58 & 44 \\ \hline 10 & 50 & 42 \\ \hline 11 & 96 & 99 \\ \hline 12 & 67 & 73 \\ \hline 13 & 79 & 84 \\ \hline 14 & 72 & 75 \\ \hline 15 & 75 & 67 \\ \hline 16 & 89 & 73 \\ \hline 17 & 98 & 79 \\ \hline 18 & 63 & 69 \\ \hline 19 & 69 & 84 \\ \hline 20 & 74 & 78 \\ \hline \end{tabular} 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.12 and 1.88 Y Intercept for the Regression Equation = A 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 Leave a Copy of your Excel Spreadsheet in the DropBox