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
- :
- Discussions
- :
- Calculating Quantiles for a newbie

Topic Options

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

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

Apr 9, 2009 8:27 PM
(1797 views)

The data I have looks similar to this:

Order OE-IP(x) Order IP - SHP(y) Order SHP - POD(z) Total orders(T)

5 ----------------------------- 2 -------------------------- 3 ------------------- 110

3 ----------------------------- 1 -------------------------- 7------------------- 2000

0 ----------------------------- 5 -------------------------- 4 ------------------- 200

There are about 800k lines of data like this so I won't post that up.

How would I use JMP to get the percentiles they are looking for?

For the weighted average I did

[(x+y+z)*T]=C for each line

(Sum of column C / Sum of column T) = Weighted Average

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions

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

May 1, 2009 8:11 AM
(2119 views)

Solution

In JMP the quantiles are specified in the Tables/Summary/ panel. You select the variable for which you want the quantiles and modify the quantiles percentage which is set by default to 25 and then choose Quantiles from the Statistics puldown menu. Grouping can also be set in the obvious manner.

--

David

--

David

4 REPLIES

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

Apr 10, 2009 9:13 AM
(1516 views)

Here is how you calculate percentiles in SQL:

Suppose you have _Table_ that contains several groups with [Group_ID] of the values

------ 5th percentile --------

SELECT MAX (

FROM (SELECT top 5 percent

FROM _Table_

ORDER BY

GROUP BY [Group_ID]

-------- 95th percentile -------

SELECT MAX (

FROM (SELECT top 5 percent

FROM _Table_

ORDER BY

GROUP BY [Group_ID]

If you still want to use Jmp, then go to Analyze ->"Fit Y by X', choose

This can be easily found in Jmp help, btw...

Thanks,

MikeK.

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

Apr 10, 2009 9:17 AM
(1516 views)

-------- 95th percentile -------

SELECT MIN (

FROM (SELECT top 5 percent

FROM _Table_

ORDER BY

GROUP BY [Group_ID]

Sorry,

MikeK.

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

May 1, 2009 8:11 AM
(2120 views)

--

David

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

Aug 13, 2009 9:56 PM
(1516 views)