The table below shows the closing monthly stock prices for Amazon.com and Google
ID: 2745982 • Letter: T
Question
The table below shows the closing monthly stock prices for Amazon.com and Google during 2011. 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. Omit the "$" sign in your response.)
The table below shows the closing monthly stock prices for Amazon.com and Google during 2011. 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. Omit the "$" sign in your response.)
Explanation / Answer
Project 1 :
March = (175.04 + 176.89) / 2 = 175.96 * 0.333 = 58.60 + ( 191.47 * 0.667) = 186.31
April = (176.89 + 191.47 ) / 2 = 184.18 * 0.333 = 61.33 + ( 207.78 * 0.667 ) = 199.92
May = (191.47 + 207.78 ) / 2 = 199.63 * 0.333 = 66.48 + (192.37 * 0.667 ) = 194.79
June = ( 207.78 + 192.37 ) / 2 = 200.08 * 0.333 = 66.62 + ( 208.63 + 0.667 ) = 205.78
July = (192.37 +208.63 ) / 2 = 200.5 * 0.333 = 66.77 + ( 234.49 * 0.667) = 223.17
Aug = ( 208.63 + 234.49 ) /2 = 221.56 * 0.333 = 73.78 + ( 204.16 * 0.667 ) = 136.17
Sept = ( 234.49 + 204.16) / 2 = 219.33 * 0.333 = 73.04 + ( 220.55 * 0.667 ) = 220.15
Oct = ( 204.16 + 220.55 ) / 2 = 212.36 * 0.333 = 70.71 + ( 214.59 * 0.667 ) = 213.84
Nov = ( 220.55 + 214.59 ) / 2 = 217.57 * 0.333 = 72.45 + ( 196.34 * 0.667 ) = 203.41
Dec = ( 214.59 + 196.34 ) / 2 = 205.47 * 0.333 = 68.42 + ( 175.62 * 0.667) = 185.56
Project 2:
Mar = ( 613.41 + 623.12 ) / 2 = 618.27 * 0.333 = 205.88 + ( 574.07 * 0.667 ) = 588.78
Apr = ( 623.12 + 574 .07 ) / 2 = 598 .60 * 0.333 = 199.33 + ( 547.70 * 0.667 ) = 564.65
May = ( 574.07 + 547 .70 ) / 2 = 560.89 * 0.333 = 186.77 + ( 510.30 * 0.667 ) = 527 .14
Jun = ( 547 .70 + 510.30 ) / 2 = 529 * 0.333 = 176.16 + ( 495.58 * 0.667 ) = 506.71
Jul = ( 510.30 + 495 .58 ) / 2 = 502.94 * 0.333 = 167.48 + ( 606.39 * 0.667 ) = 571.94
Aug = ( 495.58 + 606.39 ) / 2 = 550.99 * 0.333 = 183.48 + ( 536.91 * 0.667 ) = 541.60
Sept = ( 606.39 + 536.91 ) / 2 = 571.65 * 0.333 = 190.36 + ( 512.70 * 0.667 ) = 532.33.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.