Jeanette 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 9 semesters.
Year Semester GPA
Freshman Fall 2.4
Winter 2.9
Spring 3.1
Sophomore Fall 3.2
Winter 3.0
Spring 2.9
Junior Fall 2.8
winter 3.6
spring 3.2
A) Forecast Jeanette's GPA for the fall semester of her senior year by using a three-period moving average.
B) Forecast Jeanette's GPA for the fall semester of her senior year by ysing exponential smoothing with a=0.3.
C) Which of the two methods provides a more accurate 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?
Show work in excel