Question: Submit the completed Forecasting Template that you built and use Moving Average Forecasts in Excel. Then do the Simple 3 period, Expo Smoothing, Linear Regression,
Submit the completed Forecasting Template that you built and use Moving Average Forecasts in Excel. Then do the Simple 3 period, Expo Smoothing, Linear Regression, and theTracking signal. All data should be formatted to show no more than two decimal places and the MAPE should be shown as a percentage with two decimal places. All worksheets should be completed and the tracking signal should use the data from the Weighted 3 Month Moving Average method.
| Year | Semester | GPA |
| First Year | Fall Winter Spring | 2.65 2.93 2.87 |
| Sophomore | Fall Winter Spring | 3.05 3.42 3.29 |
| Junior | Fall Winter Spring | 3.3 3.6 3.25 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
