I would like to calculate an estimate of the monthly population with population data sorted by region, gender, age group, and year.
I calculated the estimate by subtracting the previous year's data from the following year's data and adding the monthly value divided by 12.
For example, since the population as of January 1998 was 23424, and 1999 was 25832 (25832-23424)/12 was added to 23424 and estimated the value for February 1998.
What do I write to create time (year and month) variables and calculate the estimate, as shown in the figure from the left to the right in the attached figure?
Thank you in advance for your help. Array
Related Posts with Estimate monthly data with annual time series data
How to run a regression per observationDear all, I'm trying to determine the degree of conservatisme In order to do that I want to use the…
Creating a new data set (monthly to yearly)My monthly data set looks like the following. Code: +---------------------------------------+ | …
Creating Bar Graph with LineDear all, I was wondering if there is someone who can help me with regards to my bar graph. With th…
How to interpret results from xtreg difference in differencesHi- This is my first time posting. I have read a number of super helpful posts (thank you Clyde Sch…
Stata help overconfidence MeasureHi, I am doing research which requires me to calculate a variable of Overconfidence measure for CEO…
Subscribe to:
Post Comments (Atom)
0 Response to Estimate monthly data with annual time series data
Post a Comment