文档格式-多元线性回归模板.xls

SUMMARY OUTPUT 回归统计 Multiple R 0.998388 R Square 0.996779 Adjusted R Square0.990338 标准误差 0.723612 观测值7 方差分析 dfSSMSF Significance F 回归分析4 324.1099 81.02748 154.7464 0.006431 残差2 1.047229 0.523615 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 12.40837 10.427911.189920.35618 -32.4593 57.27605 -32.4593 57.27605 X Variable 10.044817 0.047873 0.936162 0.448016 -0.16116 0.250799 -0.16116 0.250799 X Variable 20.192306 0.192596 0.998491 0.423231 -0.63637 1.020981 -0.63637 1.020981 X Variable 30.0661590.13284 0.498035 0.667832 -0.50541 0.637723 -0.50541 0.637723 X Variable 4-0.01512 0.192348 -0.07859 0.944513 -0.84272 0.812489 -0.84272 0.812489 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 44.90956 0.690443 1.6526577.14285745.6 2 47.53016 -0.63016 -1.5083621.4285746.9 3 50.55686 -0.25686 -0.6148435.7142950.3 456.1496-0.0496 -0.118725056.1 560.31440.1856 0.44425564.2857160.5 6 61.88438 0.215618 0.51610778.5714362.1 7 63.35504 -0.15504-0.371192.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -1 -0.5 0 0.5 1 X Variable 1 残差 X Variable 2 Residual Plot 100806040200 -1 -0.5 0 0.5 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -1 -0.5 0 0.5 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -1 -0.5 0 0.5 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R 0.998654 R Square 0.997311 Adjusted R Square0.991932 标准误差 0.661238 观测值7 方差分析 dfSSMSF Significance F 回归分析4 324.2827 81.07067 185.4166 0.005372 残差2 0.874471 0.437235 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 12.397614.39943 2.818003 0.106235 -6.53161 31.32683 -6.53161 31.32683 X Variable 10.055091 0.021726 2.535736 0.126644 -0.038390.14857 -0.038390.14857 X Variable 2 0.09838 0.072095 1.364581 0.305634 -0.21182 0.408581 -0.21182 0.408581 X Variable 30.025801 0.064076 0.4026590.72616-0.2499 0.301499-0.2499 0.301499 X Variable 40.090946 0.134463 0.676366 0.568543-0.4876 0.669492-0.4876 0.669492 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 45.05986 0.540144 1.4148577.14285745.6 2 47.40631 -0.50631 -1.3262321.4285746.9 350.5019-0.2019 -0.5288635.7142950.3 4 56.11652 -0.01652 -0.043275056.1 5 60.46022 0.039777 0.10419164.2857160.5 6 61.65796 0.442041 1.15788578.5714362.1 7 63.49723 -0.29723 -0.7785792.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -1 -0.5 0 0.5 1 X Variable 1 残差 X Variable 2 Residual Plot 100806040200 -1 -0.5 0 0.5 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -1 -0.5 0 0.5 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -1 -0.5 0 0.5 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R 0.998551 R Square 0.997104 Adjusted R Square0.991311 标准误差 0.686225 观测值7 方差分析 dfSSMSF Significance F 回归分析4 324.2153 81.05383 172.1238 0.005785 残差2 0.941808 0.470904 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 11.78557 7.827164 1.5057260.27109-21.892 45.46313-21.892 45.46313 X Variable 10.0531040.03147 1.6874520.23357-0.0823 0.188509-0.0823 0.188509 X Variable 20.129034 0.227908 0.566168 0.628336 -0.85158 1.109644 -0.85158 1.109644 X Variable 3-0.05267 0.606312 -0.08686 0.938694 -2.66142 2.556085 -2.66142 2.556085 X Variable 40.149193 0.267673 0.557369 0.633331 -1.00251 1.300897 -1.00251 1.300897 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 45.10079 0.499211 1.2600227.14285745.6 2 47.38634 -0.48634 -1.2275421.4285746.9 350.426-0.126 -0.3180235.7142950.3 4 56.13724 -0.03724 -0.093995056.1 5 60.70576 -0.20576 -0.5193364.2857160.5 6 61.51386 0.586141 1.47943878.5714362.1 7 63.43002 -0.23002 -0.5805892.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -1 -0.5 0 0.5 1 X Variable 1 残差 X Variable 2 Residual Plot 100806040200 -1 -0.5 0 0.5 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -1 -0.5 0 0.5 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -1 -0.5 0 0.5 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R 0.997225 R Square 0.994458 Adjusted R Square0.983375 标准误差 0.949199 观测值7 方差分析 dfSSMSF Significance F 回归分析4 323.355280.8388 89.72336 0.011053 残差2 1.801957 0.900978 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 1.306256 6.547741 0.199497 0.860317 -26.8664 29.47891 -26.8664 29.47891 X Variable 1-0.04164 0.042645 -0.97647 0.431814 -0.22513 0.141845 -0.22513 0.141845 X Variable 20.125109 0.149183 0.838627 0.489939 -0.51678 0.766994 -0.51678 0.766994 X Variable 30.264319 0.313633 0.8427660.48808 -1.08514 1.613774 -1.08514 1.613774 X Variable 40.220877 0.265411 0.832207 0.492836 -0.92109 1.362848 -0.92109 1.362848 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 45.081110.51889 0.9468457.14285745.6 247.8606-0.9606 -1.7528621.4285746.9 3 49.99087 0.309127 0.56407935.7142950.3 4 55.95497 0.145034 0.2646525056.1 5 60.83965 -0.33965 -0.6197864.2857160.5 6 61.533620.56638 1.03350278.5714362.1 7 63.43917 -0.23917 -0.4364392.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -2 -1 0 1 X Variable 1 残差 X Variable 2 Residual Plot 1009080706050403020100 -2 -1 0 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -2 -1 0 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -2 -1 0 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R 0.996429 R Square 0.992871 Adjusted R Square0.978614 标准误差 1.076551 观测值7 方差分析 dfSSMSF Significance F 回归分析4 322.839280.7098 69.63967 0.014206 残差2 2.317926 1.158963 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 3.011884 7.091902 0.424693 0.712385 -27.5021 33.52588 -27.5021 33.52588 X Variable 1-0.03917 0.071985-0.5441 0.640921 -0.34889 0.270559 -0.34889 0.270559 X Variable 20.142672 0.244671 0.583117 0.618807 -0.91006 1.195405 -0.91006 1.195405 X Variable 30.150508 0.510137 0.295035 0.795776 -2.04444 2.345452 -2.04444 2.345452 X Variable 40.298433 0.476932 0.625736 0.595376 -1.75364 2.350506 -1.75364 2.350506 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 45.22441 0.375587 0.6042787.14285745.6 247.8728-0.9728 -1.5651321.4285746.9 3 50.06357 0.236433 0.38039335.7142950.3 4 55.54031 0.559694 0.9004855056.1 5 60.80885 -0.30885 -0.4969164.2857160.5 6 61.42862 0.671382 1.08017878.5714362.1 7 63.76144 -0.56144 -0.9032992.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -2 -1 0 1 X Variable 1 残差 X Variable 2 Residual Plot 1009080706050403020100 -2 -1 0 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -2 -1 0 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -2 -1 0 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R 0.996465 R Square 0.992943 Adjusted R Square0.978828 标准误差 1.071152 观测值7 方差分析 dfSSMSF Significance F 回归分析4 322.862480.7156 70.34859 0.014065 残差2 2.294733 1.147366 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 15.99537 22.29515 0.717437 0.547582 -79.9329 111.9237 -79.9329 111.9237 X Variable 10.0228120.05262 0.433525 0.706913 -0.20359 0.249219 -0.20359 0.249219 X Variable 20.016859 0.148943 0.113188 0.920219 -0.623990.65771 -0.623990.65771 X Variable 30.4947410.17062 2.8996620.1012 -0.239381.22886 -0.239381.22886 X Variable 4-0.23298 0.361336 -0.64476 0.585164 -1.78768 1.321729 -1.78768 1.321729 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 45.16771 0.432289 0.6990117.14285745.6 2 47.92251 -1.02251-1.653421.4285746.9 3 50.02812 0.271881 0.43963135.7142950.3 4 55.63056 0.469441 0.7590865056.1 560.7934-0.2934 -0.4744364.2857160.5 6 61.449270.65073 1.05222978.5714362.1 7 63.70843 -0.50843 -0.8221392.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -2 -1 0 1 X Variable 1 残差 X Variable 2 Residual Plot 1009080706050403020100 -2 -1 0 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -2 -1 0 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -2 -1 0 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R0.998085 R Square0.996174 Adjusted R Square0.988523 标准误差0.788659 观测值7 方差分析 dfSSMSF Significance F 回归分析4 323.9132 80.97829 130.1937 0.007637 残差2 1.243967 0.621983 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept12.26326 11.24732 1.0903270.38942 -36.1301 60.65657 -36.1301 60.65657 X Variable 10.055151 0.038651 1.4269120.28974 -0.11115 0.221451 -0.11115 0.221451 X Variable 2-0.03865 0.114758 -0.33675 0.768357 -0.53241 0.455119 -0.53241 0.455119 X Variable 30.39945 0.141846 2.816086 0.106357 -0.21086 1.009764 -0.21086 1.009764 X Variable 4-0.14069 0.190924 -0.73687 0.537916 -0.96217 0.680795 -0.96217 0.680795 RESIDUAL OUTPUTPROBABILITY OUTPUT 观测值预测 Y残差标准残差百分比排位Y 1 45.03733 0.5626731.235747.14285745.6 2 47.78196 -0.88196 -1.9369621.4285746.9 3 49.97696 0.323042 0.70946435.7142950.3 4 56.25981 -0.15981 -0.350985056.1 5 60.48392 0.016082 0.03531964.2857160.5 6 61.96089 0.139107 0.30550678.5714362.1 7 63.19913 0.0008740.0019292.8571463.2 X Variable 1 Residual Plot 350300250200150100500 -1 -0.5 0 0.5 1 X Variable 1 残差 X Variable 2 Residual Plot 100806040200 -1 -0.5 0 0.5 1 X Variable 2 残差 X Variable 3 Residual Plot 11210710297928782 -1 -0.5 0 0.5 1 X Variable 3 残差 X Variable 4 Residual Plot 104102100989694929088 -1 -0.5 0 0.5 1 X Variable 4 残差 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y 上限 95.0 X Variable 1 Line Fit Plot 350300250200150100500 0 50 100 X Variable 1 Y Y 预测 Y X Variable 2 Line Fit Plot 100806040200 0 50 100 X Variable 2 Y Y 预测 Y X Variable 3 Line Fit Plot 11210710297928782 0 50 100 X Variable 3 Y Y 预测 Y X Variable 4 Line Fit Plot 108103989388 0 50 100 X Variable 4 Y Y 预测 Y Normal Probability Plot 1009080706050403020100 0 50 100 Sample Percentile Y SUMMARY OUTPUT 回归统计 Multiple R 0.998374 R Square 0.996752 Adjusted R Square0.990255 标准误差 0.726716 观测值7 方差分析 dfSSMSF Significance F 回归分析4 324.1009 81.02523 153.4233 0.006486 残差2 1.056231 0.528116 总计6 325.1571 Coefficients 标准误差t StatP-value Lower 95Upper 95 下限 95.0 上限 95.0 Intercept 17.49235 10.47084 1.6705780.23676-27.56 62.54473-27.56 62.54473 X Variable 1 0.09424 0.031752 2.968005 0.097243 -0.04238 0.230857 -0.04238 0.230857 X