I have an income band frequency distribution table for which I need to interpolate observations. The ipolate command works fine, except for the fact that I also know the mean income for the entire distribution, and I'd like the mean of the interpolated data to match the known mean.
Does anyone know of anyway of doing this? Ideally, all I ought to give a STATA command is the income band limits, frequency for each band, and the average of the entire sample.
I'd appreciate any help in this matter.
Thanks much,
Rikhil
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/