多元線性回歸分析(3)

1、 1 1 1統(tǒng)計學 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)、貸款項目個數(shù)(x3) 和固定資產(chǎn)投資額 (x4) 的線性回歸方程如下4321029193. 0014529. 0148034. 0040039. 002164. 1xxxxy某商業(yè)銀行2002年的有關業(yè)務數(shù)據(jù)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固定資產(chǎn)投資額固定資產(chǎn)投資額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,固定資產(chǎn)投資額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,固定資產(chǎn)投資額x4c Dependent variable:不良貸款y 535353ModelUnstandardizedCoefficientsUnstandardizedCoefficientstSig.BStd.ErrorBeta1 (Constant) 貸款余額x1 -.830.038.723.0050844-1.1477.534.263.0002 (Constant) 貸款余額x1 固定資產(chǎn)投資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價格與需求量的散點圖價格與