Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: RE: RE: missing values in panel data


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: RE: missing values in panel data
Date   Wed, 4 Aug 2010 16:09:08 +0100

I'd try interpolation on logarithmic scale subject to all values being positive. 

Nick 
n.j.cox@durham.ac.uk 

Schöler, Lisa

I have tried -ipolate- now. When I look at the correlation between the predicted variables and the "real" variables for the years where I have the data the correlation is only .25 which is not very satisfying.
Any other suggestion what could make sense?

Nick Cox

I don't know what is _best_, but I don't see why you think using -ipolate- is not possible, as -ipolate- can also be used for extrapolation. (I don't think there is any command -interpolate-.) 

Schöler, Lisa

in my panel data set (unbalanced) I have a variable called "RD spendings". I have those data for the years 2001-2009 (sometimes less years) for 200 companies each year. Now I need to predict/forecast the missing data for 1999 and 2000. I think that -interpolate- is not possible. Looking at the trend between 2001 and 2009, I can tell that the spendings are rising most of the times. 
Can somebody give me a suggestion what would be the best solution with Stata?

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index