Calculate Beta for a Public Firm

Date GM Adj Close S&P ADJ X axis S&P Returns Y axis GM RETURN 11/2/2015 35.439999 2099.929932 0.009892382 0.015181868 10/26/2015 34.91 2079.360107 0.002028868 -0.028929095 10/19/2015 35.950001 2075.149902 0.02067764 0.08446452 10/12/2015 33.150002 2033.109985 0.009042662 0.006069833 10/5/2015 32.950001 2014.890015 0.032556797 0.038449448 9/28/2015 31.73 1951.359985 0.01036587 0.078884733 9/21/2015 29.41 1931.339966 -0.01365623 -0.036053753 9/14/2015 30.51 1958.079956 -0.001514542 0.011940299 9/8/2015 30.15 1961.050049 0.020731659 0.056819599 8/31/2015 28.528994 1921.219971 -0.034014302 -0.004137913 8/24/2015 28.647535 1988.869995 0.009122772 -0.020270316 8/17/2015 29.240244 1970.890015 -0.057684779 -0.060019051 8/10/2015 31.107273 2091.540039 0.006724188 -0.007876512 8/3/2015 31.354235 2077.570068 -0.0124867 0.007299315 7/27/2015 31.127029 2103.840088 0.011631855 0.014488064 7/20/2015 30.682499 2079.649902 -0.022095885 0.013376872 7/13/2015 30.277481 2126.639893 0.024087109 -0.023885365 7/6/2015 31.018366 2076.620117 -7.7E-05 -0.055070769 6/29/2015 32.826126 2076.780029 -0.011814788 -0.033449736 6/22/2015 33.962151 2101.610107 -0.003971527 -0.047909144 6/15/2015 35.671124 2109.98999 0.007583118 0.011201446 6/8/2015 35.275982 2094.110107 0.000611626 0.027330273 6/1/2015 34.337528 2092.830078 -0.006908933 -0.023630913 5/26/2015 35.168594 2107.389893 -0.00878158 0.007563128 5/18/2015 34.904606 2126.060059 0.001568772 0.022629534 5/11/2015 34.13221 2122.72998 0.003133066 -0.011608089 5/4/2015 34.533073 2116.100098 0.003704452 -0.002823235 4/27/2015 34.630844 2108.290039 -0.004438753 -0.004776668 4/20/2015 34.797058 2117.689941 0.017542937 -0.028657148 4/13/2015 35.823662 2081.179932 -0.009933173 0.001914126 4/6/2015 35.755222 2102.060059 0.016981508 0.001917769 3/30/2015 35.686783 2066.959961 0.002882039 -0.021710017 3/23/2015 36.478737 2061.02002 -0.022332942 -0.040133745 3/16/2015 38.003979 2108.100098 0.026638842 0.021550606 3/9/2015 37.202248 2053.399902 -0.008622823 0.041324568 3/2/2015 35.725891 2071.26001 -0.015794721 -0.012597204 2/23/2015 36.181679 2104.5 -0.002748448 -0.009030496 2/17/2015 36.511395 2110.300049 0.006347221 0.00079751 2/9/2015 36.4823 2096.98999 0.020199769 0.044999966 2/2/2015 34.911293 2055.469971 0.030315932 0.103617395 1/26/2015 31.633511 1994.98999 -0.027697398 -0.033481431 1/20/2015 32.729336 2051.820068 0.016044222 0.002078383 1/12/2015 32.661453 2019.420044 -0.012416809 -0.053666761 1/5/2015 34.513691 2044.810059 -0.006505632 0.021526963 12/29/2014 33.786373 2058.199951 -0.01463544 0.032908374 12/22/2014 32.709942 2088.77002 0.008750933 0.028040184 12/15/2014 31.817766 2070.649902 0.034120224 0.039277824 12/8/2014 30.615265 2002.329956 -0.0351938 -0.061254866 12/1/2014 32.612968 2075.370117 0.003777427 0.014956565 11/24/2014 32.132378 2067.560059 0.001967559 0.040460693 11/17/2014 30.882837 2063.5 0.011608894 0.010695137 11/10/2014 30.556036 2039.819946 0.0038879 0.006331158 11/3/2014 30.363798 2031.920044 0.006872969 0.006050958 10/27/2014 30.181173 2018.050049 0.027217061 0.045272932 10/20/2014 28.873964 1964.579956 0.041245281 -0.006613662 10/13/2014 29.066198 1886.76001 -0.010161949 -0.001650806 10/6/2014 29.11426 1906.130005 -0.031388799 -0.102784302 9/29/2014 32.449566 1967.900024 -0.007539628 0.017787174 9/22/2014 31.882467 1982.849976 -0.013703764 -0.022687079 9/15/2014 32.622578 2010.400024 0.012520516 0.020138226 9/8/2014 31.978586 1985.540039 -0.011042393 -0.029463283 9/2/2014 32.949383 2007.709961 0.002166333 -0.006321812 8/25/2014 33.159008 2003.369995 0.007528652 0.016355102 8/18/2014 32.625416 1988.400024 0.017053167 0.01182033 8/11/2014 32.244278 1955.060059 0.01215066 0.009245547 8/4/2014 31.948893 1931.589966 0.003345164 0.002691417 7/28/2014 31.863136 1925.150024 -0.026886148 -0.04647852 7/21/2014 33.416275 1978.339966 6.06581E-05 -0.062550085 7/14/2014 35.645931 1978.219971 0.005412781 -0.014229296 7/7/2014 36.160469 1967.569946 -0.009000522 0.005564347 6/30/2014 35.960373 1985.439941 0.012483672 0.030584425 6/23/2014 34.893185 1960.959961 -0.000973082 0.011043622 6/16/2014 34.512047 1962.869995 0.013795327 0.016559003 6/9/2014 33.949871 1936.160034 -0.006812165 -0.025170901 6/2/2014 34.826485 1949.439941 0.013448949 0.065784678 5/27/2014 32.676849 1923.569946 0.01212289 0.028248599 5/19/2014 31.779133 1900.530029 0.012072276 -0.010882334 5/12/2014 32.128769 1877.859985 -0.000330051 -0.006719139 5/5/2014 32.346107 1878.47998 -0.001414055 -0.02116108 4/28/2014 33.045383 1881.140015 0.009520227 0.037069932 4/21/2014 31.86418 1863.400024 -0.000777517 -0.007651449 4/14/2014 32.109867 1864.849976 0.027075127 0.064202887 4/7/2014 30.172693 1815.689941 -0.026486671 -0.082734828 3/31/2014 32.894188 1865.089966 0.004021259 0.00230345 3/24/2014 32.818592 1857.619995 -0.004768245 -0.007997629 3/17/2014 33.083179 1866.52002 0.013790452 0.026987335 3/10/2014 32.213814 1841.130005 -0.019653486 -0.087485735 3/3/2014 35.302258 1878.040039 0.009997628 0.041160181 2/24/2014 33.906654 1859.449951 0.012634419 -0.013355038 2/18/2014 34.365608 1836.25 -0.001294445 0.020584012 2/10/2014 33.672493 1838.630005 0.023154992 -0.004430915 2/3/2014 33.822357 1797.02002 0.008094993 0.000831473 1/27/2014 33.794258 1782.589966 -0.00430102 -0.020363778 1/21/2014 34.496742 1790.290039 -0.026328337 -0.045854849 1/13/2014 36.154606 1838.699951 -0.001992023 -0.035723275 1/6/2014 37.494015 1842.369995 0.006006432 0.011624995 12/30/2013 37.063156 1831.369995 -0.005446958 -0.033463591 12/23/2013 38.346363 1841.400024 0.012693079 -0.00121993 12/16/2013 38.3932 1818.319946 0.024220986 0.023726286 12/9/2013 37.503384 1775.319946 -0.016492264 -0.00323616 12/2/2013 37.625145 1805.089966 -0.000398765 0.037180511 11/25/2013 36.276371 1805.810059 0.000581822 0.029231977 11/18/2013 35.246059 1804.76001 0.003659231 -0.029404217 11/11/2013 36.313839 1798.180054 0.015570944 0.057555886 11/4/2013 34.337513 1770.609985 0.005091829 -0.019523853 10/28/2013 35.021263 1761.640015 0.001062636 0.050575906 10/21/2013 33.3353 1759.77002 0.008753236 -0.008358775 10/14/2013 33.616291 1744.5 0.024248503 0.015275849 10/7/2013 33.1105 1703.199951 0.007512541 -0.009804078 9/30/2013 33.438332 1690.5 -0.00073888 -0.018421715 9/23/2013 34.065884 1691.75 -0.010620462 -0.012489817 9/16/2013 34.496742 1709.910034 0.012985885 0.021353273 9/9/2013 33.775524 1687.98999 0.019828746 -0.002489588 9/3/2013 33.859821 1655.170044 0.013594906 0.060739399 8/26/2013 31.920961 1632.969971 -0.018352888 -0.027952054 8/19/2013 32.838875 1663.5 0.004632145 0.019778955 8/12/2013 32.201954 1655.829956 -0.021041543 -0.045530246 8/5/2013 33.738056 1691.420044 -0.010674574 -0.025169133 7/29/2013 34.609138 1709.670044 0.010652333 0.007635628 7/22/2013 34.346878 1691.650024 -0.000259999 0.001638871 7/15/2013 34.29068 1692.089966 0.007082547 0.00576914 7/8/2013 34.093987 1680.189941 0.029597538 0.049899273 7/1/2013 32.473579 1631.890015 0.015943662 0.040828413 6/24/2013 31.199743 1606.280029 0.008697384 0.034150962 6/17/2013 30.169428 1592.430054 -0.021085199 -0.060659126 6/10/2013 32.117657 1626.72998 -0.010131573 -0.021124737 6/3/2013 32.810776 1643.380005 0.007751092 0.033638287 5/28/2013 31.742996 1630.73999 -0.011433066 0.031031342 5/20/2013 30.787615 1649.599976 -0.010716832 -0.016457201 5/13/2013 31.302771 1667.469971 0.020670883 0.063653626 5/6/2013 29.429478 1633.699951 0.011942311 -0.021183749 4/29/2013 30.066397 1614.420044 0.020338289 0.052459031 4/22/2013 28.56776 1582.23999 0.017354117 0.046312155 4/15/2013 27.303286 1555.25 -0.021147356 -0.015867674 4/8/2013 27.743511 1588.849976 0.022899893 0.076308156 4/1/2013 25.77655 1553.280029 -0.010138933 -0.010783633 3/25/2013 26.057545 1569.189941 0.007900318 -0.014174301 3/18/2013 26.432203 1556.890015 -0.002441171 0.000354504 3/11/2013 26.422836 1560.699951 0.006137197 0.00749996 3/4/2013 26.226141 1551.180054 0.021723162 0.02903345 2/25/2013 25.486189 1518.199951 0.001715476 0.003688645 2/19/2013 25.392525 1515.599976 -0.002757001 -0.023415018 2/11/2013 26.001347 1519.790039 0.001225343 -0.028351387 2/4/2013 26.760031 1517.930054 0.00314572 0.014199573 1/28/2013 26.38537 1513.170044 0.006793317 -0.030959786 1/22/2013 27.228354 1502.959961 0.01142679 -0.007172165 1/14/2013 27.425051 1485.97998 0.009462947 -0.035573097 1/7/2013 28.43663 1472.050049 0.003805109 0.016744775 12/31/2012 27.968307 1466.469971 0.045663537 0.07217238 12/24/2012 26.085644 1402.430054 -0.019382561 0.019399732 12/17/2012 25.58922 1430.150024 0.011722059 0.110117802 12/10/2012 23.050905 1413.579956 -0.003166268 -0.023024977 12/3/2012 23.59416 1418.069946 0.0013345 -0.026661473 11/26/2012 24.240446 1416.180054 0.004988844 0.026576753 11/19/2012 23.612892 1409.150024 0.036231152 0.057023011 11/12/2012 22.339052 1359.880005 -0.014472567 -0.047524044 11/5/2012 23.453665 1379.849976 #DIV/0! #DIV/0!