成本预测
销售成本预测月份 销售量 销售成本1 45.23 3894.119 SUMMARY OUTPUT2 32.25 3404.6073 52.61 3722.278 回归统计4 46.12 2843.684 Multiple R 0.6537735 62.35 3631.989 R Square 0.4274196 56.78 3251.669 Adjusted R Square0.3701617 49.71 3396.516 标准误差 567.22488 52.48 3979.185 观测值 129 87.94 3351.75110 64.56 3806.981 方差分析11 86.21 2033.848 df SS12 98.17 1735.477 回归分析 1 2401748残差 10 3217440总计 11 5619188Coefficients标准误差Intercept 4693.749551.6952X Variable 1 -23.51948.608305RESIDUAL OUTPUT观测值 预测 Y 残差13629.966264.152723935.248-530.64133456.393265.884843609.034 -765.3553227.314404.674763358.317-106.64873524.599-128.08383459.451519.734392625.453 726.298103175.336631.6446112666.142-632.29412 2384.85-649.373MS F Significance F2401748 7.464780.021114321744t Stat P-valueLower 95%Upper 95%下限 95.0%上限 95.0%8.5078666.84E-063464.4955923.0023464.4955923.002-2.732170.021114-42.6999 -4.3389-42.6999 -4.3389X Variable 1 Line Fit Plot1201008060402000200040006000X Variable 1YY预 测 YX Variable 1 Line Fit Plot1201008060402000200040006000X Variable 1YY预 测 Y