Question

The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

	IBM				AMZN
January	$	179.84		$	625.01
February		180.09			631.76
March		201.55			562.79
April		218.42			550.90
May		188.53			493.66
June		212.31			485.98
July		245.13			608.79
August		194.32			533.31
September		224.39			510.62
October		215.55			609.81
November		199.94			584.60
December		177.86			664.60

Answer 1

	IBM		3 MONTH MOVING AVERAGE			AMZN		3 MONTH MOVING AVERAGE
JAN	179.84					625.01
FEB	180.09					631.76
MAR	201.55		194.35*			562.79		584.65
APR	218.42		209.22			550.90		566.36
MAY	188.53		195.68			493.66		514.72
JUN	212.31		209.36			485.98		498.08
JUL	245.13		230.23			608.79		569.13
AUG	194.32		205.79			533.31		538.00
SEP	224.39		222.83			510.62		530.76
OCT	215.55		213.48			609.81		580.53
NOV	199.94		206.62			584.60		576.47
DEC	177.86		187.82			664.60		642.13
		FORMULA	CURRENT MONTH*2/3 + PREVIOUS MONTH*1/6 + PRECEDINGPREVIOUS YEAR *1/6
		*MARCH	201.55 *2/3 + 180.09*1/6 + 179.84*1/6
			194.35