量本利之多业务量成本分解

月份,业务量X1,业务量X2,业务量X3,业务量X4,业务量X5,成本费用Y,,SUMMARYOUTPUT,,,,,,,,

1,46.32,4,1.50,5.1,1,2423.00,,,,,,,,,,

2,55.34,5,1.55,4.5,1,2580.00,,回归统计,,,,,,,,

3,52.38,10,2.00,2.2,2,2600.00,,MultipleR,0.998273683,,,,,,,

4,57.15,8,1.68,4.1,1,2650.00,,RSquare,0.996550346,,,,,,,

5,55.47,8,1.70,3.6,1,2610.00,,AdjustedRSquare,0.993675635,,,,,,,

6,54.64,8,1.68,3,2,2650.00,,标准误差,60.41214475,,,,,,,

7,63.72,9,1.78,2.8,2,2800.00,,观测值,12,,,,,,,

8,70.07,12,1.90,2.7,2,3000.00,,,,,,,,,,

9,99.62,16,2.50,2.65,3,4000.00,,方差分析,,,,,,,,

10,103.33,17,2.55,2.6,3,4100.00,,,df,SS,MS,F,SignificanceF,,,

11,115.35,20,2.60,1.5,3,4050.00,,回归分析,5,6325917.153,1265183.431,346.6610012,2.68354E-07,,,

12,120.45,22,2.90,1.2,4,4500.00,,残差,6,21897.7634,3649.627233,,,,,

,,,,,,,,总计,11,6347814.917,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,Coefficients,标准误差,tStat,P-value,Lower95%,Upper95%,下限95.0%,上限95.0%

,,,,,,,,Intercept,5.169523745,273.5358471,0.018898889,0.985534556,-664.1485809,674.4876284,-664.1485809,674.4876284

X1、X2、X3、X4、X5与Y的复相关系数,0.998273683,,,,,,,XVariable1,14.80118775,4.672358434,3.167819413,0.019372171,3.368338547,26.23403695,3.368338547,26.23403695

X1的单位变动成本,14.80118775,,,,,,,XVariable2,21.83364878,35.1092653,0.62187712,0.556898812,-64.07562841,107.742926,-64.07562841,107.742926

X2的单位变动成本,21.83364878,,,,,,,XVariable3,419.0759022,259.4105656,1.615492805,0.157331265,-215.6788838,1053.830688,-215.6788838,1053.830688

X3的单位变动成本,419.0759022,,,,,,,XVariable4,174.4893535,64.31948834,2.712853569,0.034973198,17.10523551,331.8734715,17.10523551,331.8734715

X4的单位变动成本,174.4893535,,,,,,,XVariable5,206.5198064,76.23066581,2.709143416,0.035146067,19.99008717,393.0495256,19.99008717,393.0495256

X5的单位变动成本,206.5198064,,,,,,,,,,,,,,,

固定成本,5.169523745,,,,,,,,,,,,,,,

多