多元线性回归分析(3)

1、 1 1 1统计学 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 101010 111111 121212 131313 141414解：由 Excel 给出的多元回归结果见下表. 得不良贷款(y) 与贷款余额 (x1)、累计应收贷款 (x2)、贷款项目个数(x3) 和固定资产投资额 (x4) 的线性回归方程如下4321029193. 0014529. 0148034. 0040039. 002164. 1xxxxy某商业银行2002年的有关业务数据Excel输出的回归分析结果 181818 191919 202020 212121 22222

2、2 232323 242424 252525 262626 272727 282828 292929 303030 313131 323232 333333 343434 353535 363636 373737 383838 393939 404040 414141 424242 434343 444444 454545 464646 474747 484848 494949 505050Variable Entered/Removed a modelVariable EnteredVariable Removedmethod1各项贷款余额各项贷款余额x1Stepwise(Criteria:

3、Probability-of-F-to-enter=.050,Probability-of-F-to-remove=.100.2固定资产投资额固定资产投资额x4Stepwise(Criteria:Probability-of-F-to-enter=.050,Probability-of-F-to-remove=.100.a Dependent variable:不良贷款y 515151Model summarymodelRR-SquareAdjusted R-SquareStd.Error of the Estimate1.844a.712.6991.97992.872b.761.7391.8

4、428a Predictors:(Constant),各项贷款余额x1b Predictors:(Constant),各项贷款余额x1,固定资产投资额x4 525252ANOVA cmodelSum of SquaresdfMean SquareFSig.1 Regress ResidualTotal222.48690.164312.65012324222.4863.92056.754 .000a2 Regress Residual Total237.94174.709312.65022224118.9713.39635.034.000ba Predictors:(Constant),各项贷款

5、余额x1b Predictors:(Constant),各项贷款余额x1,固定资产投资额x4c Dependent variable:不良贷款y 535353ModelUnstandardizedCoefficientsUnstandardizedCoefficientstSig.BStd.ErrorBeta1 (Constant) 贷款余额x1 -.830.038.723.0050844-1.1477.534.263.0002 (Constant) 贷款余额x1 固定资产投资x4-.443.050-.032.697.007.0151.120-.355-.6366.732-2.133.531.

6、000.044a Dependent variable:不良贷款yCoefficients a 545454 555555 565656 575757 585858 595959考试成绩与性别的散点图考试成绩与性别的散点图255075100性别考试成绩男 女 6060601.96*Std. Dev.1.00*Std. Dev.MeanBox & Whisker Plot30405060708090100110男女 616161 626262 636363 646464 656565 666666 676767 686868 696969 707070 717171 727272 737373价格价格 (元元) x12345678910需求量需求量(kg) y58504438343029262524 747474价格与需求量的散点图价格与