Hello All,
I am currently working with a panel data-set where I have missing observations for every column excluding Year and GeoName. I have attached a screenshot for reference.
My objective is to replace my missing observations with the weighted sum of other observations. For example, I would like to replace the missing values in Ethanol_cap21 with .118 * the value given for the District of Columbia + .129 * the value given for Nevada + etc.
I apologize if my question is a little vague. I can happily provide extra information if needed.
Thanks,
Mitchell
Related Posts with How to replace missing observations with the weighted sum of other observations
Continuous or discrete variable?Hello. I have a question regarding a variable I have constructed. For a number of countries, I have…
Failure Rate using 'strate' at multiple exit pointsHi Everone, I am stuck on a problem. I want to graph the failure rate at varying time point viz. 1,…
Plotting result of table functionSorry a very basic question. To get a table I run: table year city [pw=E], c(mean W) and get the …
Descriptive statistic in panel analysis multiple ifsHello to all, I’m using STATA 16. I have a panel data frame with 2 waves. Before and while the Coron…
Creating two groups based on a continuous variable OK, for the sake of transparency, this is not a work issue... I am a clinician-scientist and just c…
Subscribe to:
Post Comments (Atom)
0 Response to How to replace missing observations with the weighted sum of other observations
Post a Comment