Jeannette Phan is a college student who has just completed her junior year. The following table summarizes her grade point average (GPA) for each of the past nine semesters:

(a) Forecast Jeannette€™s GPA for the fall semester of her senior year by using a three-period moving average.
(b) Forecast Jeannette€™s GPA for the fall semester of her senior year by using exponential smoothing with a = 0.3.
(c) Which of the two methods provides a more ac-curate forecast? Justify your answer.
(d) If you decide to use a three-period weighted moving average, find the optimal weights that would minimize MAPE. Is this method an improvement over the previous two methods?

Transcribed Image Text:

YEAR GPA SEMESTER Fall Winter Spring Fall Winter Spring Fall Winter Spring Freshman 2.4 Sophomore 3.2 3.0 2.8 3.6 3.2 Junior