第13章 例13-7 一元一次模型成本预测

销量成本资料月份 销售量（件） 销售成本（元）1 46.32 15436 SUMMARY OUTPUT2 55.34 164303 52.38 26512 回归统计4 57.15 17465 Multiple R0.9385635 55.47 16983 R Square 0.8809016 54.63 17427 Adjusted R Square0.8689917 63.72 19632 标准误差 3137.1258 70.05 23074 观测值 129 99.62 3365310 103.33 34616 方差分析11 115.35 35141 df SS MS12 120.45 38427 回归分析 1 7.28E+08 7.28E+08残差 10 98415533 9841553总计 11 8.26E+08Coefficients标准误差 t StatIntercept2219.459 2751.699 0.806578X Variable 1300.0218 34.88536 8.600221RESIDUAL OUTPUT观测值 预测 Y 残差1 16116.47 -680.4692 18822.67 -2392.673 17934.6 8577.3994 19365.71 -1900.715 18861.67 -1878.676 18609.65 -1182.657 21336.85 -1704.858 23235.99 -161.9879 32107.63 1545.36810 33220.71 1395.28811 36826.97 -1685.9712 38357.09 69.91419F Significance F73.96379 6.21E-06P-value Lower 95%Upper 95%下限 95.0%上限 95.0%0.438671 -3911.71 8350.627 -3911.71 8350.6276.21E-06 222.2924 377.7512 222.2924 377.7512X V a r i a b l e 1 L i n e F i t P l o t14012010080604020001000020000300004000050000X V a r i a b l e 1Y Y预 测 YX V a r i a b l e 1 L i n e F i t P l o t14012010080604020001000020000300004000050000X V a r i a b l e 1Y Y预 测 Y