Emily Andrews has invested in a science and technology mutual fund. Now she is considering liquidating and

Fantastic news! We've Found the answer you've been seeking!

Question:

Emily Andrews has invested in a science and technology mutual fund. Now she is considering liquidating and investing in another fund. She would like to forecast the price of the science and technology fund for the next month before making a decision. She has collected the following data on the average price of the fund during the past 20 months:

a. Using a 3-month average, forecast the fund price for month 21.

b. Using a 3-month weighted average with the most recent month weighted 0.5, the next most recent month weighted 0.30, and the third month weighted 0.20, forecast the fund price for month 21.

c. Compute an exponentially smoothed forecast, using α=0.3, and forecast the fund price for month 21.

d. Compare the forecasts in (a), (b), and (c), using MAD, and indicate the most accurate.

Science and Technology Mutual Fund
					alpha =	0.3
	Month	Fund Price	3 mos moving average forecast	Weighted 3 mos moving average forecast	Exp Forecast		3 mos MA error	Weighted 3 mos MA error	Exp. Smoothing error
	1	55 3/4	----	----	----
	2	54 1/4	----	----
	3	55 1/8	----	----
	4	58 1/8
	5	53 3/8
	6	51 1/8
	7	56 1/4
	8	59 5/8
	9	62 1/4
	10	59 1/4
	11	62 3/8
	12	58
	13	58 1/8
	14	62 3/4
	15	64 3/4
	16	66 1/8
	17	68 3/4
	18	60 1/2
	19	65 7/8
	20	72 1/4
	21

				Please apply weights stated in the problem	Weight 0.5 (most recent), 0.3, 0.2


	Compute MAD on 3 mos moving average

	Compute MAD on weighted 3 mos moving average

	Compute MAD on the exponentially smoothed forecast

	Which is a better forecast method?