mmmmmmml

i need you to show me step by step on excel so that i know how to solve for future reference.

Question 2: Find the "UnitedDairies files. Develop a three-week moving average. 1. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) 2. What is the value of MSE (mean squared error) with regard to a three-week moving average? (Make sure no decimal place and no comma. EX: 1234) 3. Develop the exponential smoothing with the alpha value of 0.20. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) 4. What is the value of MSE (mean squared error) with regard to the exponential smoothing? (Make sure no decimal place and no comma. EX: 1234) 5. Which method is more accurate? (1 for Moving average, 2 for Exponential Smoothing) A B C D E F G 1 Week 1 2 3 4 5 6 7 OG OVOGA WN Sales 2750 3100 3250 2800 2900 3050 3300 3100 2950 3000 3200 3150 5 6 7 8 9 10 11 12 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Question 2: Find the "UnitedDairies files. Develop a three-week moving average. 1. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) 2. What is the value of MSE (mean squared error) with regard to a three-week moving average? (Make sure no decimal place and no comma. EX: 1234) 3. Develop the exponential smoothing with the alpha value of 0.20. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) 4. What is the value of MSE (mean squared error) with regard to the exponential smoothing? (Make sure no decimal place and no comma. EX: 1234) 5. Which method is more accurate? (1 for Moving average, 2 for Exponential Smoothing) A B C D E F G 1 Week 1 2 3 4 5 6 7 OG OVOGA WN Sales 2750 3100 3250 2800 2900 3050 3300 3100 2950 3000 3200 3150 5 6 7 8 9 10 11 12 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27