Question

The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the simple three-month moving average for each month for both companies. (Input all amounts as positive values. Do not round intermediate calculations. Round your answers to 2 decimal places.)

	IBM				AMZN
January	$	178.64		$	622.11
February		179.29			629.60
March		199.03			565.61
April		215.76			550.10
May		189.49			497.82
June		211.39			488.38
July		242.47			608.19
August		196.78			534.21
September		223.43			511.14
October		215.31			607.79
November		199.04			586.34
December		177.30			662.40

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

Answer 1

	IBM	AMZN
March	185.65	605.77
April	198.03	581.77
May	201.43	537.84
June	205.55	512.10
July	214.45	531.46
August	216.88	543.59
September	220.89	551.18
October	211.84	551.05
November	212.59	568.42
December	197.22	618.84

For 3 month moving average

--for the month of March, stock of Jan, Feb and March will be added and then divided by 3

--for April, stock of Feb, Mar and Apr will be added and divided by 3

--and so on