Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
HP uses the AMD chip in some of its desktop computers. The prices for the chip during the last 12 months were as follows:
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
Month Price per Chip
January $1.80
February $1.67
March $1.70
April $1.85
May $1.90
June $1.87
July $1.80
August $1.83
September $1.70
October $1.65
November $1.70
December $1.75
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.
