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 Consumed1 78 1042 64 803 62 854 70 855 65 1026 82 1107 75 988 73 999 76 10210 92 10311 91 12412 70 9813 52 6814 66 9415 71 11016 68 8617 91 12818 64 8519 87 11520 93 127Given 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.82 and 1.82Y 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