Sales for the past 12 months at computer success are given here: January 3,000 July 6,300 february 3,400 August 7,200 March 3,700 Sept 6,400 April 4,100 Oct 4,600 May 4,700 Nov 4,200 June 5,700 December 3,900 a. Use a 3-month moving average to forecast the sales for the months May through December b. Use a 4-month moving average to forecast the sales for the months May through December C. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend? d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend? e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Sales for the past 12 months at computer success are given here:
January 3,000 July 6,300
february 3,400 August 7,200
March 3,700 Sept 6,400
April 4,100 Oct 4,600
May 4,700 Nov 4,200
June 5,700 December 3,900
a. Use a 3-month moving average to
b. Use a 4-month moving average to forecast the sales for the months May through December
C. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend?
d. Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend?
e. Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Step by step
Solved in 1 steps