The following table shows a student$$s GPA for the last $9$ semesters:

Year Semester GPA

Freshman Fall $2\mathrm{.}5$

Freshman Spring $2\mathrm{.}2$

Freshman Summer $2\mathrm{.}7$

Sophomore Fall $3\mathrm{.}0$

Sophomore Spring $2\mathrm{.}6$

Sophomore Summer $3\mathrm{.}0$

Junior Fall $3\mathrm{.}2$

Junior Spring $2\mathrm{.}7$

Junior Summer $3\mathrm{.}3$

Report all answers rounded to $2$ decimals. Copy and paste table into excel to be efficient.

a$.$ Forecast the senior fall semester GPA using a $4-$period moving average.

b$.$ Forecast the senior fall semester GPA using exponential smoothing. Set $\backslash$alpha $=0\mathrm{.}4$ and start with a na$$ve forecast for the

freshman spring semester based on freshman fall for your first calculation $($which will be freshman summer$).$

c$.$ Create a linear trend equation in excel based on the gpa$$s provided. Forecast the next $2$ semesters $($senior fall and

spring$)$ using your trend equation where x$=1$ freshman fall. Interpret the trend equation.

d$.$ Do a na$$ve forecast for freshman spring through junior summer to calculate MAD, MSE, and MAPE for this forecasting

technique.