九、附录
B类产品SPSS拟合输出表格:
线性分析:
Model Summary
R .999 R Square .998 Adjusted R Square .998 Std. Error of the Estimate 1326.825
ANOVASum ofSquares3E+010492929923E+010df12829Mean Square2.548E+0101760464.009F14472.198Sig..000RegressionResidualTotalThe independent variable is 日期. Coefficients 日期(Constant)UnstandardizedCoefficientsBStd. Error3366.90627.9871221.625496.860StandardizedCoefficientsBeta.999t120.3002.459Sig..000.020 二次分析:
Model SummaryR.999R Square.999AdjustedR Square.999Std. Error ofthe Estimate1096.257The independent variable is 日期. ANOVA RegressionResidualTotalSum ofSquares3E+010324480673E+010df22729Mean Square1.275E+0101201780.241F10607.026Sig..000The independent variable is 日期. 16
CoefficientsUnstandardizedCoefficientsBStd. Error3714.15395.590-11.2022.992-630.357642.824StandardizedCoefficientsBeta1.102-.106日期日期 ** 2(Constant)t38.855-3.744-.981Sig..000.001.335
三次分析:
Model SummaryR1.000R Square.999AdjustedR Square.999Std. Error ofthe Estimate946.082The independent variable is 日期. ANOVA RegressionResidualTotalSum ofSquares3E+010232718303E+010df32629Mean Square8501268489895070.396F9497.877Sig..000The independent variable is 日期. Coefficients 日期日期 ** 2日期 ** 3(Constant)UnstandardizedCoefficientsBStd. Error4354.403216.310-61.99816.0731.092.341-2418.382787.152StandardizedCoefficientsBeta1.292-.588.301t20.130-3.8573.202-3.072Sig..000.001.004.005
C类分析结果:
17
Model SummaryR.996R Square.992AdjustedR Square.991Std. Error ofthe Estimate3552.502The independent variable is 日期. ANOVA RegressionResidualTotalSum ofSquares4E+0103E+0084E+010df32629Mean Square1.286E+01012620267.05F1018.966Sig..000The independent variable is 日期. Coefficients 日期日期 ** 2日期 ** 3(Constant)UnstandardizedCoefficientsBStd. Error6880.362812.235-212.75160.3554.5001.281-6927.2852955.728StandardizedCoefficientsBeta1.654-1.6341.006t8.471-3.5253.513-2.344Sig..000.002.002.027
D类分析结果:
线性分析:
Model SummaryR.999R Square.997AdjustedR Square.997Std. Error ofthe Estimate1468.437The independent variable is 日期.
18
ANOVASum ofSquares2E+010603765662E+010df12829Mean Square2.131E+0102156305.933F9880.485Sig..000RegressionResidualTotalThe independent variable is 日期. Coefficients 日期(Constant)UnstandardizedCoefficientsBStd. Error3078.89230.975-1392.628549.890StandardizedCoefficientsBeta.999t99.401-2.533Sig..000.017
二次分析:
Model SummaryR.999R Square.997AdjustedR Square.997Std. Error ofthe Estimate1490.414The independent variable is 日期. ANOVA RegressionResidualTotalSum ofSquares2E+010599760252E+010df22729Mean Square1.065E+0102221334.243F4795.710Sig..000The independent variable is 日期. Coefficients 日期日期 ** 2(Constant)UnstandardizedCoefficientsBStd. Error3132.438129.959-1.7274.068-1678.206873.950StandardizedCoefficientsBeta1.016-.018t24.103-.425-1.920Sig..000.674.065 19
三次分析:
Model SummaryR.999R Square.997AdjustedR Square.997Std. Error ofthe Estimate1493.006The independent variable is 日期. ANOVA RegressionResidualTotalSum ofSquares2E+010579557262E+010df32629Mean Square71025897332229066.388F3186.352Sig..000The independent variable is 日期. Coefficients 日期日期 ** 2日期 ** 3(Constant)UnstandardizedCoefficientsBStd. Error2832.021341.35722.10725.365-.513.538-839.2311242.201StandardizedCoefficientsBeta.919.229-.155t8.296.872-.952-.676Sig..000.391.350.505 根据表格给出的相关系数R,决定系数R2,回归估计的标准差S,以及置信水平综合考虑可得出A,B,C,D类更适合的模型。
Excel处理线性规划如图所示:
20