Calculate the mean absolute deviation mad based on a 2-day


Daily high temperatures in degrees Fahrenheit in the city of Lubbuck for the last week have been as follows: 93, 94, 93, 95, 96, 88, 90. Using Excel's Data Analysis add-in,

a. Forecast the high temperature today, using a 3-day moving average.

b. Forecast the high temperature today, using a 2-day moving average.

c. Calculate the mean absolute deviation (MAD) based on a 2-day and a 3-day moving average. Compare the two MAD results. Which forecasting method provides a lower MAD?

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Calculate the mean absolute deviation mad based on a 2-day
Reference No:- TGS02488961

Expected delivery within 24 Hours