dx cut E Wrap Text Calibri A A General Rea Co Conditional Format as Cel B I & Ce
ID: 3201482 • Letter: D
Question
dx cut E Wrap Text Calibri A A General Rea Co Conditional Format as Cel B I & Center Format Painter Formatting Table Clipboard Number Alignment Daily Annual 1 Date open High Low close Volume Adj Close Daily Return 2 1/20/2017 806.91 806.91 801.69 805.02 1645000 805.02 0.35% Average 0.09% 22.89% 3 1/19/2017 805.12 809.48 801.8 802.175 912000 802.175 4 1/18/2017 805.81 806.205 800.99 806.07 1293300 806.07 Standard Deviation 1.44% 22.92% 5 1/17/2017 807.08 807.14 800.37 804.61 1355800 804.61 6 1/13/2017 807.48 811.224 806.69 807.88 1090100 807.88 7 1/12/2017 807.14 807.39 799.17 806.36 1 351000 80 36 -0.19% 8 1/11/2017 805 808.15 801.37 807.91 1057900 807.91 9 1/10/2017 807.86 809.13 803.51 804.79 1174300 804.79 10 1/9/2017 806.4 809.966 802.83 806.65 1272400 806.65 0.06% 1/6/2017 795.26 807.9 792.204 806.15 1620500 806.15 0.90% 12 1/5/2017 786.08 794.48 785.02 794.02 1315400 794.02 13 1/4/2017 788.36 791.34 783-16 786.9 1065400 786.9 0.10% 14 1/3/2017 778.81 789.63 775.8 786.14 1643100 786.14 1.86% 15 12/30/2016 782.75 782.78 770.41 771.82 1760200 771.82 .0.29% 16 12/29/2016 783.33 785.93 778.92 782.79 742200 782.79 17 12/28/2016 793.7 794.23 783.2 785.05 1132700 785.05 -0.82% 18 12/27/2016 790.68 797.86 787.657 791.55 789100 791.55 19 12/23/2016 790.9 792.74 787.28 789.91 62 3400 789.91 -0.17% 20 12/22/2016 792.36 793.32 788.58 791.26 969100 791.26 21 12/21/2016 795.84 796.676 787.1 794.56 1208700 794.56 22 12/20/2016 796.76 798.65 793.27 796.42 925100 796.42 23 12/19/2016 790.22 797.66 786.27 794.22 1225900 794.2 GOOG GSPC READY rt Delete Format Auto Sum A Sort & Find & Clear lter Select EditingExplanation / Answer
Here, X = mean - sigma
= 22.89 - 22.92
= - 0.03
mean = 22.89 , sigma = 22.92
By using central limit theorem,
z = (X - mean) / sigma
= (- 0.03 - 22.89) / 22.92
= -1
we need to find P(Z < X) by using z standard right tail,
P(Z < - 1) = 0.1587
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.