cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Steve_Kim
Level III

Calculating Col Quantile by columns

Hi~

I'd like to calculate Col Quantile by Columns

on the data table

by using JMP formula as below.    (Note. Not from 'Tabulate' menu)

Do you have any idea with this?

Thanks in advance. : )

7939_Quantile by columns.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Calculating Col Quantile by columns

Brady,

Thanks for catching my typo! I meant for the character-valued case to be this:

//When By variable is character-valued:
Quantile( 0.25, (:height << get values)[loc((:sex << get values),:sex)] )

Best,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development

View solution in original post

4 REPLIES 4

Re: Calculating Col Quantile by columns

Unfortunately, the Col Quantile function does not support a By variable. However, you can use the following formulas to get around this limitation:

 

 

//Examples using $SAMPLE_DATA/Big Class.jmp:

//When By variable is character-valued:
Quantile( 0.25, (:height << get values)[loc((:sex << get values),"M")] )

//When By variable is numeric-valued:
Quantile( 0.25, (:height << get values)[loc((:age << get values) == :age)] )

 

 

Hopefully, one of these two will work for your situation!

 

Michael

Michael Crotty
Sr Statistical Writer
JMP Development

Re: Calculating Col Quantile by columns

Using Michael's approach, you can also do the following for the character-valued scenario, to avoid having to list each group value explicitly:

 

 

Quantile(
0.25,
  (:height << get values)[Loc( :age << get values, :age[Row()] )]
)

 

 

If you need to use more than one grouping variable (say, 3 columns together, for instance) you would first concatenate the columns together to form a fourth, and use this new column as a (single) grouping column.

 

Cheers,

Brady

Re: Calculating Col Quantile by columns

Brady,

Thanks for catching my typo! I meant for the character-valued case to be this:

//When By variable is character-valued:
Quantile( 0.25, (:height << get values)[loc((:sex << get values),:sex)] )

Best,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development
Steve_Kim
Level III

Re: Calculating Col Quantile by columns

WOW!!!!

It's marvelous solution!

and I learned 'get values' and 'location' formula from you.

Thank you so much  Michael and Brady!