Need a help on Linear Interpolation

[Markov]

Hi Reeza,

Main reason for doing this is to have estimated yearly observations from the census data which is only estimated by 10 year period.

Best,

Markov

[Reeza]

I figured that out, but why do you need annual data. Linear interpolation from a statistical standpoint may not be a valid interpolation method for what you're trying to do is my point.

http://gking.harvard.edu/files/pr.pdf

[Markov]

Valid point and thank you for pointing this out Reeza. I am just in a trial phase: the primary variable in interest is in annual basis & figured that some of literature have adopted linear interpolation for socioeconomic variables.

Thanks,

Markov 

[Jack1]

Hi there, I am trying to do the same thing as this user -- do a linear interpolation.  However my data are semi-annual and I want to go to a monthly frequency.  I have three reported periods: Dec. 2014, June 2015 and Dec. 2015 with the remaining months in between to be generated.  I have attached a screenshot of the data.  

I tried modifying code in this thread but no luck.  

I am new to this so any help greatly appreciated.

Thanks

Jack