Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write out the linear equation for the model. Interpret the model (i.e., not considering the risk level, does the public company you chose to have
Write out the linear equation for the model.
Interpret the model (i.e., not considering the risk level, does the public company you chose to have larger return swings than the market return, smaller return swings than the market, or similar return swings to the market). Hint: substitute in a few market return values (e.g., 5%, -3%, 2%, -7%) and calculate what the predicted stock return will be (ignore the intercept coefficient).
Date Adj Close Stock Return Market Return SUMMARY OUTPUT 7/1/2018 42.9317 -0.02 -0.41% 8/1/2018 43.6478 -0.03 -0.50% Regression Statistics 9/1/2018 45.1352 0.08 7.16% Multiple R 0.71252955 10/1/2018 41.7354 -0.17 -2.00% R Square 0.50769836 11/1/2018 50.2855 0.06 9.52% Adjusted R Square 0.492780129 12/1/2018 47.4324 -0.05 -7.52% Standard Error 0.110391079 1/1/2019 49.8307 -0.07 -2.73% Observations 35 2/1/2019 53.3937 -0.02 -0.41% 3/1/2019 54.3626 0.06 -2.79% ANOVA 4/1/2019 51.3215 0.45 6.49% df 5/1/2019 35.5121 -0.06 -6.02% Regression 1 6/1/2019 37.8314 0.02 -0.13% Residual 33 7/1/2019 37.0553 0.12 2.59% Total 34 8/1/2019 32.9596 -0.16 -2.06% 9/1/2019 39.3074 -0.01 -1.27% Coefficients 10/1/2019 39.6261 0.08 -2.76% Intercept 0.010633599 11/1/2019 36.7926 0.03 -2.64% Market Return 1.882356419 12/1/2019 35.8188 0.03 2.20% 1/1/2020 34.8818 0.04 9.96% 2/1/2020 33.6286 0.64 20.18% 3/1/2020 20.4555 -0.14 -9.41%ANOVA df SS MS F Significance F Regression 1 0.414721329 0.414721329 34.03207411 1.57425E-06 Residual 33 0.402144277 0.01218619 Total 34 0.816865606 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 0.010633599 0.018740338 0.56741767 0.574270623 -0.027493906 0.048761104 -0.02749391 0.048761104 Market Return 1.882356419 0.322669302 5.833701579 1.57425E-06 1.225880787 2.538832051 1.225880787 2.538832051 n RESIDUAL OUTPUT Observation Predicted Stock Return Residuals 1 0.002881213 -0.019286997 2 0.001190553 -0.034144893 3 0.145466274 -0.064006497 4 -0.027064789 -0.142965177 5 0.1898866 -0.129736278 6 -0.130881884 0.082751736 7 -0.040840476 -0.025890313Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started