Question

求高手，请问怎么用eviews做以下两组数据的相关性研究分析啊，越详细越好

城乡人均收入比率城镇化水平（％）19802.43 16.79 19812.10 17.21 19821.68 17.68 19831.71 18.07 19841.51 18.00 19851.67 22.72 19861.91 23.52 19872.07 25.17 19882.27 26.81 19892.21 28.36 19902.13 28.52 19912.54 26.00 19922.77 29.35 19933.11 30.61 19942.86 28.05 19952.66 31.20 19962.33 33.74 19972.22 31.24 19982.22 31.90 19992.35 33.52 20002.44 40.47 20012.49 40.80 20022.78 41.50 20032.85 42.00 20042.78 42.60 20052.83 43.20 20062.87 43.80 20072.87 44.30 20082.82 45.20 20092.85 46.00 20102.75 49.70 20112.66 51.83 20122.65 53.50 

Answer 1

营业收入x；成交额y
对xy先ADF检验平稳性，结果不成立，取log一阶差分，接受。
然后OLS，对残差检验平稳，若平稳，二者存在协整关系
Dependent Variable: X
Method: Least Squares
Date: 04/04/11 Time: 21:17
Sample (adjusted): 2001 2009
Included observations: 9 after adjustments

Variable Coefficient Std. Error t-Statistic Prob.

Y 1.729571 0.895824 1.930704 0.0948
C 445244.0 48849.27 9.114651 0.0000

R-squared 0.347479 Mean dependent var 534862.9
Adjusted R-squared 0.254261 S.D. dependent var 52873.62
S.E. of regression 45659.64 Akaike info criterion 24.48895
Sum squared resid 1.46E+10 Schwarz criterion 24.53277
Log likelihood -108.2003 Hannan-Quinn criter. 24.39437
F-statistic 3.727616 Durbin-Watson stat 2.713020
Prob(F-statistic) 0.094824

Null Hypothesis: DLOGY has a unit root
Exogenous: Constant
Lag Length: 0 (Automatic - based on SIC, maxlag=1)

t-Statistic Prob.*

Augmented Dickey-Fuller test statistic -4.203801 0.0134
Test critical values: 1% level -4.420595
5% level -3.259808
10% level -2.771129

*MacKinnon (1996) one-sided p-values.
Warning: Probabilities and critical values calculated for 20 observations
and may not be accurate for a sample size of 9

Dependent Variable: DLOGX
Method: Least Squares
Date: 04/04/11 Time: 21:27
Sample (adjusted): 2002 2009
Included observations: 8 after adjustments

Variable Coefficient Std. Error t-Statistic Prob.

DLOGY 0.127386 0.172514 0.738411 0.4881
C 0.005244 0.053907 0.097282 0.9257

Answer 2

在workfile中选中一个变量，按住control再选中第二个变量，然后在其中一个变量名上右击“open as group”， ...

Answer 3

程序1：
均为2阶单整
sh是gdp的格兰杰原因
ols估计协整方程
LNGDP = 4.018108928 + 0.7455044886*LNSH
dw值良好
残差平稳
建立误差修正模型
D(LNGDP) = 0.05750261994 + 0.4555587319*D(LNSH) - 1.025745254*ECM(-1)

程序2：
营业收入x；成交额y
对xy先ADF检验平稳性，结果不成立，取log一阶差分，接受。
然后OLS，对残差检验平稳，若平稳，二者存在协整关系
Dependent Variable: X
Method: Least Squares
Date: 04/04/11 Time: 21:17
Sample (adjusted): 2001 2009
Included observations: 9 after adjustments

Variable Coefficient Std. Error t-Statistic Prob.

Y 1.729571 0.895824 1.930704 0.0948
C 445244.0 48849.27 9.114651 0.0000

R-squared 0.347479 Mean dependent var 534862.9
Adjusted R-squared 0.254261 S.D. dependent var 52873.62
S.E. of regression 45659.64 Akaike info criterion 24.48895
Sum squared resid 1.46E+10 Schwarz criterion 24.53277
Log likelihood -108.2003 Hannan-Quinn criter. 24.39437
F-statistic 3.727616 Durbin-Watson stat 2.713020
Prob(F-statistic) 0.094824

Null Hypothesis: DLOGY has a unit root
Exogenous: Constant
Lag Length: 0 (Automatic - based on SIC, maxlag=1)

t-Statistic Prob.*

Augmented Dickey-Fuller test statistic -4.203801 0.0134
Test critical values: 1% level -4.420595
5% level -3.259808
10% level -2.771129

*MacKinnon (1996) one-sided p-values.
Warning: Probabilities and critical values calculated for 20 observations
and may not be accurate for a sample size of 9

Dependent Variable: DLOGX
Method: Least Squares
Date: 04/04/11 Time: 21:27
Sample (adjusted): 2002 2009
Included observations: 8 after adjustments

Variable Coefficient Std. Error t-Statistic Prob.

DLOGY 0.127386 0.172514 0.738411 0.4881
C 0.005244 0.053907 0.097282 0.9257

Answer 4

可以做的，但是你的数据太乱了，看不清楚
我经常帮别人做这类的数据统计分析的

追问

收费的就算了吧,做个本科论文而已

Answer 5

你这是要做VAR模型吗
还是就是相关分析
可以把数据和参考论文发我邮箱
联系方式看我个人资料

追问

数据和参考论文已发你邮箱了,请问什么时候能发给我