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
- :
- 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
(875 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.

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
(594 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
(594 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
(594 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
(594 views)