Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: RE: RE: RE: missing values in panel data
From
"Nick Cox" <[email protected]>
To
<[email protected]>
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
[email protected]
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/