PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER ONLY EXCEL.

1. The department manager using a combination of methods has forecast sales of toasters at a local department store. Calculate the MAD for the manager's forecast. Compare the manager's forecast against a naive forecast covering the same time period. Which is better?

Month	Actual	Manager's	Abs. Error	Naive	Abs. Error
January	52
February	61
March	73
April	79
May	66
June	51
July	47	50
August	44	55
September	30	52
October	55	42
November	74	60
December	125	75