354049_en-US

liliconcom

How to use Variables for Custom Quantiles

Dear Community,

 

I've been struggling for a while now, looking for a way of replacing the hardcoded values 0.95 and 0.99 below, with variables in an Application.

 

 Continuous Distribution(
  Column( Eval( colSelect ) ),
  Horizontal Layout( 0 ),
  Histogram( 0 ),
  Vertical( 0 ),
  Std Error Bars( 1 ),
  Count Axis( 1 ),
  Show Percents( 1 ),
  Show Counts( 1 ),
  Axes on Left( 1 ),
  Outlier Box Plot( 0 ),
  Set Bin Width( 1 ),
  Custom Quantiles( <FONT color="#339966"><STRONG>0.95, [0.95, 0.99]</STRONG></FONT> ),
<EM>//  Custom Quantiles( <FONT color="#FF0000">( Eval( Percent1 ) /100 ), [( Eval( Percent1 ) /100 ), ( Eval( Percent2 ) /100 )]</FONT> ),</EM>  Customize Summary Statistics(
   Std Err Mean( 0 ),
   Upper Mean Confidence Interval( 0 ),
   Lower Mean Confidence Interval( 0 ),
   Minimum( 1 ),
   Maximum( 1 )
  )
 ),

This Dialog script comes with a set of custom variables, including the column to be analyzed ("colSelect"), and two Percentile values, that are all well retrieved (Show(), earlier in same script):

 

dt = DataTable("Dep0Times_Overall_IST5000");<BR />colSelect = "Total Time From Entrance Queue To First Pre-Sortation";<BR />Percent1 = 95;
Percent2 = 99;

Whether I try the red line above with or without the Eval() method, I get the same annoying error below:

Invalid matrix token.
Line 50 Column 49: ...val( Percent1 ) /100 ), [►( Eval( Percent1 ) /100 )...

Thanks!

ScriptingRe: How to use Variables for Custom Quantiles

The percent values are elements in a matrix, if you create the matrix before the Distribution, then it is a simple substitution to have it used.

Names Default To Here( 1 );
dt = open("$SAMPLE_DATA/big class.jmp");
colSelect = "height";
percent1 = .95;
percent2 = .99;

perMatrix = Matrix( percent1 ) || Matrix( percent2 );

distribution(
 Continuous Distribution(
  Column( Eval( colSelect ) ),
  Horizontal Layout( 0 ),
  Histogram( 0 ),
  Vertical( 0 ),
  Std Error Bars( 1 ),
  Count Axis( 1 ),
  Show Percents( 1 ),
  Show Counts( 1 ),
  Axes on Left( 1 ),
  Outlier Box Plot( 0 ),
  Set Bin Width( 1 ),
  Custom Quantiles( Percent1, perMatrix ), 
//  Custom Quantiles( ( Eval( Percent1 ) /100 ), [( Eval( Percent1 ) /100 ), ( Eval( Percent2 ) /100 )] ),  Customize Summary Statistics(
  Std Err Mean( 0 ),
  Upper Mean Confidence Interval( 0 ),
  Lower Mean Confidence Interval( 0 ),
  Minimum( 1 ),
  Maximum( 1 )
 )
);

Re: How to use Variables for Custom Quantiles

Jim & all,

This finally works (maybe not the most elegant syntax)

Percent1 = 95;<BR />Percent2 = 99;<BR />percentMatrix = <FONT color="#008000">Matrix( {{ Percent1 /100 }, { Percent2 /100 }} )</FONT>;<BR />percentMatrix = [<FONT color="#008000">0.95, 0.99</FONT>];<BR />...<BR /> Custom Quantiles( ( Percent1 /100 ), percentMatrix ),<BR />

instead of:

percentMatrix = <FONT color="#FF6600">Matrix( Percent1 /100 ) || Matrix( Percent2 /100 )</FONT>;<BR />percentMatrix = [<FONT color="#008000">0.95</FONT> <FONT color="#FF6600">0.99</FONT>]

Cheers!