季度销售成本预测
季度销售成本预测季度 销售量 销售成本第一季度 35.23% 1860.252第二季度 38.31% 1457.123第三季度 36.13% 1670.223第四季度 35.22% 186.525SUMMARY OUTPUT回归统计Multiple R0.258622R Square 0.066885Adjusted R Square-0.39967标准误差 894.5854观测值 4方差分析df SS MS F Significance F回归分析 1 114728 114728 0.143359 0.741378残差 2 1600566 800283.1总计 3 1715294Coefficients标准误差 t Stat P-value Lower 95%Upper 95%下限 95.0%上限 95.0%Intercept -3572.91 12860.61 -0.27782 0.807237 -58907.7 51761.84 -58907.7 51761.84X Variable 113434.87 35483.01 0.378628 0.741378 -139236 166105.9 -139236 166105.9RESIDUAL OUTPUT观测值 预测 Y 残差1 1160.19 700.06232 1573.984 -116.8613 1281.103 389.11954 1158.846 -972.321X V a r i a b l e 1 L i n e F i t P l o t3 5 . 2 3 % 3 8 . 3 1 % 3 6 . 1 3 % 3 5 . 2 2 %01 0 0 02 0 0 0X V a r i a b l e 1Y Y预 测 Y上限 95.0