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?