Page 1 of 1

unbalanced/balanced data problem

Posted: Tue Nov 04, 2014 2:55 pm
by franta311
Hello!

I am doing Fixed Effects and Pooled OLS regressions using panel data in EViews 7. In the regression output (7th row) I have: Total panel(unbalanced) observations: 414.
I would like to ask you: why is there "unbalanced", when if I structured my data as Dated panel? Also, why is there only 414 observations, should not there be 42 countries, 13 time period, 12 explanatory variables => (42*13*12) – 151(missing data) = 6401 observations?

Many thanks!
F.

Re: unbalanced/balanced data problem

Posted: Tue Nov 04, 2014 3:43 pm
by EViews Gareth
Some (many, by the sounds of it) observations have missing data.

Re: unbalanced/balanced data problem

Posted: Tue Nov 04, 2014 4:09 pm
by franta311
yeah, 151 observations have missing data, but why it is written 414 observations, if I should have 6401? (42countries*13years*12variables).

Any idea, why it says total panel(unbalanced) in the regression output, even if my data is structured as Panel Data and thefore should be balanced?

Re: unbalanced/balanced data problem

Posted: Tue Nov 04, 2014 4:27 pm
by EViews Gareth
More than 151 observations have missing data.

Re: unbalanced/balanced data problem

Posted: Tue Nov 04, 2014 5:21 pm
by franta311
how can you know? exacly 151 observations have missing data.

and what I would like to also ask you why does it say total panel(unbalanced) in the regression output, even if my data is structured as Panel Data and thefore should be balanced?? - (it is the 7th row in the regression output)

Re: unbalanced/balanced data problem

Posted: Tue Nov 04, 2014 7:46 pm
by EViews Gareth
Well without providing the data, I can only go by the scant clues you've given. But the fact that EViews dropped so many observations indicates that many observations had missing data.

It is unbalanced because cross-sections have missing values at different observations.

Re: unbalanced/balanced data problem

Posted: Wed Nov 05, 2014 5:19 am
by franta311
I am sending my data as attachement

Re: unbalanced/balanced data problem

Posted: Wed Nov 05, 2014 8:52 am
by EViews Gareth
Provide the EViews workfile, with the equation.

Re: unbalanced/balanced data problem

Posted: Wed Nov 05, 2014 12:11 pm
by franta311
sending as an attachment

unbalanced/balanced data problem

Posted: Wed Nov 05, 2014 12:52 pm
by EViews Gareth
The workfile has 546 observations total. The equation uses 414 of them. So 132 are dropped. They are dropped unevenly from different cross-sections, hence the unbalanced nature of the estimation.

Note that observations are counted as rows of data, not individual data values.

Re: unbalanced/balanced data problem

Posted: Wed Nov 05, 2014 1:29 pm
by franta311
ok. thanks.

Does the unbalanced nature effect in any way the results?

Re: unbalanced/balanced data problem

Posted: Wed Nov 05, 2014 1:52 pm
by EViews Gareth
No.

Re: unbalanced/balanced data problem

Posted: Thu Nov 06, 2014 6:39 pm
by franta311
ok, thanks for your help!