BookmarkSubscribe
Choose Language Hide Translation Bar
jcurry
Community Trekker

How can JMP calculate a weighted median?

I have a survey data set with 35000 observations that includes a population weight to estimate the total U.S.  I'm not a SAS expert and I need to calculate weighted median as well as weighted quantiles. I have the weight data tagged with the weight role, but that seems to only apply to weighted averages.  Any suggestions?  Thanks.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User ms
Super User

Re: How can JMP calculate a weighted median?

Try the frequency role in the distribution platform. At least with integer weights JMP gives quantiles that appears to be adequately weighted, at least they seem to be intuitively right. Fraction weights works too, but I don't know how JMP uses them in the quantile calculations.

0 Kudos
2 REPLIES 2
ms
Super User ms
Super User

Re: How can JMP calculate a weighted median?

Try the frequency role in the distribution platform. At least with integer weights JMP gives quantiles that appears to be adequately weighted, at least they seem to be intuitively right. Fraction weights works too, but I don't know how JMP uses them in the quantile calculations.

0 Kudos
jcurry
Community Trekker

Re: How can JMP calculate a weighted median?

Thanks MS...this did exactly what I needed.

0 Kudos