成本预测EXCEL表格

销售成本预测

月份销售量销售成本

145.233894.119SUMMARY OUTPUT

232.253404.607

352.613722.278回归统计

446.122843.684Multiple R0.653773

562.353631.989R Square0.427419

656.783251.669Adjusted R Squar0.370161

749.713396.516标准误差567.2248

852.483979.185观测值12

987.943351.751

1064.563806.981方差分析

1186.212033.848df SS 1298.171735.477回归分析12401748

残差103217440

总计115619188

Coefficients标准误差

Intercept4693.749551.6952

X Variable 1-23.51948.608305

RESIDUAL OUTPUT

观测值预测 Y残差

13629.966264.1527

23935.248-530.641

33456.393265.8848

43609.034-765.35

53227.314404.6747

63358.317-106.648

73524.599-128.083

83459.451519.7343

92625.453726.298

103175.336631.6446

112666.142-632.294

122384.85-649.373

MS F Significance F

24017487.464780.021114

321744

t Stat P-value Lower 95%Upper 95%下限 95.0%上限 95.0% 8.507866 6.84E-063464.4955923.0023464.4955923.002 -2.732170.021114-42.6999-4.3389-42.6999-4.3389