Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- percentile formula

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Feb 16, 2011 1:16 PM
(7636 views)

Dear community,

Please state the percetnile formula being used in JMP tabulate function. I know this is not the same as the formula in excel because they are giving me different result.

I need it badly to justify the JMP application in our system.

Thanks

Please state the percetnile formula being used in JMP tabulate function. I know this is not the same as the formula in excel because they are giving me different result.

I need it badly to justify the JMP application in our system.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Hi statganda,

The formula is a little hard to put in the forum since it's best represented with subscripts and other formatting.

You can find it on pages 77 and 78 of this PDF:

http://www.jmp.com/support/downloads/pdf/jmp9/basic_analysis_and_graphing.pdf

Jeff

The formula is a little hard to put in the forum since it's best represented with subscripts and other formatting.

You can find it on pages 77 and 78 of this PDF:

http://www.jmp.com/support/downloads/pdf/jmp9/basic_analysis_and_graphing.pdf

Jeff

-Jeff

3 REPLIES 3

Highlighted
Hi statganda,

The formula is a little hard to put in the forum since it's best represented with subscripts and other formatting.

You can find it on pages 77 and 78 of this PDF:

http://www.jmp.com/support/downloads/pdf/jmp9/basic_analysis_and_graphing.pdf

Jeff

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

The formula is a little hard to put in the forum since it's best represented with subscripts and other formatting.

You can find it on pages 77 and 78 of this PDF:

http://www.jmp.com/support/downloads/pdf/jmp9/basic_analysis_and_graphing.pdf

Jeff

-Jeff

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: percentile formula

Hi Jeff,

This is very useful, because of this i was able to explain to other people logical the JMP formula is.

Thanks

This is very useful, because of this i was able to explain to other people logical the JMP formula is.

Thanks

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: percentile formula

JMP quantiles seem to give the same results as the Excel percentile.exc function (found in newer Excel versions). Functions percentile.inc and the (depreciated) percentile can yield different results from JMP.

If you use tabulate you may need to "set format" to display all decimal numbers of the interpolated result.

If you use tabulate you may need to "set format" to display all decimal numbers of the interpolated result.