PURPOSE Complete the following two Excel problems and submit completed Excel files for grading. I ...

---

PURPOSE Complete the following two Excel problems and submit completed Excel files for grading. INSTRUCTIONS Part 1: Download the “Gasoline” data file and refer to the gasoline sales time series data. ·Compute four-week and five-week moving averages for the time series. Compute the MSE for the four-week and five-week moving average forecasts. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that the MSE for the three-week moving average is 10.22. Part II: Download the “Jefferson” data file attach. Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The data in the Jefferson data file shows the enrollment for Jefferson Community College for the nine most recent years. Construct a time series plot. What type of pattern exists in the data? Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. What is the forecast for year 10?