|
Model Summary |
||||
|
Model |
R |
R Square |
Adjusted R Square |
Std. Error of the Estimate |
|
1 |
.647a |
.419 |
.418 |
1273.85784 |
|
a. Predictors: (Constant), 3-yr
Regression Beta, Expected Growth in EPS: next 5 years, Payout Ratio |
||||
|
Coefficientsa,b |
||||||
|
Model |
Unstandardized Coefficients |
Standardized Coefficients |
t |
Sig. |
||
|
B |
Std. Error |
Beta |
||||
|
1 |
(Constant) |
2.741 |
.914 |
|
2.999 |
.003 |
|
Expected Growth in EPS: next 5
years |
142.627 |
4.029 |
.669 |
35.397 |
.000 |
|
|
Payout Ratio |
5.668 |
1.199 |
.090 |
4.726 |
.000 |
|
|
3-yr Regression Beta |
.550 |
.477 |
.021 |
1.153 |
.249 |
|
|
a. Dependent Variable: Current
PE |
|
|
|
|
||
|
b. Weighted Least Squares
Regression - Weighted by Market Cap |
|
|
||||
The Multicollinearity
Problem
|
Correlations |
|||||
|
|
|
Current PE |
Payout Ratio |
Expected Growth in EPS: next 5 years |
Regression Beta |
|
Current PE |
Pearson Correlation |
1 |
-.084** |
.432** |
.078** |
|
Sig. (2-tailed) |
|
.000 |
.000 |
.000 |
|
|
N |
4062 |
4031 |
2206 |
3283 |
|
|
Payout Ratio |
Pearson Correlation |
-.084** |
1 |
-.275** |
-.115** |
|
Sig. (2-tailed) |
.000 |
|
.000 |
.000 |
|
|
N |
4031 |
4118 |
2230 |
3318 |
|
|
Expected Growth in EPS: next 5
years |
Pearson Correlation |
.432** |
-.275** |
1 |
.171** |
|
Sig. (2-tailed) |
.000 |
.000 |
|
.000 |
|
|
N |
2206 |
2230 |
2631 |
2206 |
|
|
Regression Beta |
Pearson Correlation |
.078** |
-.115** |
.171** |
1 |
|
Sig. (2-tailed) |
.000 |
.000 |
.000 |
|
|
|
N |
3283 |
3318 |
2206 |
5200 |
|
|
**. Correlation is significant at the 0.01 level (2-tailed). |
|
|
|
||
PEG Ratio Regression with intercept
|
Model Summary |
||||
|
Model |
R |
R Square |
Adjusted R Square |
Std. Error of the Estimate |
|
1 |
.483a |
.233 |
.232 |
99.60100 |
|
a. Predictors: (Constant),
Payout Ratio, Regression Beta, ln (Expcted Growth) |
||||
|
Coefficientsa,b |
||||||
|
Model |
Unstandardized Coefficients |
Standardized Coefficients |
t |
Sig. |
||
|
B |
Std. Error |
Beta |
||||
|
1 |
(Constant) |
-.149 |
.106 |
|
-1.395 |
.163 |
|
ln (Expcted Growth) |
-.830 |
.041 |
-.441 |
-2.016E1 |
.000 |
|
|
Regression Beta |
.162 |
.037 |
.093 |
4.351 |
.000 |
|
|
Payout Ratio |
.554 |
.095 |
.129 |
5.820 |
.000 |
|
|
a. Dependent Variable: PEG
Ratio |
|
|
|
|
||
|
b. Weighted Least Squares
Regression - Weighted by Market Cap |
|
|
||||
PEG ratio with no intercept
|
Model Summary |
||||
|
Model |
R |
R Squareb |
Adjusted R Square |
Std. Error of the Estimate |
|
1 |
.909a |
.826 |
.825 |
99.62656 |
|
a. Predictors: Payout Ratio,
Regression Beta, ln (Expcted
Growth) |
||||
|
b. For regression through the
origin (the no-intercept model), R Square measures the proportion of the
variability in the dependent variable about the origin explained by
regression. This CANNOT be compared to R Square for models
which include an intercept. |
||||
|
Coefficientsa,b,c |
||||||
|
Model |
Unstandardized Coefficients |
Standardized Coefficients |
t |
Sig. |
||
|
B |
Std. Error |
Beta |
||||
|
1 |
ln (Expcted Growth) |
-.782 |
.023 |
-.775 |
-3.448E1 |
.000 |
|
Regression Beta |
.133 |
.031 |
.072 |
4.309 |
.000 |
|
|
Payout Ratio |
.541 |
.095 |
.093 |
5.708 |
.000 |
|
|
a. Dependent Variable: PEG
Ratio |
|
|
|
|
||
|
b. Linear Regression through
the Origin |
|
|||||