资源描述
各月销售额 单位：万元月份 实际销售额1 282 303 35 SUMMARY OUTPUT4 375 42 回归统计6 44 Multiple R7 49 R Square8 48 Adjusted R Square9 50 标准误差10 52 观测值11 6312 77 方差分析回归分析残差总计Intercept月份RESIDUAL OUTPUT观测值1234567891011120.9479879310.8986811180.888549234.63050843812df SS MS F Significance F11901.8341901.83488.698292.75E-0610214.416121.4416111 2116.25Coefficients 标准误差 t Stat P-valueLower 95%Upper 95%下限 95.0%上限 95.0%22.545454552.8498817.9110160.00001316.19552 28.8953916.1955228.895393.6468531470.3872239.4179772.75E-062.784067 4.5096392.7840674.509639预测 实际销售额 残差26.192307691.80769229.839160840.16083933.486013991.51398637.13286713-0.1328740.77972028 1.2202844.42657343-0.4265748.073426570.92657351.72027972-3.7202855.36713287-5.3671359.01398601-7.0139962.660839160.33916166.3076923110.69231SUMMARY OUTPUT回归统计RESIDUAL OUTPUT月 份 Line Fit Plot14121086420020406080100月 份实际销售额实 际 销 售 额预 测 实 际 销 售 额上限 95.0% 各月销售额 单位：万元月份 实际销售额 SUMMARY OUTPUT1 282 30 回归统计3 35 Multiple R 0.9479879314 37 R Square 0.8986811185 42 Adjusted R Square0.888549236 44 标准误差 4.6305084387 49 观测值 128 489 50 方差分析10 52 df SS11 63 回归分析 11901.8339212 77 残差 10214.416084总计 11 2116.25Coefficients 标准误差Intercept 22.545454552.84988094月份 3.6468531470.38722257RESIDUAL OUTPUT观测值 预测实际销售额 残差1 26.192307691.807692312 29.839160840.160839163 33.486013991.513986014 37.13286713-0.13286715 40.779720281.220279726 44.42657343-0.42657347 48.073426570.926573438 51.72027972-3.72027979 55.36713287-5.367132910 59.01398601 -7.01398611 62.660839160.3391608412 66.3076923110.6923077MS F Significance F1901.83488.698286 2.74629E-0621.44161t Stat P-value Lower 95% Upper 95%下限 95.0%上限 95.0%7.9110161.299E-05 16.1955230128.895386 16.19552328.89538619.4179772.746E-06 2.7840673494.50963892.784067354.50963895月 份 Line Fit Plot14121086420050100月 份实际销售额实 际 销 售 额预 测 实 际 销 售 额月 份 Line Fit Plot14121086420050100月 份实际销售额实 际 销 售 额预 测 实 际 销 售 额SUMMARY OUTPUT回归统计Multiple R 0.947987931R Square 0.898681118Adjusted R Square0.88854923标准误差 4.630508438观测值 12方差分析df SS MS回归分析 11901.83392 1901.833916残差 10214.416084 21.44160839总计 11 2116.25Coefficients 标准误差 t StatIntercept 22.545454552.84988094 7.911016297月份 3.6468531470.38722257 9.417976753RESIDUAL OUTPUT观测值 预测实际销售额 残差1 26.192307691.807692312 29.839160840.160839163 33.486013991.513986014 37.13286713-0.13286715 40.779720281.220279726 44.42657343-0.42657347 48.073426570.926573438 51.72027972-3.72027979 55.36713287-5.367132910 59.01398601 -7.01398611 62.660839160.3391608412 66.3076923110.6923077F Significance F88.6982861 2.74629E-06P-value Lower 95% Upper 95% 下限 95.0%上限 95.0%1.2985E-05 16.1955230128.89538609 16.19552328.895386092.7463E-06 2.7840673494.5096389452.784067354.509638945月 份 Line Fit Plot14121086420050100月 份实际销售额实 际 销 售 额预 测 实 际 销 售 额月 份 Line Fit Plot14121086420050100月 份实际销售额实 际 销 售 额预 测 实 际 销 售 额
展开阅读全文