User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
deer_dog
deer_dog
Level II

oh my - so many different methods to calculate percentiles

Nov 29, 2011 11:55 AM (4560 views)

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 Kudos
0 REPLIES 0

Recommended Articles