Hi everyone! I am trying to figure out how to calculate a weighted median, and I can't for the life of me figure it out. I have searched the internet and most suggestions actually lead you to a weighted average or a simple median. The solution that seemed most promising was in a thread on this forum called "Weighted Percentile Calculation Help" posted by g3diamondback back in 2014, which uses an INDEX formula to essentially create a new list of numbers where numbers repeat depending on their weight - however I don't think it works in my situation because all my weights are non-whole numbers, so you can't really create a new set of numbers with one cell per number where one number counts for 239.6794891 appearances in the data set.
Here is a sample of the data:
fam_inc: family income, the variable I would like to get the median of
weight: the weight for each income, which I would like to apply to the median calculation
fam_inc weight 5149 33.67798233 5106 188.9760132 5072 3.108463287 4994 611.1603394 4982 48.08955765 4975 51.73936081 4940 51.73936081 4893 699.7153931 4877 500.3041077 4864 51.73936081 4783 47.6829071 4694 51.73936081 4612 9.833632469 4604 1.244086146 4543 85.56001282 4519 47.6829071 4499 58.2733078 4429 44.60183716 4420 51.73936081
Thank you for your help!
Bookmarks