Spreadsheet: 0efadee5-b1a5-4fc7-8eb8-b7f8368fdd49
Sheet: Appendix A - Summary Output

Appendix A |  |  |  |  |  |  | Appendix A
SUMMARY OUTPUT | 2001 |  |  |  |  |  | SUMMARY OUTPUT | 2003
Regression Statistics |  |  |  |  |  |  | Regression Statistics
Multiple R | 0.8059898144303955 |  |  |  |  |  | Multiple R | 0.6675819595427706
R Square | 0.6496195809655434 |  |  |  |  |  | R Square | 0.4456656727069653
Adjusted R Square | 0.6091910710769523 |  |  |  |  |  | Adjusted R Square | 0.381704019557769
Standard Error | 12.91707769129751 |  |  |  |  |  | Standard Error | 19.10741854479749
Observations | 30 |  |  |  |  |  | Observations | 30
ANOVA |  |  |  |  |  |  | ANOVA
 | df | SS | MS | F | [NAME] |  |  | df | SS | MS | F | [NAME]
Regression | 3 | 8043.057448508253 | 2681.019149502751 | 16.06835331689692 | 4.122257895251812e-06 |  | Regression | 3 | 7631.58582040215 | 2543.86194013405 | 6.967700970258069 | 0.001359458120811179
Residual | 26 | 4338.123298158413 | 166.8508960830159 |  |  |  | Residual | 26 | 9492.429529597852 | 365.0934434460712
Total | 29 | 12381.18074666667 |  |  |  |  | Total | 29 | 17124.01535
 | Coefficients | Standard Error | t Stat | P-value |  |  |  | Coefficients | Standard Error | t Stat | P-value
Intercept | 21.71349481069801 | 4.642874164285833 | 4.676735582825768 | 7.89015314122089e-05 |  |  | Intercept | 25.25800052232411 | 7.567509907817848 | 3.337689785675808 | 0.002555536025127561
Earnings Per Share | 7.024299685506302 | 1.312857793845636 | 5.350388837568351 | 1.336071006203787e-05 |  |  | Earnings Per Share | 3.518752371617305 | 2.354953274690445 | 1.494192011975202 | 0.1471638323972844
Book Value Per Share | 0.6222564313751912 | 0.2806954484296344 | 2.216838337979607 | 0.03558725861737429 |  |  | Book Value Per Share | 1.095326387679218 | 0.4669980340976384 | 2.345462523831976 | 0.02690868591230258
% Over/Underfunded | 5.788711983772919 | 7.22411761621027 | 0.80130367351489 | 0.4302184109430909 |  |  | % Over/Underfunded | 33.32137358915634 | 20.13161138466319 | 1.655176674756471 | 0.1099115616559281
SUMMARY OUTPUT | 2002 |  |  |  |  |  | SUMMARY OUTPUT | 2004
Regression Statistics |  |  |  |  |  |  | Regression Statistics
Multiple R | 0.6549518181117563 |  |  |  |  |  | Multiple R | 0.7669412512033464
R Square | 0.4289618840478951 |  |  |  |  |  | R Square | 0.5881988827973545
Adjusted R Square | 0.3630728706688061 |  |  |  |  |  | Adjusted R Square | 0.5406833692739723
Standard Error | 16.18310921825345 |  |  |  |  |  | Standard Error | 18.72798761541535
Observations | 30 |  |  |  |  |  | Observations | 30
ANOVA |  |  |  |  |  |  | ANOVA
 | df | SS | MS | F | [NAME] |  |  | df | SS | MS | F | [NAME]
Regression | 3 | 5115.061793448753 | 1705.020597816251 | 6.510370425185837 | 0.001967372177457427 |  | Regression | 3 | 13025.43541216476 | 4341.811804054919 | 12.37909135735015 | 3.219845625408462e-05
Residual | 26 | 6809.218623217914 | 261.8930239699197 |  |  |  | Residual | 26 | 9119.175523201915 | 350.7375201231506
Total | 29 | 11924.28041666667 |  |  |  |  | Total | 29 | 22144.61093536667
 | Coefficients | Standard Error | t Stat | P-value |  |  |  | Coefficients | Standard Error | t Stat | P-value
Intercept | 20.87412665277779 | 6.446443772933262 | 3.238084033311849 | 0.003277654599210735 |  |  | Intercept | 20.47231614083113 | 7.611914843980515 | 2.689509349545678 | 0.01232883509202947
Earnings Per Share | 2.861677976079272 | 1.197974812542244 | 2.388763057552482 | 0.02445315702353425 |  |  | Earnings Per Share | 3.900887337144063 | 2.024556998788894 | 1.926785632351969 | 0.0650024368428579
Book Value Per Share | 0.7542492872988465 | 0.3592849453280844 | 2.099306684309015 | 0.0456474420296448 |  |  | Book Value Per Share | 0.9091645584426451 | 0.49385354202617 | 1.840959881977453 | 0.07706673852897
% Over/Underfunded | 8.2899099582411 | 14.34209131668944 | 0.5780126325506233 | 0.5682285425345288 |  |  | % Over/Underfunded | 13.46160675463794 | 19.58019967357952 | 0.6875112092346183 | 0.4978483507039971