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

Year	Semester	GPA
Freshman	Fall Winter Spring	2,4 2,9 3,1
Sophomore	Fall Winter Spring	3,2 3,0 2,9
Junior	Fall Winter Spring	2,8 3,6 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 using 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?

Please show work in Excel