统计学回归分析大作业

问题的提出表建筑行业总动力装备率劳动力人数产值（亿元）（千瓦/人）（万人）技术装备国有企业所年份占比重1995199619971998199920002001200220032004200520062007200820092010201120125793.758282.254.704.604.104.304.504.604.864.914.855.805.104.924.975.505.204.665.665.691497.872121.872101.512029.992020.131994.302110.662245.192414.272557.862699.922878.163133.713314.953672.564160.443852.474267.244264.004154.004729.005127.005756.006304.007136.009675.009957.009297.009273.489109.149208.369915.0010088.009547.0412025.2913374.170.630.500.500.450.440.400.350.300.260.260.240.220.210.200.200.190.180.179126.4810061.9911152.8612497.6015361.5618527.1823083.8727745.3834552.1041557.1651043.7162036.8176807.7496031.13116463.32137217.86，/XXXX1234Y=β+βX+βX+βX+βX011223344相关性问题图表p以建立回归模型R为，F为PXP1P值修改模型42074.597222726.2833338274.41556.316666666740200.244255827.87715362691.388053.1378831559918181818劳动力人数（万人）技术装备率（元/人）国有企业所占比重劳动力人数（万/.826.8301.000-.928.000.000..000.000.00018.00018劳动力人数（万人）技术装备率（元/人）国有企业所占比重1818181818国有企业所占比重-.747-.842-.9281.000.000.000.000.劳动力人数（万人）技术装备率（元/人）国有企业所占比重建筑行业总产值N18劳动力人数（万人）技术装备率（元/人）国有企业所占比重181818VariablesbMethod.Entera.Allrequestedvariablesentered.b.DependentVariable:建筑行业总产值Durbin-Watson1.5906231.513036a.Predictors:(Constant),国有企业所占比重,劳动力人数（万人）,技术装备率（元/人）b.DependentVariable:建筑行业总产值Sig..000a38831754.722a.Predictors:(Constant),国有企业所占比重,劳动力人数（万人）,技术装备率（元/人）b.DependentVariable:建筑行业总产值UnstandardizedCoefficientsModelBStd.Error23531.4853.486劳动力人数（万人）技术装备率（元/人）国有企业所占比重1.552194120.92631268.974-9.72014.4795.5856.208.000.000.000.000劳动力人数（万人）技术装备率（元/人）国有企业所占比重.968.831.856.580.666-.747aCorrelationsPart劳动力人数（万人）技术装备率（元/人）国有企业所占比重3.647.210.233.131.1237.6358.138Coefficienta国有企业所占比劳动力人数（万/人）人）1.000.343.761.761-.2451.0009.777E837445.78336909.14337445.78312.15636909.143-1.3242.408ConditionIndex1.0001234.289.015.0033.57615.94136.835CollinearityDiagnosticsaVarianceProportions劳动力人数（万/国有企业所占比人）人）1234.00.01.88.11.00.01.32.67.00.04.00.96.00.01.99135586.562502.35042074.59722.000Std.PredictedValueStandardErrorofPredictedValue4660.5262824.607133515.8281311562.8203131.85642288.54061.000000.000-.01615130.2998052.484-213.943388.0012.833.348.071CenteredLeverageValue.053.504.167ResidualsaStd.Deviation181818Std.PredictedValueStandardErrorofPredictedValue181818181818181818CenteredLeverageValue.1411.拟合优度分析有表可知，调整样本决定系数为0.976，拟合良好。2.回归方程显著性检测F=231.163。P=0.000，故明显显著。3.回归系数显著性检验三个变量t值均大于1.734，P值均为0.000，故通过检验。4.残差分析——正态性检验有图可以看到，基本符合正态性假设。5.残差分析——异方差分析由残差图和残差相关系数得知，不存在显著的异方差。6.自相关性分析。D.W.指数为1.590.du=1.27，故不存在自相关。7.共线性诊断各项