Question

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) Compute the forecasts using the naive forecasting method. What is the MAD? b) Compute the forecast for Senior Year- Fall Semester using the naive forecasting method c) Compute the forecasts using the two-period moving average. What is the MAPE? 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.35, and 0.25. What is the MAD? f) Compute the forecast for Senior Year- Fall Semester using the three-period weighted moving average using weights of 0.4, 0.35, and 0.25 g) Compute the forecasts using exponential smoothing with a smoothing constant of 0.25 and a forecast for First Year - Fall Semester of 2.60. What is the MSE? h) Compute the forecast for Senior Year - Fall Semester using exponential smoothing with a smoothing constant of 0.25 and a forecast for First Year- Fall Semester of 2.60 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 Fall 2.65 First Year Winter 2.93 Spring 2.87 Fall 3.05 Sophomore Winter 3.42 Spring 3.29 Fall 3.3 Junior Winter 3.6 Spring3.25

Answer 1

Solcct%ng asad on gRven data owS 283 2 3285-5 3 336 312 285.550.5 2 530-25 4 3 342311 5 406 336244 14111409 39 구 45 1 36 2 5 7 416 414 o 141 8435 43.5 414, 2 9428 431.5 43-5 G.25 35 u31.5 45 3-5 Ⅱ | 462 | 448-5 1431.5 305 12 452 457-0 448.5 3 424 463Y 1 46 45 463 2-25 930-25 2-25 299 6 c 477 1486.5 :475| 오2 u84 O.25 523 So42 34 523 ร25-5 |S05 | 23 53 2 530 525.5 6.9 20 52 542 30 961 S29 4 2.25 48 u S4 2 21 14 g76-7ら Cs Scanned with CamScanner

Piye D 283 +288 29s-S 2 486.s hecast Value hecast value teSh 24 is 542 e) (as Ye@i moaae bh sste value 33.75 Scned with CamScanner

Page dl 1 283 2 280 3 336 388 323.35 5 1406 1354 . 5 | 323 . จ518225 6 412 3553531-5 4 41L 405-5330.5 8 435419-2s 45.52-5 L42 444.5 33 2 452 s44012 13 u구4 45575 444,25 : 29.45 1 46 466 45 2o.25 15,4牪u7435 466 16 u67 32 18 3-5 .S 12.25 12 523 445 35 31-9 19 53257.5 So8 Ж| 20 552 5 23-25 $33-75 2-1 CS Scanned with CamScanner

336+389+ 283+288 ש -323.5 esno- Catul vaeocaste vae teValue 491 = 30.68 Cs Scanned wit CamScanner