cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-587811%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EJMP%20%E3%81%AE%E3%83%91%E3%83%BC%E3%82%BB%E3%83%B3%E3%82%BF%E3%82%A4%E3%83%AB%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%98%E3%83%AB%E3%83%97%20-%20%E6%95%B0%E5%80%A4%E3%81%8C%20Excel%20%E3%81%A8%E4%B8%80%E8%87%B4%E3%81%97%E3%81%AA%E3%81%84%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-587811%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EExcel%20%E3%81%AB%E6%AC%A1%E3%81%AE%E5%BC%8F%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%3A%20%3DIF(COUNT(%24E%3A%24E)%3D0%2C%22%22%2CFIXED(PERCENTILE(%24E%3A%24E%2C0.9)%2CI15%2CTRUE()))%3C%2FP%3E%3CP%3E%E7%A7%81%E3%81%AE%20JMP%20%E6%95%B0%E5%BC%8F%E3%81%AF%2010%20%E3%82%92%E8%B6%85%E3%81%88%E3%82%8B%E6%95%B0%E5%80%A4%E3%81%97%E3%81%8B%E4%B8%8E%E3%81%88%E3%81%BE%E3%81%9B%E3%82%93%E3%81%8C%E3%80%81Excel%20%E3%81%AF%20100%20%E3%82%92%E8%B6%85%E3%81%88%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%81%93%E3%82%8C%E3%82%89%E3%81%AB%E4%B8%A1%E6%96%B9%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E6%B7%BB%E4%BB%98%E3%81%97%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%20%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%EF%BC%81%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-587811%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E5%88%86%E6%9E%90%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-587877%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%20%E3%81%AE%E3%83%91%E3%83%BC%E3%82%BB%E3%83%B3%E3%82%BF%E3%82%A4%E3%83%AB%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%98%E3%83%AB%E3%83%97%20-%20%E6%95%B0%E5%80%A4%E3%81%8C%20Excel%20%E3%81%A8%E4%B8%80%E8%87%B4%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-587877%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20%E3%81%AE%20Col%20Quantile%20%E9%96%A2%E6%95%B0%E3%81%AF%E3%80%81Excel%20%E3%81%AE%20Percentile%20%E3%81%A8%E4%B8%80%E8%87%B4%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3CSTRONG%3E%E7%82%BA%E6%9B%BF%3C%2FSTRONG%3E%E9%96%A2%E6%95%B0%E3%80%82%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fpercentile-function-91b43a53-543c-4708-93de-d626debdddca%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%E3%83%9E%E3%82%A4%E3%82%AF%E3%83%AD%E3%82%BD%E3%83%95%E3%83%88%E3%81%AB%E3%82%88%E3%82%8B%E3%81%A8%3C%2FA%3E%E3%80%81%E3%83%91%E3%83%BC%E3%82%BB%E3%83%B3%E3%82%BF%E3%82%A4%E3%83%AB%E9%96%A2%E6%95%B0%E3%81%AF%E4%B8%8B%E4%BD%8D%E4%BA%92%E6%8F%9B%E6%80%A7%E3%81%AE%E3%81%9F%E3%82%81%E3%81%AB%E3%81%AE%E3%81%BF%E5%90%AB%E3%81%BE%E3%82%8C%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20Excel%20%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E6%96%B0%E3%81%97%E3%81%84%20.exc%20%E3%83%90%E3%83%BC%E3%82%B8%E3%83%A7%E3%83%B3%E3%81%AB%E5%A4%89%E6%9B%B4%E3%81%97%E3%81%9F%E3%81%A8%E3%81%93%E3%82%8D%E3%80%81Excel%20%E3%81%A8%20JMP%20%E3%81%AE%E4%B8%A1%E6%96%B9%E3%81%A7%E5%90%8C%E3%81%98%E5%9B%9E%E7%AD%94%E3%81%8C%E5%BE%97%E3%82%89%E3%82%8C%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-588401%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%20%E3%81%AE%E3%83%91%E3%83%BC%E3%82%BB%E3%83%B3%E3%82%BF%E3%82%A4%E3%83%AB%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%98%E3%83%AB%E3%83%97%20-%20%E6%95%B0%E5%80%A4%E3%81%8C%20Excel%20%E3%81%A8%E4%B8%80%E8%87%B4%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-588401%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EPercentile.INC%20%E3%81%AE%20JMP%20%E5%BC%8F%E3%81%AF%E4%BD%95%E3%81%A7%E3%81%99%E3%81%8B%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-588410%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JMP%20%E3%81%AE%E3%83%91%E3%83%BC%E3%82%BB%E3%83%B3%E3%82%BF%E3%82%A4%E3%83%AB%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%98%E3%83%AB%E3%83%97%20-%20%E6%95%B0%E5%80%A4%E3%81%8C%20Excel%20%E3%81%A8%E4%B8%80%E8%87%B4%E3%81%97%E3%81%BE%E3%81%9B%E3%82%93%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-588410%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%93%E3%81%93%E3%81%A7%E8%A9%B3%E7%B4%B0%E6%83%85%E5%A0%B1%E3%82%92%E8%A6%8B%E3%81%A4%E3%81%91%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%EF%BC%9A%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F17.0%2F%23page%2Fjmp%2Fstatistical-details-for-quantiles.shtml%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%E5%88%86%E4%BD%8D%E6%95%B0%E3%81%AE%E7%B5%B1%E8%A8%88%E7%9A%84%E8%A9%B3%E7%B4%B0%20(jmp.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
UpliftElk866
Level I

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 I

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