%change Date Adj Close Date Adj Close COF 10 1/18 88.06 10/1/18 259.41 COF SPY % change Rf COF-RfSPY-Rf SPY -7.95% 9/1/18 93.62 9/1/18 275.43-5.93% -5.82% 8/1/18 97.31 8/1/18 265.42-3806 3.77% 7/1/18 92.63 7/1/18 257.11 5.06% 3.23% 2.13% 8.06% 2.03% -5.83% 1. 74% 1.96% 3. 10% 1.27% 6/1/18 90.25 6/1/18 259.48 2.63% -0.91% 1.90% 0.73% -2.81% 5/1/18 91.91 5/1/18 265.78-1.81% -2.37% 1.86% -3.67% -4.23% 4/1/18 88.61 4/1/18 266.12 3.73% .13% 1.76% 1.97% , 1.89% 3/1/18 93.69 3/1/18 277.22-5.43% -4.00% 1.70% 7.13% -5.70% 2/1/18 95.34 2/1/18 286.06-1.73% -3.09% 1.57% 4.66% -3.30% 1/1/18 101.21 1/1/18 286.47-5.80% -0.14% 1.41% 7.21% 1,55% 12/1/17 96.94 12/1/17 26788 4.40% 6.94% 1.32% 3,08% 5.62% 11/1/17 89.16 11/1/17 27285 8.73% -1.82% 1.23% 7.50% -3.05% SUMMARY OUTPUT Multiple BR 0.44818469 0.20086951 Adjusted R Square 0.11207724 Standard Error 0.04929352 Observations ANOVA 0.005496909 0.005497 2.262241 0.166817249 9 0.021868661 0.00243 Total 10 0.02736557 0.004140S 0.017179278 0.24101 0814945 0.043002681 0.03472177 0.043 0034722 SPY R 61409931 0.408290418 0.408290418 1504075 0.166817 0309517787 1.5377164 0.30952 1.537716 Answer a) Show the regression output and highlight on the output the intercept, beta and R-square. b) What is the interpretation of beta coefficient in the regression model? c) Are the coefficients statistically significant? What is the null hypothesis