BookmarkSubscribeRSS Feed
jcurry

Community Trekker

Joined:

Aug 21, 2012

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.

1 ACCEPTED SOLUTION

Accepted Solutions
ms

Super User

Joined:

Jun 23, 2011

Solution

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.

2 REPLIES
ms

Super User

Joined:

Jun 23, 2011

Solution

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.

jcurry

Community Trekker

Joined:

Aug 21, 2012

Re: How can JMP calculate a weighted median?

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