Module 2 Individual Assignment Problems Note: Data for these problems are in the Module 2 Individual Assignments Data file -there is a tab for each problem, All answers should be entered using two decimal places unless otherwise specified. If both decimal places are zeros-then just enter the integer value. Percentages should be entered without "%"sign- 3.45% should be entered as 3.45. M2 IND1. Mariah Henderson is a WCU student who has just finished her junior year. The data in Worksheet IND1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) b) c) d) e) Compute the forecasts using the naive forecasting method. What is the MAD? Compute the forecast for Senior Year - Fall Semester using the naive forecasting method. Compute the forecasts using the two-period moving average. What is the MAPE? Compute the forecast for Senior Year -Fall Semester using the two-period moving average Compute the forecasts using the three-period weighted moving average using weights of 0.4 0.35, and 0.25. What is the MAD? f) Compute the forecast for Senior Year-Fall Semester using the three-period weighted moving 8) Compute the forecasts using exponential smoothing with a smoothing constant of 0.25 and a h) Compute the forecast for Senior i) Comparing one of the error measurements (MAD, MSE, or MAPE)- which is the best forecasting average using weights of 0.4, 0.35, and 0.25. forecast for First Year-Fall Semester of 2.60. What is the MSE? smoothing constant of 0.25 and a forecast for First Year-Fall Semester of 2.60 method? Which is the worst forecasting method? Year Fall Semester using exponential smoothing with a M2 IND2. A regional limousine service examined their routes for the past 15 weeks. The data in Worksheet IND2 provides and record of the total miles drive in each week. Compute the forecasts using the four-period moving average. What is the MAPE? Compute the forecast for Week 16 using the four-period moving average. Compute the forecasts using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20,000. What is the MAD? Compute the forecast for Week 16 using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20000. Compute the forecasts using linear regression using Excel's slope and intercept function. What is the MAD? Compute the forecast for Week 16 using linear regression. Comparing one of the error measurements (MAD, MSE, or MAPE)- which is the best forecasting method? Which is the worst forecasting method? a) b) c) d) e) f) 8) Jr 36 Year Semester GPA Fall 2.65 3 First Year Winter 2.9 Spring2.87 3.05 6 Sophomore Winter 3.42 3.29 3.3 9 Junior Winter 9 Junior Winter3.6 3.25 24 37 40 41 43 45 47 49 ND1 IND2 IND3 IND4 1, 2 3 4 5 6 7 8 9 10 1 2 3