2. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $500? Hint: Use Excel to find the mean and standard deviation. Then find the z score.
3. If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $45 of the mean for that year? Hint: Find two z scores and use the Standard Normal Table.
4. Suppose a person within the last year claimed to have bought Google stock at closing at $700 per share. Would such a price be considered unusual? Explain by using the Empirical Rule, do not find the max or min values of the daily closing prices.
5. At what prices would Google have to close at in order for it to be considered statistically unusual? You should have a low and high value. Use the Empirical Rule.
6. What are Q1, Q2, and Q3 in this data set? Use Excel to find these values.
7. Is the normality assumption that was made at the beginning valid? Why or why not?
9/9/2013
883.73
889.75
882.42
888.05
1235064
9/6/2013
882.44
883.78
873.74
879.58
1561755
9/5/2013
873.5
879.88
871.61
879.56
1292601
9/4/2013
860.35
873.5
855.17
871.63
2041640
9/3/2013
854.36
866.19
853.95
860.38
2047736
8/30/2013
855.76
858.04
845.56
846.9
1861554
8/29/2013
849.07
860.38
848.59
855.43
1478494
8/28/2013
850.25
855.41
847.77
848.55
1330324
8/27/2013
859.62
863.73
847.9
850.15
1734031
8/26/2013
870
874.9
866.05
866.39
1056184
8/23/2013
877.83
878
869.75
870.21
1077093
8/22/2013
872.7
874.75
870.25
873.71
870491
8/21/2013
870.65
876.91
866.5
869.33
1761596
8/20/2013
868.35
872.11
863.54
865.42
1236259
8/19/2013
857.71
872
857.45
865.65
1811425
8/16/2013
861.28
862.44
856.54
856.91
1675387
8/15/2013
864.44
864.92
858
859.66
1870812
8/14/2013
878.37
880.23
867.16
869.81
2083229
8/13/2013
886.83
888.5
876.2
881.25
1420462
8/12/2013
886.9
887
881.65
885.51
1377354
8/9/2013
890.56
895.52
890
890.41
1323761
8/8/2013
895.49
895.84
885.3
892.66
1488045
8/7/2013
895.04
898.45
889.09
890.65
1380382
8/6/2013
904.69
909.71
895.73
896.57
1506475
8/5/2013
905.39
905.52
899.2
905
1309921
8/2/2013
903.44
907
900.82
906.57
1717765
8/1/2013
895
904.55
895
904.22
2138314
7/31/2013
892.99
896.51
886.18
887.75
2173446
7/30/2013
885.46
895.61
880.87
890.92
1756116
7/29/2013
884.9
894.82
880.89
882.27
1893042
7/26/2013
886.99
889.99
882
885.35
1778244
7/25/2013
893.87
896.85
886.08
887.7
3005227
7/24/2013
907.26
910.3
900.7
902.9
2080778
7/23/2013
910.7
913
899.57
903.8
2046745
7/22/2013
902
912.67
897
910.7
2904179
7/19/2013
886.61
902.95
875.61
896.6
7363398
7/18/2013
918.99
920
903.19
910.68
3634430
7/17/2013
921
926.86
916.3
918.55
1506168
7/16/2013
927.13
927.97
913.9
919.61
1983527
7/15/2013
924.3
928
916.36
924.69
1961361
7/12/2013
920
923
915.24
923
2568942
7/11/2013
913
920.81
908.52
920.24
2587845
7/10/2013
903.45
911.14
900.38
905.99
1715973
7/9/2013
911
912.95
897.98
905.24
19…
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
