cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • See how to design an experiment, explore factor-response relationships, assess tradeoffs, and ID best settings. Register for Sep. 11 Mastering JMP.

Discussions

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

Help with Percentile in JMP- numbers are not matching up with Excel

I have this formula in Excel: =IF(COUNT($E:$E)=0,"",FIXED(PERCENTILE($E:$E,0.9),I15,TRUE()))

My JMP formula is only giving me numbers >10 however my excel is giving >100. 

 

I have attached both my files on these. Thanks!

 

3 REPLIES 3

Re: Help with Percentile in JMP- numbers are not matching up with Excel

JMP's Col Quantile function matches Excel's Percentile.exc function. According to Microsoft, the Percentile function is only included for backwards compatability. When I changed your Excel file to the newer .exc version, I got the same answers in both Excel and JMP.

 

UpliftElk866
Level II

Re: Help with Percentile in JMP- numbers are not matching up with Excel

What is the JMP formula for Percentile.INC? 

Victor_G
Super User

Re: Help with Percentile in JMP- numbers are not matching up with Excel

You can find more infos here : Statistical Details for Quantiles (jmp.com)

Victor GUILLER

"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)

Recommended Articles