cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
deer_dog
Level II

oh my - so many different methods to calculate percentiles

http://www.amstat.org/publications/jse/v14n3/langford.html

Gosh - I did not realize there were so many different ways to calculate percentiles! I just noticed my results from Excel (formula =percentile (array, percentile) and JMP (quantile plots and data) differed, and that led me to the above website, which identifies about 12 or more different methods! I am at a bit of a loss, for I often use results from both programs (obviously that has to change). Or I calculate percentiles in Excel when summarizing data and run stats in JMP later - which means two different methods were used.

The above publication recommends one alternative that is given in SAS, which I believe is a bit different than the JMP method.

I suppose the best solution would be if there was a way to make the same calculation in JMP and excel, since those are the programs I mostly use. Is there?

Thanks in advance.

0 REPLIES 0