Correlation not accurate

For technical questions regarding estimation of single equations, systems, VARs, Factor analysis and State Space Models in EViews. General econometric questions and advice should go in the Econometric Discussions forum.

Moderators: EViews Gareth, EViews Moderator

bronkomonko
Posts: 2
Joined: Wed Nov 27, 2013 4:20 am

Correlation not accurate

Postby bronkomonko » Mon Dec 02, 2013 4:02 am

I want to see the correlation matrix for more than 100 variables. When I select all of them, open as group and show the correlation matrix the correlation is different than as if I only choose two variables. The values differ significantly which makes an analysis impossible. Am I missing out on something? I just selected the data for the regression, opened as group, then view and covariance analysis where i untick covariance and tick correlation and press ok. Alternatively, I select the data and then go to quick, group satistics and correlation.

How do I get the correct correlation matrix without doing it one by one?

Thanks for your help.

trubador
Did you use forum search?
Posts: 1520
Joined: Thu Nov 20, 2008 12:04 pm

Re: Correlation not accurate

Postby trubador » Mon Dec 02, 2013 5:35 am

You are not doing anything wrong. It may be that the sample periods do not match between the variables. In that case, EViews balance the sample through listwise deletion.


Return to “Estimation”

Who is online

Users browsing this forum: No registered users and 2 guests