1. If a person bought 1 share of Google stock within the last year, what is the probability that the...

Question

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? Hint: Use the Empirical Rule; do not calculate the mean. The answer is easy. 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?data set 	Date	Open	High	Low	Close	Volume 	9-Sep-13	883.73	889.75	882.42	888.05	1235064 	6-Sep-13	882.44	883.78	873.74	879.58	1561755 	5-Sep-13	873.5	879.88	871.61	879.56	1292601 	4-Sep-13	860.35	873.5	855.17	871.63	2041640 	3-Sep-13	854.36	866.19	853.95	860.38	2047736 	30-Aug-13	855.76	858.04	845.56	846.9	1861554 	29-Aug-13	849.07	860.38	848.59	855.43	1478494 	28-Aug-13	850.25	855.41	847.77	848.55	1330324 	27-Aug-13	859.62	863.73	847.9	850.15	1734031 	26-Aug-13	870	874.9	866.05	866.39	1056184 	23-Aug-13	877.83	878	869.75	870.21	1077093 	22-Aug-13	872.7	874.75	870.25	873.71	870491 	21-Aug-13	870.65	876.91	866.5	869.33	1761596 	20-Aug-13	868.35	872.11	863.54	865.42	1236259 	19-Aug-13	857.71	872	857.45	865.65	1811425 	16-Aug-13	861.28	862.44	856.54	856.91	1675387 	15-Aug-13	864.44	864.92	858	859.66	1870812 	14-Aug-13	878.37	880.23	867.16	869.81	2083229 	13-Aug-13	886.83	888.5	876.2	881.25	1420462 	12-Aug-13	886.9	887	881.65	885.51	1377354 	9-Aug-13	890.56	895.52	890	890.41	1323761 	8-Aug-13	895.49	895.84	885.3	892.66	1488045 	7-Aug-13	895.04	898.45	889.09	890.65	1380382 	6-Aug-13	904.69	909.71	895.73	896.57	1506475 	5-Aug-13	905.39	905.52	899.2	905	1309921 	2-Aug-13	903.44	907	900.82	906.57	1717765 	1-Aug-13	895	904.55	895	904.22	2138314 	31-Jul-13	892.99	896.51	886.18	887.75	2173446 	30-Jul-13	885.46	895.61	880.87	890.92	1756116 	29-Jul-13	884.9	894.82	880.89	882.27	1893042 	26-Jul-13	886.99	889.99	882	885.35	1778244 	25-Jul-13	893.87	896.85	886.08	887.7	3005227 	24-Jul-13	907.26	910.3	900.7	902.9	2080778 	23-Jul-13	910.7	913	899.57	903.8	2046745 	22-Jul-13	902	912.67	897	910.7	2904179 	19-Jul-13	886.61	902.95	875.61	896.6	7363398 	18-Jul-13	918.99	920	903.19	910.68	3634430 	17-Jul-13	921	926.86	916.3	918.55	1506168 	16-Jul-13	927.13	927.97	913.9	919.61	1983527 	15-Jul-13	924.3	928	916.36	924.69	1961361 	12-Jul-13	920	923	915.24	923	2568942 	11-Jul-13	913	920.81	908.52	920.24	2587845 	10-Jul-13	903.45	911.14	900.38	905.99	1715973 	9-Jul-13	911	912.95	897.98	905.24	1979338 	8-Jul-13	899.21	906.27	897.08	905.09	1970157 	5-Jul-13	890.01	895.41	887.34	893.49	1701830 	3-Jul-13	879.9	889.17	878.5	886.43	1048628 	2-Jul-13	890.2	891	877.27	882.31	1891812 	1-Jul-13	886.45	892.08	885	887.88	1726780 	28-Jun-13	874.9	881.84	874.19	880.37	2350049 	27-Jun-13	878.8	884.69	876.65	877.07	1926554 	26-Jun-13	873.75	878	870.57	873.65	1832735 	25-Jun-13	877.26	879.68	864.51	866.2	2553889 	24-Jun-13	871.88	876.32	863.25	869.79	3020242 	21-Jun-13	888.34	889.88	873.07	880.93	3982214 	20-Jun-13	893.99	901	883.31	884.74	3377578 	19-Jun-13	901.37	910.84	897.5	900.68	2917112 	18-Jun-13	888.65	901	888.35	900.62	2167878 	17-Jun-13	879.23	889.43	878.28	886.25	2147298 	14-Jun-13	880.1	884.7	874.13	875.04	2242338 	13-Jun-13	868.98	879.66	865.5	877	2071259 	12-Jun-13	885.46	886	869.65	871.98	2205049 	11-Jun-13	883.97	887	879.52	879.81	1752874 	10-Jun-13	882.1	891	880.09	890.22	2338184 	7-Jun-13	870.42	880	865.32	879.73	2675269 	6-Jun-13	864.3	866.33	847.22	864.64	2579605 	5-Jun-13	862.51	869.45	857.13	859.7	2107041 	4-Jun-13	867.85	870.59	854.07	859.1	1868745 	3-Jun-13	863.54	873.97	855.02	867.63	2476996 	31-May-13	868.12	877	867.52	871.22	1969857 	30-May-13	869.92	878.9	866.41	870.76	2120987 	29-May-13	875.71	877.99	864.29	868.31	2014246 	28-May-13	883.5	892.14	880.4	881.27	2257714 	24-May-13	875.26	878.82	871.01	873.32	2296760 	23-May-13	877	889.96	874	882.79	2279347 	22-May-13	902.56	909.31	886.88	889.42	2551309 	21-May-13	908.02	911.66	897.61	906.97	1983385 	20-May-13	905	920.6	905	908.53	2272942 	17-May-13	910.02	913.49	900.52	909.18	2792663 	16-May-13	919	919.98	902.01	903.87	3211738 	15-May-13	895.5	916.38	894.02	915.89	3995319 	14-May-13	877.5	888.69	877.14	887.1	1581296 	13-May-13	878.89	882.47	873.38	877.53	1448730 	10-May-13	875.31	880.54	872.16	880.23	1900717 	9-May-13	870.84	879.66	868.23	871.48	2200758 	8-May-13	857	873.88	852.91	873.63	2468403 	7-May-13	863.01	863.87	850.67	857.23	1967986 	6-May-13	848.26	861.85	848.26	861.55	2141834 	3-May-13	836.96	846.8	836	845.72	2512661 	2-May-13	820.1	834.55	819.05	829.61	2018546 	1-May-13	823.26	824.72	816.36	820.43	1455634 	30-Apr-13	819	827.64	817.68	824.57	2306836 	29-Apr-13	803.25	822.7	803	819.06	2301967 	26-Apr-13	807.6	807.74	796.58	801.42	2488237 	25-Apr-13	816.25	816.47	807.63	809.1	1992301 	24-Apr-13	808.11	818	808	813.45	1829151 	23-Apr-13	801	815.5	800.36	807.9	2299900 	22-Apr-13	800.6	803.96	775	800.11	2883407 	19-Apr-13	769.16	803.44	766.26	799.87	5804316 	18-Apr-13	785.35	785.8	761.26	765.91	3328777 	17-Apr-13	786.75	790.84	778.1	782.56	2037355 	16-Apr-13	786.59	796	783.92	793.37	1742374 	15-Apr-13	785.95	797	777.02	781.93	2454767 	12-Apr-13	791.99	792.1	782.93	790.05	1636829 	11-Apr-13	792.88	793.1	784.06	790.39	2028766 	10-Apr-13	782.92	792.35	776	790.18	1978862 	9-Apr-13	775.5	783.75	773.11	777.65	2157928 	8-Apr-13	778.75	779.55	768.4	774.85	2832718 	5-Apr-13	786.06	786.99	776.4	783.05	3433994 	4-Apr-13	804.25	805.75	791.3	795.07	2448102 	3-Apr-13	813.46	814.2	800.67	806.2	1738753 	2-Apr-13	804.54	814.83	804	813.04	2041713 	1-Apr-13	795.01	802.25	793.25	801.19	1807580 	28-Mar-13	803.99	805.37	793.3	794.19	2287712 	27-Mar-13	806.68	807	801.33	802.66	2163295 	26-Mar-13	813.5	814	807.79	812.42	1191912 	25-Mar-13	812.41	819.23	806.82	809.64	1712684 	22-Mar-13	814.74	815.24	809.64	810.31	1491678 	21-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	812.76	801.47	807.79	1838552 	15-Mar-13	818.5	820.3	813.34	814.3	3099791 	14-Mar-13	826.99	826.99	817.39	821.54	1651111 	13-Mar-13	827.9	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.7	831.5	834.82	1595678 	8-Mar-13	834.5	834.92	825.05	831.52	2912283 	7-Mar-13	834.06	836.62	829.58	832.6	2054238 	6-Mar-13	841.02	844	828.81	831.38	2873998 	5-Mar-13	828.93	840.15	828.9	838.6	4045034 	4-Mar-13	805.3	822.84	805	821.5	2776185 	1-Mar-13	797.8	807.14	796.15	806.19	2175425 	28-Feb-13	801.1	806.99	801.03	801.2	2265874 	27-Feb-13	794.8	804.75	791.11	799.78	2028515 	26-Feb-13	795	795.95	784.4	790.13	2205059 	25-Feb-13	802.3	808.41	790.49	790.77	2307008 	22-Feb-13	799.26	801.25	793.8	799.71	2054050 	21-Feb-13	798	805.45	791.22	795.53	3511036 	20-Feb-13	805.3	808.97	791.79	792.46	2765029 	19-Feb-13	795.99	807	795.28	806.85	2932924 	15-Feb-13	787.4	793.26	787.07	792.89	2729917 	14-Feb-13	779.73	788.74	777.77	787.82	1735219 	13-Feb-13	780.13	785.35	779.97	782.86	1198170 	12-Feb-13	781.75	787.9	779.37	780.7	1858945 	11-Feb-13	778.4	783	773.75	782.42	2167656 	8-Feb-13	780.13	786.67	779.56	785.37	3024853 	7-Feb-13	769.7	778.81	765.5	773.95	2840506 	6-Feb-13	759.07	772.96	758.5	770.17	2079687 	5-Feb-13	761.13	771.11	759.46	765.74	1870716 	4-Feb-13	767.69	770.47	758.27	759.02	3041242 	1-Feb-13	758.2	776.6	758.1	775.6	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 	29-Jan-13	746.75	756.95	746.54	753.68	1747734 	28-Jan-13	751.76	755.6	747.89	750.73	1627833 	25-Jan-13	750.77	758.48	750.25	753.67	2225811 	24-Jan-13	741.24	756.83	740.51	753.83	3383596 	23-Jan-13	735.99	749	735.79	741.5	5911865 	22-Jan-13	704.66	705.34	695.52	702.87	3792336 	18-Jan-13	710.36	712.77	701.33	704.51	3226898 	17-Jan-13	717.71	719.64	711.02	711.32	2212357 	16-Jan-13	722.4	724.34	713.67	715.19	2024991 	15-Jan-13	719.33	735	712.1	724.93	3927990 	14-Jan-13	737	742.2	722.35	723.25	2864106 	11-Jan-13	742	742.43	736.3	739.99	1285125 	10-Jan-13	742.83	745	733.5	741.48	1835780 	9-Jan-13	732.27	738.35	728.6	738.12	2025751 	8-Jan-13	735.54	736.3	724.43	733.3	1676740 	7-Jan-13	735.45	739.38	730.58	734.75	1655967 	4-Jan-13	729.34	741.47	727.68	737.97	2763552 	3-Jan-13	724.93	731.93	720.72	723.67	2318140 	2-Jan-13	719.42	727	716.55	723.25	2542268 	31-Dec-12	700	710.57	696	707.38	1997733 	28-Dec-12	701.69	706.91	700.01	700.01	1403926 	27-Dec-12	707.14	708.84	698.61	706.29	1647392 	26-Dec-12	708.07	712.88	702.41	708.87	1182572 	24-Dec-12	714.51	715.18	707.47	709.5	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	716.68	720.11	1919799 	18-Dec-12	716.6	729.1	715.05	721.07	3005138 	17-Dec-12	705.5	738.28	704.02	720.78	3036763 	14-Dec-12	699.17	707.82	698.43	701.96	2130595 	13-Dec-12	715.92	716.48	699.55	702.7	3446306 	12-Dec-12	699.23	703.51	693.48	697.56	2426299 	11-Dec-12	690	701.92	687.72	696.88	2687956 	10-Dec-12	685.39	691.65	683.79	685.42	1366866 	7-Dec-12	695	696.88	682.42	684.21	1919476 	6-Dec-12	687.59	695.61	684.51	691.13	1462216 	5-Dec-12	692.15	694.5	682.33	687.82	1862735 	4-Dec-12	695	695.51	685.7	691.03	1991605 	3-Dec-12	702.24	705.89	694.11	695.25	2193948 	30-Nov-12	691.31	699.22	685.69	698.37	3164441 	29-Nov-12	687.78	693.9	682	691.89	2780544 	28-Nov-12	668.01	684.91	663.89	683.67	3041940 	27-Nov-12	660.17	675	658	670.71	2509598 	26-Nov-12	666.44	667	659.02	661.15	2205527 	23-Nov-12	669.97	670	666.1	667.97	922477 	21-Nov-12	668.99	669.8	660.4	665.87	2113011 	20-Nov-12	669.51	678	664.57	669.97	2089086 	19-Nov-12	655.7	668.92	655.53	668.21	2369716 	16-Nov-12	645.99	653.02	636	647.18	3438500 	15-Nov-12	650	660	643.9	647.26	1848939 	14-Nov-12	660.66	662.18	650.5	652.55	1668322 	13-Nov-12	663	667.6	658.23	659.05	1594639 	12-Nov-12	663.75	669.8	660.87	665.9	1405870 	9-Nov-12	654.65	668.34	650.3	663.03	3114084 	8-Nov-12	670.2	671.49	651.23	652.29	2598676 	7-Nov-12	675	678.23	666.49	667.12	2232438 	6-Nov-12	685.48	686.5	677.55	681.72	1582936 	5-Nov-12	684.5	686.86	675.56	682.96	1635894 	2-Nov-12	694.79	695.55	687.37	687.92	2324569 	1-Nov-12	679.5	690.9	678.72	687.59	2050471 	31-Oct-12	679.86	681	675	680.3	1537001 	26-Oct-12	676.5	683.03	671.2	675.15	1950865 	25-Oct-12	680	682	673.51	677.76	2403696 	24-Oct-12	686.8	687	675.27	677.3	2496411 	23-Oct-12	672.01	687.33	672	680.35	2916978 	22-Oct-12	681.01	684.63	669.7	678.67	4057872 	19-Oct-12	705.58	706.7	672	681.79	11483428 	18-Oct-12	755.54	759.42	676	695	12442346 	17-Oct-12	743.95	756.34	740.26	755.49	2292819 	16-Oct-12	740.13	746.99	736.46	744.7	2058468 	15-Oct-12	741.94	743.83	730.7	740.98	3020098 	12-Oct-12	751.85	754.87	744.1	744.75	2406787 	11-Oct-12	752.9	758.5	750.29	751.48	2383987 	10-Oct-12	741.86	747.53	738.29	744.56	2041203 	9-Oct-12	759.67	761.32	742.53	744.09	3003884 	8-Oct-12	761	763.58	754.15	757.84	1958625 	5-Oct-12	770.71	774.38	765	767.65	2737751 	4-Oct-12	762.75	769.89	759.4	768.05	2454496 	3-Oct-12	755.72	763.92	752.2	762.5	2208639 	2-Oct-12	765.2	765.99	750.27	756.99	2790375 	1-Oct-12	759.05	765	756.21	761.78	3168477 	28-Sep-12	754.15	759.3	751.15	754.5	2784091 	27-Sep-12	759.95	762.84	751.65	756.5	3932272 	26-Sep-12	749.85	761.24	741	753.46	5674334 	25-Sep-12	753.05	764.89	747.66	749.16	6061033 	24-Sep-12	731	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.5	728.56	716.41	727.5	3098782 	18-Sep-12	707.78	718.66	706.78	718.28	2067249 	17-Sep-12	708.11	712.88	705	709.98	1508307 	14-Sep-12	709.6	713	707.01	709.68	2618874 	13-Sep-12	693.09	709	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	692.19	1874004 	10-Sep-12	709.76	712.81	698.39	700.77	2560067

Robert · Accepted Answer

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? Hint: Use the Empirical Rule; do not calculate the mean. The answer is easy. 
Using the empirical rule,

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? Hint: Use the Empirical Rule; do not...

Answer To: 1.If a person bought 1 share of Google stock within the last year, what is the probability that the...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment