实例12-3销售预测方法

年份 销售额1 360,000.002 440,000.003 500,000.004 590,000.005 650,000.00使用方程 使用TREND函数6 727,000.00 727,000.007 800,000.00 800,000.00销 售 额65432100 . 0 01 0 0 , 0 0 0 . 0 02 0 0 , 0 0 0 . 0 03 0 0 , 0 0 0 . 0 04 0 0 , 0 0 0 . 0 05 0 0 , 0 0 0 . 0 06 0 0 , 0 0 0 . 0 07 0 0 , 0 0 0 . 0 0y = 7 3 , 0 0 0 . 0 0 x + 2 8 9 , 0 0 0 . 0 0销 售 额L i n e a r ( 销 售额 )销 售 额65432100 . 0 01 0 0 , 0 0 0 . 0 02 0 0 , 0 0 0 . 0 03 0 0 , 0 0 0 . 0 04 0 0 , 0 0 0 . 0 05 0 0 , 0 0 0 . 0 06 0 0 , 0 0 0 . 0 07 0 0 , 0 0 0 . 0 0y = 7 3 , 0 0 0 . 0 0 x + 2 8 9 , 0 0 0 . 0 0销 售 额L i n e a r ( 销 售额 )SUMMARY OUTPUT回归统计Multiple R0.998222R Square 0.996447Adjusted R Square0.995263标准误差 7958.224观测值 5方差分析df SS MS F Significance F回归分析 1 5.33E+10 5.33E+10 841.4211 0.00009残差 3 1.9E+08 63333333总计 4 5.35E+10Coefficients标准误差 t Stat P-value Lower 95%Upper 95%下限 95.0%上限 95.0%Intercept 289000 8346.656 34.62464 0.000053 262437.2 315562.8 262437.2 315562.8X Variable 1 73000 2516.611 29.00726 0.00009 64991.02 81008.98 64991.02 81008.98