Please show the formulas that i may put into microsoft excel i must show my professor the formulas in the cells on excel below.

Styles Cells Inactive. lo use for free, sign in and use the Web version. Activate Use free at Office.com B C D E F G H J K L Instructions Click on the Data Sheet in the next tab. 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, compute the corresponding error for each week, and then compute the overall MAPE for each method 3- Which of the four forecasting methods can you say best fit the data? Please provide your rationale for your choice 4- Save the Excel file with your last name and upload in the assignment dropbox on BB. Do not forget to sign the Honesty Pledge form in the first tab Rubric Honesty Pledge Question 1 Question 2 Question 3 Overall Content and Elaboration File Upload with last name Total Points 10 60 40 20 10 200 60Emergency calls to this city's 911 system, for the past 24 weeks are as follows: Forecasting and Error Analysis Moving Average Weighted Moving Average (n=2) Exponential Smoothing Data (n=4 and weights of 8, 6, 4, and 2) Exponential Smoothing Alpha 0.1 Alpha 0.8 Period Demand (calls) Period Forecast Error Forecast Error Week 1 Forecast 50 Error Forecast Week 1 Error Week 2 35 52 Week 2 52 Week 3 25 Week 3 Week 4 40 Week 4 Week 5 45 Week 5 Week 6 35 Week 6 Week 7 20 Week 7 Week 8 30 Week 8 Week 9 35 Week 9 Week 10 20 Week 10 Week 11 15 Week 11 Week 12 40 Week 12 Week 13 55 Week 13 Week 14 35 Week 14 Week 15 25 Week 15 Week 16 55 Week 16 Week 17 55 Week 17 Week 18 40 Week 18 Week 19 35 Week 19 Week 20 60 Week 20 Week 21 75 Week 21 Week 22 50 Week 22 Week 23 40 Week 23 Week 24 65 Week 24 Honesty Pledge Exercise Description Data