HP uses the AMD chip in some of its desktop computers. The prices for the chip during the last 12 months were as follows:
Month Price per Chip
A. Use a 2 month moving average on all the data and plot the averages and prices.
B. Use a 3 month moving average and add the 3 month plot to the graph created in part (A)
C. Which is better (using the mean absolute deviation): the 2 month average or the 3 month average?
D. Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80 Use α = .3, and finally α = .5 Using MAD, which α is the best?
Must show all work via excel.
This response compares the 2 month moving average and the 3 month moving average of HP.