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!