Question

*******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY SEE THEM******
TAKE PICTURES OF FORMULAS IN EXCEL AND PASTE THEM HERE. SHOW WHERE EACH CORRESPONDING FORMULA BELONGS IN EACH CELL, ETC

1. Moving Average Model (please review spreadsheet model of Forecast 1.xlsx.)

Given the annual sales (in $1000s) for a small business (See 1st worksheet in Assignment 2.xlsx), answer the following questions.

1. Please use 2-period Moving Average method to forecast the sales in Period 21. Show your result in the spreadsheet. (10 pts)
2. Please calculate the MSE by using this method. (5 pts)
3. Please try 4-period Moving Average method to forecast the sale in Period 21. Calculate the MSE by using this method. Comparing with the 2-period Moving Average method, which one is better, 2-period Moving Average method or 4-period Moving Average method? (5 pts)|
   
   ************Please show ALL WORK/FORMULAS (both in excel, written, and anything else). Highlight and summarize final answers in BOLD and keep in separate section**********************
   
   
   EXCEL TABLE THAT IS BEING REFERRED TO BELOW:

   Year	Sales
   1	283
   2	288
   3	336
   4	388
   5	406
   6	412
   7	416
   8	435
   9	428
   10	435
   11	462
   12	452
   13	474
   14	476
   15	497
   16	487
   17	523
   18	528
   19	532
   20	552

   
   
   ************Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY SEE THEM******
   TAKE PICTURES OF FORMULAS IN EXCEL AND PASTE THEM HERE. SHOW WHERE EACH CORRESPONDING FORMULA BELONGS IN EACH CELL, ETC

Answer 1

Below is the screenshot of the formula applied -

Below is the screenshot of the result obtained -

From above, MSE has the lowered value for 2 period moving average hence 2 period moving average is better.