Please show do in excel and show the excel sheet with the formulas and how you got the answers!

Two different forecasting techniques $($F$1$ and F$2)$ were used to forecast sales. Actual sales and the two sets of forecasts

are as follows:

Period $123456$

Actual Sales $121413111718$

F$1101315101818$

F$2111512131517$

a$.$ Compute MAD for each forecasting technique. Which forecasting technique is more accurate based on the

MAD criterion?

b$.$ Compute the MSE for each set of forecasts. Which forecasting technique is more accurate based on the MSE

criterion?