Excel sheet computations

Feel free to add as many columns as needed to do your work. Make sure to show your work (meaning all computations required for forecasting and errors for all weeks and all 4 methods, as well as MAPE for each method).You need to show all the forecasting computations, and all individual error computations for all methods. Important note: The excel sheet computations need to be obtained using formula and NOT entered as values. Any work submitted as pasted values will not count

Instructions:

Using the provided data, compute the following 4 tasks:                                                                                                                  

1- Compute forecasting for that data using 4 methods:                                                                                                                                     

a- Simple moving average with n= 2                                                                                                          

b- Weighted moving average with n=4 and weights of 8, 6, 4, and 2                                                                                                                       

c- Exponential smoothing with alpha= 0.1 (assuming initial forecast of 52)

d- Exponential Smoothing with alpha=0.8 (assuming initial forecast of 52)

2- For each of the four forecasting methods produced, compute the corresponding error for each week, and then compute the overall MAPE for each method (do this task on third Tab:Data)

3- Which of the four forecasting methods can you say best fit the data? Please provide your rationale for your choice (type your answer on the Exercise Question Tab)

MAKE SURE AGAIN TO SHOW YOUR WORK AND TO HAVE ALL COMPUTATIONS PERFORMED USING FORMULA AND NOT JUST PASTED STATIC NUMBERS

The post Excel sheet computations appeared first on PapersSpot.