Sheet4SUMMARY OUTPUT回归统计Multiple R 0.998388 R Square 0.996779 Adjusted R Square 0.990338标准误差0.723612观测值7方差分析df SS MS F Significance F回归分析4 324.1099 81.02748 154.7464 0.006431残差2 1.047229 0.523615总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 12.40837 10.42791 1.18992 0.35618-32.4593 57.27605-32.4593 57.27605 X Variable 1 0.044817 0.047873 0.936162 0.448016-0.16116 0.250799-0.16116 0.250799 X Variable 2 0.192306 0.192596 0.998491 0.423231-0.63637 1.020981-0.63637 1.020981 X Variable 3 0.066159 0.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 OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 44.90956 0.690443 1.652657 7.142857 45.6 2 47.53016-0.63016-1.50836 21.42857 46.9 3 50.55686-0.25686-0.61484 35.71429 50.3 4 56.1496-0.0496-0.11872 50 56.1 5 60.3144 0.1856 0.444255 64.28571 60.5 6 61.88438 0.215618 0.516107 78.57143 62.1 7 63.35504-0.15504-0.3711 92.85714 63.2 Sheet5SUMMARY OUTPUT回归统计Multiple R 0.998654 R Square 0.997311 Adjusted R Square 0.991932标准误差0.661238观测值7方差分析df SS MS F Significance F回归分析4 324.2827 81.07067 185.4166 0.005372残差2 0.874471 0.437235总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 12.39761 4.39943 2.818003 0.106235-6.53161 31.32683-6.53161 31.32683 X Variable 1 0.055091 0.021726 2.535736 0.126644-0.03839 0.14857-0.03839 0.14857 X Variable 2 0.09838 0.072095 1.364581 0.305634-0.21182 0.408581-0.21182 0.408581 X Variable 3 0.025801 0.064076 0.402659 0.72616-0.2499 0.301499-0.2499 0.301499 X Variable 4 0.090946 0.134463 0.676366 0.568543-0.4876 0.669492-0.4876 0.669492 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.05986 0.540144 1.414857 7.142857 45.6 2 47.40631-0.50631-1.32623 21.42857 46.9 3 50.5019-0.2019-0.52886 35.71429 50.3 4 56.11652-0.01652-0.04327 50 56.1 5 60.46022 0.039777 0.104191 64.28571 60.5 6 61.65796 0.442041 1.157885 78.57143 62.1 7 63.49723-0.29723-0.77857 92.85714 63.2 Sheet11SUMMARY OUTPUT回归统计Multiple R 0.998551 R Square 0.997104 Adjusted R Square 0.991311标准误差0.686225观测值7方差分析df SS MS F Significance F回归分析4 324.2153 81.05383 172.1238 0.005785残差2 0.941808 0.470904总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 11.78557 7.827164 1.505726 0.27109-21.892 45.46313-21.892 45.46313 X Variable 1 0.053104 0.03147 1.687452 0.23357-0.0823 0.188509-0.0823 0.188509 X Variable 2 0.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 4 0.149193 0.267673 0.557369 0.633331-1.00251 1.300897-1.00251 1.300897 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.10079 0.499211 1.260022 7.142857 45.6 2 47.38634-0.48634-1.22754 21.42857 46.9 3 50.426-0.126-0.31802 35.71429 50.3 4 56.13724-0.03724-0.09399 50 56.1 5 60.70576-0.20576-0.51933 64.28571 60.5 6 61.51386 0.586141 1.479438 78.57143 62.1 7 63.43002-0.23002-0.58058 92.85714 63.2 Sheet12SUMMARY OUTPUT回归统计Multiple R 0.997225 R Square 0.994458 Adjusted R Square 0.983375标准误差0.949199观测值7方差分析df SS MS F Significance F回归分析4 323.3552 80.8388 89.72336 0.011053残差2 1.801957 0.900978总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 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 2 0.125109 0.149183 0.838627 0.489939-0.51678 0.766994-0.51678 0.766994 X Variable 3 0.264319 0.313633 0.842766 0.48808-1.08514 1.613774-1.08514 1.613774 X Variable 4 0.220877 0.265411 0.832207 0.492836-0.92109 1.362848-0.92109 1.362848 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.08111 0.51889 0.946845 7.142857 45.6 2 47.8606-0.9606-1.75286 21.42857 46.9 3 49.99087 0.309127 0.564079 35.71429 50.3 4 55.95497 0.145034 0.264652 50 56.1 5 60.83965-0.33965-0.61978 64.28571 60.5 6 61.53362 0.56638 1.033502 78.57143 62.1 7 63.43917-0.23917-0.43643 92.85714 63.2 Sheet13SUMMARY OUTPUT回归统计Multiple R 0.996429 R Square 0.992871 Adjusted R Square 0.978614标准误差1.076551观测值7方差分析df SS MS F Significance F回归分析4 322.8392 80.7098 69.63967 0.014206残差2 2.317926 1.158963总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 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 2 0.142672 0.244671 0.583117 0.618807-0.91006 1.195405-0.91006 1.195405 X Variable 3 0.150508 0.510137 0.295035 0.795776-2.04444 2.345452-2.04444 2.345452 X Variable 4 0.298433 0.476932 0.625736 0.595376-1.75364 2.350506-1.75364 2.350506 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.22441 0.375587 0.604278 7.142857 45.6 2 47.8728-0.9728-1.56513 21.42857 46.9 3 50.06357 0.236433 0.380393 35.71429 50.3 4 55.54031 0.559694 0.900485 50 56.1 5 60.80885-0.30885-0.49691 64.28571 60.5 6 61.42862 0.671382 1.080178 78.57143 62.1 7 63.76144-0.56144-0.90329 92.85714 63.2 Sheet14SUMMARY OUTPUT回归统计Multiple R 0.996465 R Square 0.992943 Adjusted R Square 0.978828标准误差1.071152观测值7方差分析df SS MS F Significance F回归分析4 322.8624 80.7156 70.34859 0.014065残差2 2.294733 1.147366总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 15.99537 22.29515 0.717437 0.547582-79.9329 111.9237-79.9329 111.9237 X Variable 1 0.022812 0.05262 0.433525 0.706913-0.20359 0.249219-0.20359 0.249219 X Variable 2 0.016859 0.148943 0.113188 0.920219-0.62399 0.65771-0.62399 0.65771 X Variable 3 0.494741 0.17062 2.899662 0.1012-0.23938 1.22886-0.23938 1.22886 X Variable 4-0.23298 0.361336-0.64476 0.585164-1.78768 1.321729-1.78768 1.321729 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.16771 0.432289 0.699011 7.142857 45.6 2 47.92251-1.02251-1.6534 21.42857 46.9 3 50.02812 0.271881 0.439631 35.71429 50.3 4 55.63056 0.469441 0.759086 50 56.1 5 60.7934-0.2934-0.47443 64.28571 60.5 6 61.44927 0.65073 1.052229 78.57143 62.1 7 63.70843-0.50843-0.82213 92.85714 63.2 Sheet15SUMMARY OUTPUT回归统计Multiple R 0.998085 R Square 0.996174 Adjusted R Square 0.988523标准误差0.788659观测值7方差分析df SS MS F Significance F回归分析4 323.9132 80.97829 130.1937 0.007637残差2 1.243967 0.621983总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 12.26326 11.24732 1.090327 0.38942-36.1301 60.65657-36.1301 60.65657 X Variable 1 0.055151 0.038651 1.426912 0.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 3 0.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 OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.03733 0.562673 1.23574 7.142857 45.6 2 47.78196-0.88196-1.93696 21.42857 46.9 3 49.97696 0.323042 0.709464 35.71429 50.3 4 56.25981-0.15981-0.35098 50 56.1 5 60.48392 0.016082 0.035319 64.28571 60.5 6 61.96089 0.139107 0.305506 78.57143 62.1 7 63.19913 0.000874 0.00192 92.85714 63.2 Sheet16SUMMARY OUTPUT回归统计Multiple R 0.998374 R Square 0.996752 Adjusted R Square 0.990255标准误差0.726716观测值7方差分析df SS MS F Significance F回归分析4 324.1009 81.02523 153.4233 0.006486残差2 1.056231 0.528116总计6 325.1571 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 17.49235 10.47084 1.670578 0.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 Variable 2-0.07347 0.10843-0.67759 0.567909-0.54001 0.393067-0.54001 0.393067 X Variable 3 0.325575 0.104561 3.113739 0.08951-0.12431 0.775465-0.12431 0.775465 X Variable 4-0.18967 0.182377-1.03998 0.407565-0.97437 0.595035-0.97437 0.595035 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 45.04062 0.55938 1.333223 7.142857 45.6 2 47.71421-0.81421-1.94057 21.42857 46.9 3 50.0977 0.202296 0.482151 35.71429 50.3 4 56.1264-0.0264-0.06293 50 56.1 5 60.47504 0.02496 0.05949 64.28571 60.5 6 62.20847-0.10847-0.25852 78.57143 62.1 7 63.03756 0.162439 0.387157 92.85714 63.2 Sheet26SUMMARY OUTPUT回归统计Multiple R 0.995375 R Square 0.990771 Adjusted R Square 0.972313标准误差1.241707观测值7方差分析df SS MS F Significance F回归分析4 331.0449 82.76123 53.67708 0.018373残差2 3.083671 1.541835总计6 334.1286 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 32.10406 44.58651 0.72004 0.546279-159.736 223.9443-159.736 223.9443 X Variable 1 0.012826 0.079453 0.161429 0.886589-0.32903 0.354686-0.32903 0.354686 X Variable 2 0.419381 0.192425 2.179451 0.161129-0.40856 1.247318-0.40856 1.247318 X Variable 3-0.67904 0.571841-1.18746 0.35696-3.13947 1.781396-3.13947 1.781396 X Variable 4 0.335496 0.382137 0.877948 0.472567-1.30871 1.979699-1.30871 1.979699 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 24.4596-0.0596-0.08314 7.142857 24.4 2 28.0958 0.404204 0.563822 21.42857 28.5 3 32.91468-1.31468-1.83384 35.71429 31.6 4 36.90325 0.996746 1.390357 50 37.9 5 38.18257 0.317429 0.442781 64.28571 38.5 6 41.53998-0.03998-0.05577 78.57143 41.5 7 45.60412-0.30412-0.42421 92.85714 45.3 Sheet27SUMMARY OUTPUT回归统计Multiple R 0.997485 R Square 0.994976 Adjusted R Square 0.984928标准误差0.916147观测值7方差分析df SS MS F Significance F回归分析4 332.4499 83.11248 99.02291 0.010023残差2 1.678652 0.839326总计6 334.1286 Coefficients标准误差t Stat P-value Lower 95%Upper 95%下限95.0%上限95.0%Intercept 20.18455 28.66558 0.704139 0.55429-103.153 143.5226-103.153 143.5226 X Variable 1 0.065251 0.049726 1.312195 0.319828-0.1487 0.279206-0.1487 0.279206 X Variable 2 0.236026 0.18888 1.249608 0.33785-0.57666 1.048713-0.57666 1.048713 X Variable 3-0.29611 0.511034-0.57943 0.620869-2.49491 1.902691-2.49491 1.902691 X Variable 4 0.064352 0.291022 0.221125 0.845518-1.18782 1.316521-1.18782 1.316521 RESIDUAL OUTPUT PROBABILITY OUTPUT观测值预测Y残差标准残差百分比排位Y 1 24.73028-0.33028-0.62442 7.142857 24.4 2 28.04265 0.45735 0.864657 21.42857 28.5 3 32.25055-0.65055-1.22993 35.71429 31.6 4 37.29494 0.605065 1.143924 50 37.9 5 38.47738 0.022623 0.04277 64.28571 38.5 6 41.02053 0.479468 0.906472 78.57143 41.5 7 45.88367-0.58367-1.10348 92.85714 45.3 Sheet35。
""""""此处省略40%，请
登录会员，阅读正文所有内容。
