Question: AutoSave O OFF A A G . G ... 3 Securities Analysis Project-1 (3) Home Insert Draw Page Layout Formulas Data Review View Tell me

AutoSave O OFF A A G . G ... 3 Securities
AutoSave O OFF A A G . G ... 3 Securities Analysis Project-1 (3) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Times New Roman v 16 AA ab Wrap Text v General ZY AP- O. v Z Paste BI UVV DVAv E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Security Warning External Data Connections have been disabled Enable Content A1 X V fx Regression Analysis B D E F G H I J K L M N O P Q R S T U V Regression Analysis SUMMARY OUTPUT Report your results: interpret the coefficients, t-statistics and R2. Discuss the estimated Regression Statistics beta. Multiple R 0.116991605 7 R Square 0.013687036 8 Adjusted R Square 0.006100013 9 Standard Error 8.839879148 10 Observations 132 11 12 13 df SS MS Significance F 14 Regression 140.9712864 140.9713 1.804006 0.18156908 15 Residual 130 10158.65023 78.14346 16 Total 131 10299.62152 17 18 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 19 Intercept -9.078578043 0.78443087 -11.57346 9.91E-22 -10.630481 -7.5266754 -10.63048071 -7.526675381 20 X Variable 1 0.248182288 0.184778646 1.343133 0.181569 -0.1173802 0.6137447 -0.117380164 0.61374474 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 D (4.2) Statistic Analysis (5) Regression Analysis (6) CAPM Analysis (7) Growth Estimation (8) Dividend Growth Model (9) Sensitivity Analysis (10) Trading Strategy + Ready Accessibility: Investigate + 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!