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

$$

b$.$ Forecast the senior fall semester GPA using exponential smoothing.$$ Set $=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.

$$

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$