topic Re: How to get a column to return percentile in Discussions

How to get a column to return percentile

IslandDelverGo — Sat, 01 Feb 2025 16:15:41 GMT

Hi everyone,

I am working to get P50, P90 and P95 data into a data set based on an array of numbers .

I know that I can run a distribution and it will show the values but I am trying to do this for too many files to make it feasible.

Is there a formula or other way to get a column that returns with the values I am looking for based on a specific delimiter such as batch? I am currently using JMP 15.0 and any help would be appreciated.

Re: How to get a column to return percentile

jthi — Sat, 01 Feb 2025 16:19:40 GMT

Have you tried with Summary platform?

Optionally you can use Col Quantile() function in a formula and Summarize() function if scripting

Re: How to get a column to return percentile

IslandDelverGo — Sat, 01 Feb 2025 17:20:14 GMT

Frankly I was tunnel-visioned enough that I did not think of using the summary table. I also utilized the formula for col quantile to make all of them.

Thank you!

Re: How to get a column to return percentile

txnelson — Sat, 01 Feb 2025 17:35:34 GMT

The Quantile() function will give you what you want if you are looking to calculate your percentiles for an array of data.

names default to here(1);

A = [1.2, 1.5, 10, 25, 31, 40, 50, 99, 1000, 5000, 25000, 100000];

P50 = Quantile( .5, A );

This can also be used against a column of data in a data table if you reference the data table as a matrix of data

names default to here(1);

dt = open("$SAMPLE_DATA/Big Class.jmp");

P75 = Quantile( .75, dt[0,4]);