Statistics Question

PROJECT 3 INSTRUCTIONS: Probability & Stastics

Based on Larson & Farber: sections 6.1–6.3

Go to this website. Click the link on the right that says, “Download to Spreadsheet.” Set the date range to end on the first day (Tuesday) of Module/Week 5 and going back exactly 1 year. Assume that the closing prices of the stock form a normally distributed data set. Do not manually count values in the data set, but use the ideas found in sections 5.2–5.3. Answer the following:

1. 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 less than the mean for that year?

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?

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?

4. Suppose a person within the last year claimed to have bought Google stock at closing at $400 per share. Would such a price be considered unusual? Explain.

5. At what price would Google have to close at in order for it to be considered statistically unusual? You should have a low and high value.

6. What are Q1, Q2, and Q3 in this data set?

7. Is the assumption that was made at the beginning valid? Why or why not?

9-Apr-13

8-Apr-13

5-Apr-13

2-Apr-13

1-Apr-13

809.64

807.79

826.99

8-Mar-13

7-Mar-13

6-Mar-13

5-Mar-13

4-Mar-13

805.00

1-Mar-13

805.30

807.00

785.35

8-Feb-13 780.13

7-Feb-13

6-Feb-13

5-Feb-13

4-Feb-13

1-Feb-13

750.25

753.83

9-Jan-13

8-Jan-13

736.30

7-Jan-13

4-Jan-13

3-Jan-13 724.93

2-Jan-13

723.25

700.01

7-Dec-12

696.88

6-Dec-12

4-Dec-12 695.00

3-Dec-12

669.97

669.80

9-Nov-12

8-Nov-12

7-Nov-12 675.00

6-Nov-12

5-Nov-12

2-Nov-12

1-Nov-12

687.59

675.00

682.00

672.00

695.00

758.50

9-Oct-12

8-Oct-12

5-Oct-12

4-Oct-12

3-Oct-12

2-Oct-12

1-Oct-12

765.00

754.15

712.88

7-Sep-12 700.00

6-Sep-12

5-Sep-12 680.00 686.50

4-Sep-12

672.00

678.00

669.51

677.25

9-Aug-12

8-Aug-12

7-Aug-12

6-Aug-12

3-Aug-12

2-Aug-12

1-Aug-12

615.00

9-Jul-12

6-Jul-12

5-Jul-12

3-Jul-12

2-Jul-12

571.48

579.84

8-Jun-12

7-Jun-12

6-Jun-12

5-Jun-12

4-Jun-12

1-Jun-12

615.00

9-May-12

8-May-12

7-May-12

595.00

4-May-12

3-May-12

2-May-12

1-May-12

600.61

604.00

Date	Open	High	Low	Close	Volume
1	9-Apr-13	769.16	803.44	766.26	799.87	5804316
1	8-Apr-13		785.35	785.80	761.26	765.91	3328777
17-Apr-13	786.75	790.84	778.10	782.56	2037355
16-Apr-13	786.59	796.00	783.92	793.37	1742374
1	5-Apr-13	785.95	797.00	777.02	781.93	2454767
1	2-Apr-13	791.99	792.10	782.93	790.05	1636829
1	1-Apr-13	792.88	793.10	784.06	790.39	2028766
10-Apr-13	782.92	792.35	776.00	790.18	1978862
775.50	783.75	773.11	777.65	2157928
778.75	779.55	768.40	774.85	2832718
786.06	786.99	776.40	783.05	3433994
4-Apr-13	804.25	805.75	791.30	795.07	2448102
3-Apr-13	813.46	814.20	800.67	806.20	1738753
804.54	814.83	804.00	813.04	2041713
795.01	802.25	793.25	801.19	1807580
2	8-Mar-13	803.99	805.37	793.30	794.19	2287712
2	7-Mar-13	806.68		807.00	801.33	802.66	2163295
2	6-Mar-13	813.50	814.00		807.79	812.42	1191912
2	5-Mar-13	812.41	819.23	806.82		809.64	1712684
22-Mar-13	814.74	815.24	810.31	1491678
2	1-Mar-13	811.29	816.92	809.85	811.26	1477590
20-Mar-13	816.83	817.51	811.44	814.71	1464122
19-Mar-13	811.24	819.25	806.45	811.32	2098176
18-Mar-13		805.00	812.76	801.47	1838552
15-Mar-13	818.50	820.30	813.34	814.30	3099791
1	4-Mar-13		826.99	817.39	821.54	1651111
13-Mar-13	827.90	830.69	822.31	825.31	1641413
12-Mar-13	830.71	831.89	823.67	827.61	2008979
11-Mar-13	831.69	839.70	831.50	834.82	1595678
834.50	834.92	825.05	831.52	2912283
834.06	836.62	829.58	832.60	2054238
841.02	844.00	828.81	831.38	2873998
828.93	840.15	828.90	838.60	4045034
	805.30	822.84	821.50	2776185
797.80	807.14	796.15	806.19	2175425
2	8-Feb-13	801.10	806.99	801.03	801.20	2265874
2	7-Feb-13	794.80	804.75	791.11	799.78	2028515
2	6-Feb-13	795.00	795.95	784.40	790.13	2205059
2	5-Feb-13	802.30	808.41	790.49	790.77	2307008
22-Feb-13	799.26	801.25	793.80	799.71	2054050
2	1-Feb-13	798.00	805.45	791.22	795.53	3511036
20-Feb-13	808.97	791.79	792.46	2765029
19-Feb-13	795.99	795.28	806.85	2932924
15-Feb-13	787.40	793.26	787.07	792.89	2729917
1	4-Feb-13	779.73	788.74	777.77	787.82	1735219
13-Feb-13		780.13	779.97	782.86	1198170
12-Feb-13	781.75	787.90	779.37	780.70	1858945
11-Feb-13	778.40	783.00	773.75	782.42	2167656
786.67	779.56	785.37	3024853
769.70	778.81	765.50	773.95	2840506
759.07	772.96		758.50	770.17	2079687
761.13	771.11	759.46	765.74	1870716
767.69	770.47	758.27	759.02	3041242
758.20	776.60	758.10	775.60	3746165
31-Jan-13	750.51	757.62		750.25	755.69	1634556
30-Jan-13	753.74	760.95	752.91		753.83	1732972
2	9-Jan-13	746.75	756.95	746.54	753.68	1747734
2	8-Jan-13	751.76	755.60	747.89	750.73	1627833
25-Jan-13	750.77	758.48	753.67	2225811
2	4-Jan-13	741.24	756.83	740.51	3383596
2	3-Jan-13	735.99	749.00	735.79	741.50	5911865
2	2-Jan-13	704.66	705.34	695.52	702.87	3792336
18-Jan-13	710.36	712.77	701.33	704.51	3226898
1	7-Jan-13	717.71	719.64	711.02	711.32	2212357
16-Jan-13	722.40	724.34	713.67	715.19	2024991
15-Jan-13	719.33	735.00	712.10		724.93	3927990
14-Jan-13	737.00	742.20	722.35		723.25	2864106
11-Jan-13	742.00	742.43		736.30	739.99	1285125
10-Jan-13	742.83	745.00	733.50	741.48	1835780
732.27	738.35	728.60	738.12	2025751
735.54	724.43	733.30	1676740
735.45	739.38	730.58	734.75	1655967
729.34	741.47	727.68	737.97	2763552
731.93	720.72	723.67	2318140
719.42	727.00	716.55	2542268
31-Dec-12		700.00	710.57	696.00	707.38	1997733
28-Dec-12	701.69	706.91		700.01	1403926
2	7-Dec-12	707.14	708.84	698.61	706.29	1647392
2	6-Dec-12	708.07		712.88	702.41	708.87	1182572
2	4-Dec-12	714.51	715.18	707.47	709.50	841931
21-Dec-12	713.97	718.82	710.52	715.63	3527849
20-Dec-12	723.26	724.65	716.97	722.36	1657153
19-Dec-12	720.71	723.00	716.68	720.11	1919799
18-Dec-12	716.60	729.10	715.05	721.07	3005138
17-Dec-12	705.50	738.28	704.02	720.78	3036763
14-Dec-12	699.17	707.82	698.43	701.96	2130595
1	3-Dec-12	715.92	716.48	699.55	702.70	3446306
12-Dec-12	699.23	703.51	693.48	697.56	2426299
11-Dec-12	690.00	701.92	687.72		696.88	2687956
10-Dec-12	685.39	691.65	683.79	685.42	1366866
		695.00	682.42	684.21	1919476
	687.59	695.61	684.51	691.13	1462216
5-Dec-12	692.15	694.50	682.33	687.82	1862735
695.51	685.70	691.03	1991605
702.24	705.89	694.11	695.25	2193948
30-Nov-12	691.31	699.22	685.69	698.37	3164441
2	9-Nov-12	687.78	693.90		682.00	691.89	2780544
2	8-Nov-12	668.01	684.91	663.89	683.67	3041940
2	7-Nov-12	660.17			675.00	658.00	670.71	2509598
2	6-Nov-12	666.44	667.00	659.02	661.15	2205527
23-Nov-12		669.97	670.00	666.10	667.97	922477
2	1-Nov-12	668.99		669.80	660.40	665.87	2113011
20-Nov-12		669.51		678.00	664.57	2089086
19-Nov-12	655.70	668.92	655.53	668.21	2369716
16-Nov-12	645.99	653.02	636.00	647.18	3438500
1	5-Nov-12	650.00	660.00	643.90	647.26	1848939
14-Nov-12	660.66	662.18	650.50	652.55	1668322
13-Nov-12	663.00	667.60	658.23	659.05	1594639
1	2-Nov-12	663.75	660.87	665.90	1405870
654.65	668.34	650.30	663.03	3114084
670.20	671.49	651.23	652.29	2598676
678.23	666.49	667.12	2232438
685.48		686.50	677.55	681.72	1582936
684.50	686.86	675.56	682.96	1635894
694.79	695.55	687.37	687.92	2324569
679.50	690.90	678.72	2050471
3	1-Oct-12	679.86	681.00	680.30	1537001
26-Oct-12	676.50	683.03	671.20	675.15	1950865
2	5-Oct-12		680.00	673.51	677.76	2403696
2	4-Oct-12	686.80	687.00	675.27	677.30	2496411
2	3-Oct-12	672.01	687.33			672.00	680.35	2916978
2	2-Oct-12	681.01	684.63	669.70	678.67	4057872
1	9-Oct-12	705.58	706.70	681.79	11483428
1	8-Oct-12	755.54	759.42	676.00	12442346
17-Oct-12	743.95	756.34	740.26	755.49	2292819
16-Oct-12	740.13	746.99	736.46	744.70	2058468
15-Oct-12	741.94	743.83	730.70	740.98	3020098
12-Oct-12	751.85	754.87	744.10	744.75	2406787
11-Oct-12	752.90	750.29	751.48	2383987
10-Oct-12	741.86	747.53	738.29	744.56	2041203
759.67	761.32	742.53	744.09	3003884
761.00	763.58		754.15	757.84	1958625
770.71	774.38		765.00	767.65	2737751
762.75	769.89	759.40	768.05	2454496
755.72	763.92	752.20	762.50	2208639
765.20	765.99	750.27	756.99	2790375
759.05	756.21	761.78	3168477
28-Sep-12	759.30	751.15	754.50	2784091
2	7-Sep-12	759.95	762.84	751.65	756.50	3932272
2	6-Sep-12	749.85	761.24	741.00	753.46	5674334
2	5-Sep-12	753.05	764.89	747.66	749.16	6061033
2	4-Sep-12	731.00	750.04	730.25	749.38	3565837
21-Sep-12	732.21	734.92	730.12	733.99	6360376
20-Sep-12	724.47	731.38	721.22	728.12	2907854
19-Sep-12	717.50	728.56	716.41	727.50	3098782
18-Sep-12	707.78	718.66	706.78	718.28	2067249
17-Sep-12	708.11	705.00	709.98	1508307
14-Sep-12	709.60	713.00	707.01	709.68	2618874
13-Sep-12	693.09	709.00	690.54	706.04	2659302
12-Sep-12	689.41	694.91	680.88	690.88	2642260
11-Sep-12	697.96	700.65	691.00	692.19	1874004
10-Sep-12	709.76	712.81	698.39	700.77	2560067
712.25	697.67	706.15	3236308
685.96	699.89	684.73	699.40	3044450
679.14	680.72	1708169
684.55	685.00	673.50	681.04	1889613
3	1-Aug-12	684.00	688.58	680.04	685.09	2127125
30-Aug-12	684.24	687.39	680.18	681.68	1627704
2	9-Aug-12	677.37	688.99	676.15	688.01	2991037
2	8-Aug-12	665.00	677.62	664.74		677.25	2058938
2	7-Aug-12	662.99	659.24	669.22	2614131
24-Aug-12	675.60	680.45	674.08	678.63	1429267
2	3-Aug-12	674.27	680.48	671.00	676.80	1784453
2	2-Aug-12	667.38	680.60	666.70	677.18	1909262
21-Aug-12	673.11	662.17	2222805
20-Aug-12	675.50	678.87	672.66	675.54	1758421
17-Aug-12	674.12	671.70	677.14	2177896
1	6-Aug-12	667.51	674.64	667.08	672.87	1717691
15-Aug-12	670.28	674.25	664.10	667.54	2411100
14-Aug-12	659.25	672.85	659.00	668.66	3662178
13-Aug-12	647.42	660.15	646.68	660.01	3268073
10-Aug-12	638.59	642.24	636.13	642.00	1434408
644.51	646.37	641.52	642.35	1070288
639.05	645.87	638.50	642.23	1322386
641.79	644.26	636.47	640.54	1982695
639.61	649.38	639.22	642.82	1782494
640.00	643.72	636.14	641.33	1897446
625.51	638.03	623.41	628.75	1977690
637.30	639.51	631.38	632.68	1844556
31-Jul-12	628.26	636.50	628.22	632.97	1865890
30-Jul-12	636.05	642.60	629.50	632.30	2186717
27-Jul-12	618.89	635.00	617.50	634.96	3550174
2	6-Jul-12			615.00	616.87	610.03	613.36	1687485
2	5-Jul-12	608.32	613.38	605.37	607.99	1822973
24-Jul-12	617.93	604.34	607.57	2012189
2	3-Jul-12	600.48	618.35	598.25	615.51	3561818
20-Jul-12	608.76	612.94	598.18	610.82	6463748
1	9-Jul-12	586.14	598.48	586.00	593.06	4674637
18-Jul-12	576.98	583.69	576.13	580.76	1550950
17-Jul-12	578.43	580.67	568.40	576.73	1681568
16-Jul-12	576.37	579.19	571.78	574.92	1462861
13-Jul-12	572.15	579.15	568.55	576.52	1976558
1	2-Jul-12	567.12	571.93	562.09	570.48	2310094
11-Jul-12	576.30	577.85	564.94	571.19	3500946
10-Jul-12	590.19	592.43	578.74	581.70	1923015
584.95	588.60	581.25	586.01	1715020
592.45	593.52	582.82	585.98	2162328
588.76	600.06	588.54	595.92	2345901
580.01	588.41	578.00	587.83	1190525
581.82	583.00	576.50	580.47	1655563
29-Jun-12	574.96	580.13	572.20	580.07	2522562
2	8-Jun-12	565.90	566.23	557.21	564.31	1922064
2	7-Jun-12	567.70	573.99	566.02	569.30	1692446
2	6-Jun-12	562.76	566.60	559.48	564.68	1351151
2	5-Jun-12	567.33	568.09	557.35	560.70	1582036
22-Jun-12	568.00		571.48	565.82	2229125
2	1-Jun-12		579.84	563.73	565.21	2011322
20-Jun-12	579.81	580.00	573.51	577.51	2346698
19-Jun-12	573.59	584.28	573.12	581.53	2076629
18-Jun-12	562.62	574.21	559.25	570.85	2497864
15-Jun-12	560.34	564.52	557.09	564.51	3002511
1	4-Jun-12	561.30	565.07	556.52	559.05	2345107
13-Jun-12	561.72	567.00	558.68	561.09	1954607
12-Jun-12	569.77	570.30	558.58	565.10	3224142
11-Jun-12	584.21	585.32	566.69	568.50	2662269
575.85	581.00	574.58	580.45	1410366
587.60	587.89	577.25	578.23	1759532
576.48	581.97	573.61	580.57	2096173
575.45	578.13	566.47	570.41	2340477
570.22	580.49	570.01	578.59	2433786
571.79	572.65	568.35	570.98	3058314
3	1-May-12	588.72	590.00	579.00	580.86	2969455
30-May-12	588.16	591.90	583.53	588.23	1906629
2	9-May-12	595.81	599.13	588.32	594.34	2606651
25-May-12	601.00	601.73	588.28	591.53	3582472
2	4-May-12	609.16	611.92	598.87	603.66	1892185
2	3-May-12	601.65	609.60	597.12	609.46	3178016
2	2-May-12	613.44	613.81	596.00	600.80	3052748
21-May-12	600.51	615.69	600.00	614.11	3075829
1	8-May-12	625.10	632.42	596.70	600.40	5976129
1	7-May-12	633.83	637.85	621.23	623.05	3354518
16-May-12	617.96	630.10	615.94	628.93	4837424
15-May-12	605.35	603.75	611.11	2102339
14-May-12	600.78	608.50	600.58		604.00	1824733
11-May-12	610.35	614.55	604.77	605.23	2099726
10-May-12	612.96	616.19	610.23	613.66	1535877
606.82	616.38	601.81	609.15	2329546
605.53	616.90	600.70	612.79	2678485
	595.00	610.57	607.55	1994515
605.92	607.89	596.81	596.97	2207360
609.62	614.83	608.95	611.02	1868187
601.20	608.11		600.61	607.26	1611434
603.79	611.60	600.19	604.43	2002424
30-Apr-12	612.99	616.08	604.85	2407213
27-Apr-12	615.02	616.74	610.60	614.98	1636399
26-Apr-12	610.91	618.00	609.70	615.47	2093733
25-Apr-12	611.35	602.88	609.72	1821042
24-Apr-12	598.24	606.63	597.32	601.27	1933303
23-Apr-12	592.90	598.45	590.20	597.60	2197933