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 | $ | 169.64 | $ | 600.36 | ||||||||
February | 173.29 | 613.40 | ||||||||||
March | 180.13 | 586.76 | ||||||||||
April | 195.81 | 544.10 | ||||||||||
May | 196.69 | 529.02 | ||||||||||
June | 204.49 | 506.38 | ||||||||||
July | 222.52 | 603.69 | ||||||||||
August | 215.23 | 540.96 | ||||||||||
September | 216.23 | 515.04 | ||||||||||
October | 213.51 | 592.64 | ||||||||||
November | 192.29 | 599.39 | ||||||||||
December | 173.10 | 645.90 | ||||||||||
IBM | AMZN | |||
Price | Moving average | Price | Moving average | |
January | 169.64 | 600.36 | ||
February | 173.29 | 613.40 | ||
March | 180.13 | 174.35±1% | 586.76 | 600.17±1% |
April | 195.81 | 183.08±1% | 544.10 | 581.42±1% |
May | 196.69 | 190.88±1% | 529.02 | 553.29±1% |
June | 204.49 | 199.00±1% | 506.38 | 526.50±1% |
July | 222.52 | 207.90±1% | 603.69 | 546.36±1% |
August | 215.23 | 214.08±1% | 540.96 | 550.34±1% |
September | 216.23 | 217.99±1% | 515.04 | 553.23±1% |
October | 213.51 | 214.99±1% | 592.64 | 549.55±1% |
November | 192.29 | 207.34±1% | 599.39 | 569.02±1% |
December | 173.10 | 192.97±1% | 645.90 | 612.64±1% |
Explanation: | ||||
March - IBM = (169.64+173.29+180.13)/3 = 174.35 | ||||
April - IBM = (173.29+180.13+195.81)/3 = 183.08 |
Get Answers For Free
Most questions answered within 1 hours.