Date	Open	High	Low	Close	Volume	Adj Close	Monthly Required Return	Annual Return	Average Annual Return	SD of Returns
2/1/2016	1936.939941	1962.959961	1810.099976	1932.22998	4881887000	1932.22998	-0.002431650512	-0.02917980615	7.96%	3.43%
1/4/2016	2038.199951	2038.199951	1812.290039	1940.23999	5153017800	1940.23999	-0.04806199752	-0.5767439703
12/1/2015	2082.929932	2104.27002	1993.26001	2043.939941	3922935900	2043.939941	-0.01871882025	-0.2246258431
11/2/2015	2080.76001	2116.47998	2019.390015	2080.409912	4007931000	2080.409912	-0.0001682548676	-0.002019058411
10/1/2015	1919.650024	2094.320068	1893.699951	2079.360107	4095504500	2079.360107	0.08319750007	0.9983700008
9/1/2015	1970.089966	2020.859985	1871.910034	1920.030029	4024497100	1920.030029	-0.02540997511	-0.3049197013
8/3/2015	2104.48999	2112.659912	1867.01001	1972.180054	4216280400	1972.180054	-0.06287030902	-0.7544437082
7/1/2015	2067	2132.820068	2044.02002	2103.840088	3709178600	2103.840088	0.01782297436	0.2138756923
6/1/2015	2108.639893	2129.870117	2056.320068	2063.110107	3513296300	2063.110107	-0.02159201585	-0.2591041902
5/1/2015	2087.379883	2134.719971	2067.929932	2107.389893	3455756000	2107.389893	0.009586185132	0.1150342216
4/1/2015	2067.629883	2125.919922	2048.379883	2085.51001	3521458000	2085.51001	0.008647643927	0.1037717271
3/2/2015	2105.22998	2117.52002	2039.689941	2067.889893	3638745400	2067.889893	-0.01773682085	-0.2128418502
2/2/2015	1996.670044	2119.590088	1980.900024	2104.5	3806470500	2104.5	0.05400489496	0.6480587395
1/2/2015	2058.899902	2072.360107	1988.119995	1994.98999	4091934500	1994.98999	-0.03104080579	-0.3724896695
12/1/2014	2065.780029	2093.550049	1972.560059	2058.899902	3788631300	2058.899902	-0.003330522565	-0.03996627077
11/3/2014	2018.209961	2075.76001	2001.01001	2067.560059	3479201500	2067.560059	0.02445241028	0.2934289234
10/1/2014	1971.439941	2018.189941	1820.660034	2018.050049	4260310800	2018.050049	0.02364267205	0.2837120647
9/2/2014	2004.069946	2019.26001	1964.040039	1972.290039	3364623800	1972.290039	-0.01585768354	-0.1902922025
8/1/2014	1929.800049	2005.040039	1904.780029	2003.369995	2875718500	2003.369995	0.03812309262	0.4574771114
7/1/2014	1962.290039	1991.390015	1930.670044	1930.670044	3214440400	1930.670044	-0.01611382332	-0.1933658799
6/2/2014	1923.869995	1968.170044	1915.97998	1960.22998	3158130000	1960.22998	0.01889939814	0.2267927776
5/1/2014	1884.390015	1924.030029	1859.790039	1923.569946	3185100900	1923.569946	0.02079183751	0.2495020501
4/1/2014	1873.959961	1897.280029	1814.359985	1883.949951	3589287600	1883.949951	0.005330951679	0.06397142014
3/3/2014	1857.680054	1883.969971	1834.439941	1872.339966	3579015700	1872.339966	0.007891516071	0.09469819285
2/3/2014	1782.680054	1867.920044	1737.920044	1859.449951	3875949400	1859.449951	0.0430643159	0.5167717908
1/2/2014	1845.859985	1850.839966	1770.449951	1782.589966	3806266600	1782.589966	-0.03427671628	-0.4113205954
12/2/2013	1806.550049	1849.439941	1767.98999	1848.359985	3203412300	1848.359985	0.02314352488	0.2777222985
11/1/2013	1758.699951	1813.550049	1746.199951	1805.810059	3261324500	1805.810059	0.02678689334	0.32144272
10/1/2013	1682.410034	1775.219971	1646.469971	1756.540039	3498866500	1756.540039	0.04406179439	0.5287415327
9/3/2013	1635.949951	1729.859985	1633.410034	1681.550049	3474152000	1681.550049	0.02787377326	0.3344852791
8/1/2013	1689.420044	1709.670044	1627.469971	1632.969971	3069868600	1632.969971	-0.03341387667	-0.4009665201
7/1/2013	1609.780029	1698.780029	1604.569946	1685.72998	3270645900	1685.72998	0.04718032876	0.5661639451
6/3/2013	1631.709961	1654.189941	1560.329956	1606.280029	3996199000	1606.280029	-0.01558483591	-0.187018031
5/1/2013	1597.550049	1687.180054	1581.280029	1630.73999	3661220400	1630.73999	0.02077552501	0.2493063001
4/1/2013	1569.180054	1597.569946	1536.030029	1597.569946	3674685000	1597.569946	0.01809218256	0.2171061907
3/1/2013	1514.680054	1570.280029	1501.47998	1569.189941	3591577500	1569.189941	0.03598772352	0.4318526822
2/1/2013	1498.109985	1530.939941	1485.01001	1514.680054	3851884200	1514.680054	0.0110606492	0.1327277903
1/2/2013	1426.189941	1509.939941	1426.189941	1498.109985	3802304200	1498.109985	0.05042809652	0.6051371582
12/3/2012	1416.339966	1448	1398.109985	1426.189941	3479625500	1426.189941	0.006954527329	0.08345432794
11/1/2012	1412.199951	1434.27002	1343.349976	1416.180054	3593110000	1416.180054	0.002818370725	0.0338204487
10/1/2012	1440.900024	1470.959961	1403.280029	1412.160034	3587115700	1412.160034	-0.01994585989	-0.2393503187
9/4/2012	1406.540039	1474.51001	1396.560059	1440.670044	3857553100	1440.670044	0.02426522108	0.2911826529
8/1/2012	1379.319946	1426.680054	1354.650024	1406.579956	3183567800	1406.579956	0.01976336968	0.2371604362
7/2/2012	1362.329956	1391.73999	1325.410034	1379.319946	3663113300	1379.319946	0.01247127388	0.1496552866
6/1/2012	1309.869995	1363.459961	1266.73999	1362.160034	4103472300	1362.160034	0.03992002199	0.4790402638
5/1/2012	1397.859985	1415.319946	1291.97998	1310.329956	4158095900	1310.329956	-0.06261716477	-0.7514059772
4/2/2012	1408.469971	1422.380005	1357.380005	1397.910034	3916786000	1397.910034	-0.007497452709	-0.08996943251
3/1/2012	1365.900024	1419.150024	1340.030029	1408.469971	3980752200	1408.469971	0.03116622465	0.3739946958
2/1/2012	1312.449951	1378.040039	1312.449951	1365.680054	4143404000	1365.680054	0.04055781553	0.4866937863
1/3/2012	1258.859985	1333.469971	1258.859985	1312.410034	4190155500	1312.410034	0.04253852663	0.5104623196
12/1/2011	1246.910034	1269.369995	1202.369995	1257.599976	3667346600	1257.599976	0.008573146184	0.1028777542
11/1/2011	1251	1277.550049	1158.660034	1246.959961	4289379000	1246.959961	-0.003229447642	-0.0387533717
10/3/2011	1131.209961	1292.660034	1074.77002	1253.300049	4874946600	1253.300049	0.1079287597	1.295145116
9/1/2011	1219.119995	1229.290039	1114.219971	1131.420044	5104933800	1131.420044	-0.07193709508	-0.863245141
8/1/2011	1292.589966	1307.380005	1101.540039	1218.890015	4942913400	1218.890015	-0.05701726993	-0.6842072392
7/1/2011	1320.640015	1356.47998	1282.859985	1292.280029	4308168000	1292.280029	-0.02147442579	-0.2576931095
6/1/2011	1345.199951	1345.199951	1258.069946	1320.640015	4105601300	1320.640015	-0.01825746127	-0.2190895352
5/2/2011	1365.209961	1370.579956	1311.800049	1345.199951	4114534200	1345.199951	-0.01465709347	-0.1758851216
4/1/2011	1329.47998	1364.560059	1294.699951	1363.609985	4042194000	1363.609985	0.02567169533	0.308060344
3/1/2011	1328.640015	1332.280029	1249.050049	1325.829956	4046691700	1325.829956	-0.002114988987	-0.02537986785

Now calculate the beta for each stock using Excels Slope or Linest

function to use estimate the slope of the linear regression line, which is

beta. Use the S&P 500 index as the market portfolio in finding beta.