(9-3)时间序列数据分析表.xlsxVIP

年份 t 财政收入 预测值 残差 残差平方

2000 1 126.15 120.04 6.11 37.28 2.100887255

2001 2 150.18 151.87 -1.69 2.85 2.1766121

2002 3 196.54 192.13 4.41 19.49 2.293450952

2003 4 230.89 243.06 -12.17 148.01 2.363405124

2004 5 288.6 307.49 -18.89 356.74 2.460296327

2005 6 389.36 389.00 0.36 0.13 2.590351333

2006 7 502.36 492.12 10.24 104.87 2.701015052

2007 8 634.06 622.58 11.48 131.90 2.802130356

2008 9 791.31 787.61 3.70 13.66 2.898346654

2009 10 1005.03 996.40 8.63 74.44 3.002179026

合计 - 4314.48 4302.29 - 889.37

a 94.89

b 1.265090262

SUMMARYOUTPUT 10回归统计

MultipleR 0.998838742

RSquare 0.997678833

AdjustedRSquare 0.997388687

标准误差 0.0158182

观测值 10

方差分析

df SS MS F SignificanceF

回归分析 1 003438.541583 7.94488E-12

残差 8 0.002001724 0.000250215

总计 9 0.862378004

Coefficients 标准误差 tStat P-value Lower95% Upper95% 下限95.0% 上限95.0%

Intercept 1.977199097 0.010805888 182.9742345 8.90687E-16 1.952280674 2.002117519 1.952280674 2.002117519

XVariable1 0.102121513 0.001741527 587.94488E-12 0.098105545 00.098105545 0