2012年6月成本预测
2012年6月销售成本预测月份 销售量 销售成本1 5888 2004662 4555 926353 6532 2598404 6258 2397865 4605 112551SUMMARY OUTPUT回归统计Multiple R 0.995991687R Square 0.99199944Adjusted R Square 0.989332586标准误差 7753.823392观测值 5方差分析df SS MS F Significance F回归分析 1 22363722590 2.24E+10 371.9737 0.000304残差 3 180365331.6 60121777总计 4 22544087921Coefficients 标准误差 t Stat P-value Lower 95%Intercept -266470.5017 23461.63699 -11.3577 0.001464 -341136X Variable 1 80.38043353 4.167678417 19.28662 0.000304 67.11702RESIDUAL OUTPUT观测值 预测 Y 残差1 206809.4909 -6343.4909022 99662.37301 -7027.373013 258574.4901 1265.5099064 236550.2513 3235.7486925 103681.3947 8869.605314X V a r i a b l e 1 L i n e F i t P l o t7 0 0 06 0 0 05 0 0 04 0 0 03 0 0 02 0 0 01 0 0 0002 0 0 0 0 04 0 0 0 0 0X V a r i a b l e 1Y Y预 测 YUpper 95%下限 95.0%上限 95.0%-191805 -341136 -19180593.64385 67.11702 93.64385Significance FX V a r i a b l e 1 L i n e F i t P l o t7 0 0 06 0 0 05 0 0 04 0 0 03 0 0 02 0 0 01 0 0 0002 0 0 0 0 04 0 0 0 0 0X V a r i a b l e 1Y Y预 测 Y