51量本利之多业务量成本分解.xls

《51量本利之多业务量成本分解.xls》由会员分享，可在线阅读，更多相关《51量本利之多业务量成本分解.xls（5页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、月 份产品A（X1）产品B（X2）成本Y146.32415436SUMMARY OUTPUT255.34516430352.381026512回归统计457.15817465Multiple R 0.964173555.47816983R Square 0.929629654.64817427Adjusted R Square0.913991763.72919632标准误差 2541.865870.071223074观测值12999.62163365310103.331734616方差分析11115.352035141df12120.452238427回归分析2残差9总计11X1、X2与Y的复

2、相关系数0.964173产品A单位变动成本22.48420863Coefficients产品B单位变动成本1326.450259Intercept 7526.844固定成本7526.844081X Variable 122.48421二元回归方程Y=22.4842X1+1326.4502*X2+7526.85X Variable 2 1326.45SSMSF Significance F7.68E+08 3.84E+08 59.44707 6.51E-065814971564610798.26E+08标准误差t StatP-value Lower 95%Upper 95% 下限 95.0% 上

3、限 95.0%3081.053 2.442945 0.037185 557.0172 14496.67 557.0172 14496.67114.7033 0.196021 0.848948 -236.993281.961 -236.993281.961531.28352.49669 0.034046 124.6036 2528.297 124.6036 2528.297月 份业务量X1业务量X2业务量X3业务量X4146.3241.505.1255.3451.554.5352.38102.002.2457.1581.684.1555.4781.703.6654.6481.683763.729

4、1.782.8870.07121.902.7999.62162.502.6510103.33172.552.611115.35202.601.512120.45222.901.2X1、X2、X3、X4、X5与Y的复相关系数0.998273683X1的单位变动成本14.80118775X2的单位变动成本21.83364878X3的单位变动成本419.0759022X4的单位变动成本174.4893535X5的单位变动成本206.5198064固定成本5.169523745多元回归方程Y=14.8*X1+21.83*X2+419.08*X3+174.49*X4+206.52*X5+5.17业务量X

5、5成本费用YSUMMARY OUTPUT12423.0012580.00回归统计22600.00Multiple R0.99827412650.00R Square0.9965512610.00Adjusted R Square0.99367622650.00标准误差60.4121422800.00观测值1223000.0034000.00方差分析34100.00dfSSMSF34050.00回归分析563259171265183346.66144500.00残差6 21897.76 3649.627总计116347815Coefficients 标准误差t StatP-valueInterc

6、ept5.169524 273.5358 0.018899 0.985535X Variable 114.80119 4.672358 3.167819 0.019372X Variable 221.83365 35.10927 0.621877 0.556899X Variable 3419.0759 259.4106 1.615493 0.157331X Variable 4174.4894 64.31949 2.712854 0.034973X Variable 5206.5198 76.23067 2.709143 0.035146Significance F2.68E-07Lower 95%Upper 95% 下限 95.0% 上限 95.0%-664.149 674.4876 -664.149 674.48763.368339 26.23404 3.368339 26.23404-64.0756 107.7429 -64.0756 107.7429-215.679 1053.831 -215.679 1053.83117.10524 331.8735 17.10524 331.873519.99009 393.0495 19.99009 393.0495