The following screen shot is the data on the Amazon stock prices from August 8,
ID: 3353315 • Letter: T
Question
The following screen shot is the data on the Amazon stock prices from August 8, 2016 through August 19, 2016. Use the data below to answer the questions Daily prices Date Aug 19, 2016 Aug 18, 2016 Aug 17, 2016 Aug 16, 2016 Aug 15, 2016 Aug 12, 2016 Aug 11, 2016 Aug 10, 2016 Aug 9, 2016 Aug 8, 2016 Aug 24, 2015-Aug 22,2016 Update Volume 2,343,237 1,458,834 1,891,116 1,604,561 2,118,521 1,563,318 2,019,740 1,604,280 1,876,09-1 1,986,27:2 High Close 761.90 762.49756.89 757.31 764.00 765.17760.60 764.46 764.41765.22 759.20 764.63 768.62 768.73 763.82 764.04 771.90 772.04767.71 768.49 768.46 773.15 768.42 772.56 769.94773.75769.12 771.24 769.80772.10 766.19 768.56 767.39772.60 766.90 768.31 766.81767.00 761.02 766.56 Open Low 1. What is the mean of the high prices? Round your answer to two digits past the decimal 2. What is the standard deviation of the high prices? Round your answer to two digits past the decimal 3. What is the interval of values for high price that are within two standard deviations of the mean?Explanation / Answer
high 762.49 765.17 765.22 768.73 772.04 773.15 772.1 772.6 767 mean 768.7222 sd 3.933032 lower 760.8562 upper 776.5883 high 762.49 765.17 765.22 768.73 772.04 773.15 772.1 772.6 767 mean =AVERAGE(B2:B10) sd =STDEV(B2:B10) lower =B12-2*B13 upper =B12+2*B13