月份 1 2 3 4 5 6 7 8 9 10 11 12 销售成本预测 销售量 45.23 32.25 52.61 46.12 62.35 56.78 49.71 52.48 87.94 64.56 86.21 98.17 销售成本 3894.119 3404.607 3722.278 2843.684 3631.989 3251.669 3396.516 3979.185 3351.751 3806.981 2033.848 1735.477 SUMMARY OUTPUT 回归统计 Multiple R R Square Adjusted R Squar 标准误差 观测值 方差分析 回归分析 残差 总计 Coefficients Intercept X Variable 1 RESIDUAL OUTPUT 观测值 1 2 3 4 5 6 7 8 9 10 11 12 RY OUTPUT 回归统计 0.653773 0.427419 0.370161 567.2248 12 df 1 10 11 SS 2401748 3217440 5619188 MS 2401748 321744 F Significance F 7.46478 0.021114 Coefficients 标准误差 t Stat P-value Lower 95% Upper 95% 下限 95.0% 4693.749 551.6952 8.507866 6.841E-06 3464.495 5923.002 3464.495 -23.5194 8.608305 -2.732175 0.021114 -42.69989 -4.338896 -42.69989 AL OUTPUT 预测 Y 残差 3629.966 264.1527 3935.248 -530.6411 3456.393 265.8848 3609.034 -765.3501 3227.314 404.6747 3358.317 -106.6483 3524.599 -128.0835 3459.451 519.7343 2625.453 726.298 3175.336 631.6446 2666.142 -632.2935 2384.85 -649.3725 X Variable 1 Line Fit Plot 5000 Y Y 预测 Y 0 20 30 40 50 60 70 X Variable 1 上限 95.0% 5923.002 -4.338896 80 90 100 110 Y 预测 Y