I need these 2 problems answered in excel format with the formulas showing please.

17. The chancellor of a small regional college is concerned about the declining freshman enrollment at his college. A number of factors have contributed to the decline, but the chancellor believes it is directly related to annual tuition increases. He has collected the following data for the past 8 years: Year 1 2 3 4 5 6 7 8 Freshman Enrollment 6,550 6,230 5,980 5.540 4,960 4,630 4.520 4.220 Annual Tuition (in U.S. dollars) 32,000 37.000 45,200 45,700 46,200 46,700 52,200 57,700 a. Develop a linear regression equation for forecasting freshman enrollment as a function of the annual tuition. b. Forecast freshman enrollment if the annual tuition increases by US$9,000 in Year 9. c. Evaluate the goodness of fit" of the regression equation by computing the values of R2,7, and syx and interpret the results. 18. The managers of Mayo Department Store want to evaluate the relationship between the sales of air conditioners and the average weekly temperature. The following weekly sales data along with the average daytime temperatures for 10 one-week periods are shown in the following table: Week 1 4 15 16 8 9 10 Air-Conditioner Sales (in units) 100 85 103 110 70 115 150 120 97 85 Average Temperature (in degrees Fahrenheit) 78 70 85 90 75 94 101 98 86 80 a. Develop a linear regression equation for air conditioner sales as a function of the average weekly temperature. b. Forecast air conditioner sales if the average weekly temperature is 88 degrees Fahrenheit. c. Evaluate the "goodness of fit" of the regression equation by computing the values of R2,7, and syx and interpret the results