Instructions:
“Please create the following models using the data below:
Two-period moving average
Five-period moving average
Two-period weighted moving average using weights of .8 and .2
Five-period weighted moving average using weights of .33, .27, .2, .13, .07
Please do the models for both the daily data and aggregated monthly data.
Assess each model using the MAPE method and let me know which model works best for both the daily and monthly aggregations. Also,
let me know whether we got a more accurate prediction using the daily or monthly version.”