Subscribe Bookmark RSS Feed

How can JMP calculate a weighted median?

jcurry

Community Trekker

Joined:

Aug 21, 2012

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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.

2 REPLIES
Solution

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.

jcurry

Community Trekker

Joined:

Aug 21, 2012

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