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	$	172.64		$	607.61
February		175.29			618.80
March		186.43			579.71
April		202.46			546.10
May		194.29			518.62
June		206.79			500.38
July		229.17			605.19
August		209.08			538.71
September		218.63			513.74
October		214.11			597.69
November		194.54			595.04
December		174.50			651.40

	IBM AMZN March April May June July August September October November December

Answer 1

3 months moving average is calculated by taking the average of every 3 months combination as shown in the below table:

1. Average period = January, February, March
2. Average period = February, March, April
3. Average period = March, April, May
4. Average period = April, May, June
5. Average period = May, June, July
6. Average period = June, July, August
7. Average period =July, August, September
8. Average period =August, September, October
9. Average period =September, October, November
10. Average period =October, November, December

IBM			3MA	Amazon			3MA
January	$172.64			January	$607.61
February	$175.29			February	$618.80
March	$186.43	(0.5*172.64+0.5*175.29+2*186.43)/3=	$182.28	March	$579.71	(0.5*607.61+0.5*618.8+2*579.71)/3=	$590.88
April	$202.46	(0.5*175.29+0.5*186.43+2*202.46)/3=	$195.26	April	$546.10	(0.5*618.8+0.5*579.71+2*546.1)/3=	$563.82
May	$194.29	(0.5*186.43+0.5*202.46+2*194.29)/3=	$194.34	May	$518.62	(0.5*579.71+0.5*546.1+2*518.62)/3=	$533.38
June	$206.79	(0.5*202.46+0.5*194.29+2*206.79)/3=	$203.99	June	$500.38	(0.5*546.1+0.5*518.62+2*500.38)/3=	$511.04
July	$229.17	(0.5*194.29+0.5*206.79+2*229.17)/3=	$219.63	July	$605.19	(0.5*518.62+0.5*500.38+2*605.19)/3=	$573.29
August	$209.08	(0.5*206.79+0.5*229.17+2*209.08)/3=	$212.05	August	$538.71	(0.5*500.38+0.5*605.19+2*538.71)/3=	$543.40
September	$218.63	(0.5*229.17+0.5*209.08+2*218.63)/3=	$218.80	September	$513.74	(0.5*605.19+0.5*538.71+2*513.74)/3=	$533.14
October	$214.11	(0.5*209.08+0.5*218.63+2*214.11)/3=	$214.03	October	$597.69	(0.5*538.71+0.5*513.74+2*597.69)/3=	$573.87
November	$194.54	(0.5*218.63+0.5*214.11+2*194.54)/3=	$201.82	November	$595.04	(0.5*513.74+0.5*597.69+2*595.04)/3=	$581.93
December	$174.50	(0.5*214.11+0.5*194.54+2*174.5)/3=	$184.44	December	$651.40	(0.5*597.69+0.5*595.04+2*651.4)/3=	$633.06