求老师·····
minitab多元回归分析，求老师~~~~~~~~~~~~~~~QQ327565308
看着一堆数据，不知道怎么分析，谢谢大家帮忙了~
数据在此
年份 세금총액y 第一产业X1 第二产业X2 第三产业X3 财政支出X4 金融机构存款总额X5 进出口总额X6
1996 133.1 75.0 714.7 999.5 187.5 3951.7 2433.9
1997 187.4 75.7 781.9 1218.0 262.2 5067.0 2515.2
1998 222.4 76.7 840.6 1458.7 316.8 6274.0 2526.5
1999 259.1 77.1 907.3 1693.2 398.5 7822.3 2842.6
2000 300.5 78.6 1033.3 2049.1 490.3 11526.0 4107.3
2001 391.7 80.8 1142.2 2487.3 614.9 14109.2 4266.1
2002 480.1 84.0 1250.0 2996.4 684.0 17438.4 4346.3
2003 566.9 89.8 1487.2 3446.8 809.4 20476.0 5666.9
2004 717.5 95.5 1853.6 4111.2 974.2 23781.3 7834.1
2005 838.4 98.0 2026.5 4761.8 1137.3 28970.0 10141.0
2006 1003.6 98.0 2191.5 5580.8 1411.6 33793.3 12375.4
额 这个数据还叫多啊，你太懒了呢 luoshichaosm 发表于 2012-5-17 14:27 static/image/common/back.gif
额 这个数据还叫多啊，你太懒了呢
:'(不是~不是，是没接触过，不知道该怎么弄，得到的结果不知道该怎么分析~55555
The regression equation is
Y = - 408 + 5.12 X1 - 0.155 X2 + 0.315 X3 + 0.017 X4 - 0.0215 X5
+ 0.0155 X6
Predictor Coef SE Coef T P
Constant -408.0 289.3 -1.41 0.231
X1 5.122 4.987 1.03 0.362
X2 -0.1546 0.1325 -1.17 0.308
X3 0.31500 0.06841 4.60 0.010
X4 0.0171 0.2023 0.08 0.937
X5 -0.021457 0.005044 -4.25 0.013
X6 0.015533 0.004588 3.39 0.028
S = 7.12017 R-Sq = 100.0% R-Sq(adj) = 99.9%
Analysis of Variance
Source DF SS MS F P
Regression 6 824566 137428 2710.78 0.000
Residual Error 4 203 51
Total 10 824769
Source DF Seq SS
X1 1 791759
X2 1 26952
X3 1 4449
X4 1 1
X5 1 823
X6 1 581
Residual Plots for 税收总额Y
Best Subsets Regression: 税收总额Y versus X1, X2, X3, X4, X5, X6
Response is 税收总额Y
Mallows X X X X X X
Vars R-Sq R-Sq(adj) Cp S 1 2 3 4 5 6
1 99.7 99.7 41.1 16.452 X
1 99.4 99.3 92.8 23.708 X
2 99.9 99.9 14.4 11.102 X X
2 99.8 99.8 20.4 12.696 X X
3 100.0 99.9 3.5 6.8433 X X X
3 99.9 99.8 14.3 11.180 X X X
4 100.0 99.9 4.4 6.7359 X X X X
4 100.0 99.9 4.9 7.0344 X X X X
5 100.0 100.0 5.0 6.3742 X X X X X
5 100.0 99.9 6.1 7.1591 X X X X X
6 100.0 99.9 7.0 7.1202 X X X X X X
그래서 “X4”을 제외한 모든 Xs가 선택된다.
2004년 세수정책 개혁을 했다,2005년 20개성의 농업 세금을 취소 했다.2006년부터
농업 세금을 전국에 취소했으니까 X1을
세금총액y = - 115 + 0.0075 X2 + 0.296 X3- 0.0200 X5 + 0.0103 X6
Regression Analysis: 税收总额Y versus X2, X3, X5, X6
The regression equation is
税收总额Y = - 115 + 0.0075 X2 + 0.296 X3 - 0.0200 X5 + 0.0103 X6
Predictor Coef SE Coef T P VIF
Constant -115.00 18.62 -6.18 0.001
X2 0.00754 0.04502 0.17 0.872
X3 0.29586 0.04157 7.12 0.000
X5 -0.020004 0.005104 -3.92 0.008
X6 0.010331 0.003253 3.18 0.019
S = 7.37472 R-Sq = 100.0% R-Sq(adj) = 99.9%
Analysis of Variance
Source DF SS MS F P
Regression 4 824443 206111 3789.74 0.000
Residual Error 6 326 54
Total 10 824769
Source DF Seq SS
X2 1 816478
X3 1 6452
X5 1 964
X6 1 548
可以到mintiab论坛的QQ群去问问。里面高手挺多的。群 号:306435352
页:
[1]