Question

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. M 2 _ IND 1 . Mariah Henderson is a WCU studen t who has just finished her junior year. The data in Worksheet IND 1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) Compute the forecasts using the naïve forecasting method .

What is the M AD ? b) Compute the forecast for Senior Year – Fall Semester using the naïve forecasting method . c) Compute the forecasts using the two - period moving average. What is the MA PE ? d) Compute the forecast for Senior Year – Fall Semester using the two - period moving average. e) Compute the forecasts using the three - period weighted moving average using weights of 0. 4 , 0.3 5 , and 0. 2 5 . What is the MA D ? f) Compute the forecast for Senior Year – Fall Semester using the three - period weighted moving average using weights of 0.4 , 0.35, an d 0.2 5 . g) Compute the forecasts using exponential smoothing with a smoothing constant of 0. 2 5 and a forecast for First Year – Fall Semester of 2 . 6 0 . What is the MSE? h) Compute the forecast for Senior Year – Fall Semester using exponential smoothing with a smoo thing constant of 0. 2 5 and a forecast for First Year – Fall Semester of 2. 6 0 . i) Comparing one of the error measurements (MAD, MSE, or MAPE) – which is the best forecasting method? Which is the worst forecasting method? Year Semester GPA First Year Fall 2.65 Winter 2.93 Spring 2.87 Sophomore Fall 3.05 Winter 3.42 Spring 3.29 Junior Fall 3.3 Winter 3.6 Spring 3.25

Answer 1

As per HomeworkLib policy we need to solve four sub parts per question. Please post the remaining questions in another post.