cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hogi
Level XI

Binning by Spec limits

If I have a column with spec limits defined as column properties, is there a "one-click" solution *) to bin the data into 3 groups:

x < LSL

LSL <= x <= USL

x > USL

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Binning by Spec limits

I was able to create a grouping based upon the binning of the Spec Limits

txnelson_0-1683873760096.png

Using the Levels option, and specifying Create Transform Column 

txnelson_1-1683873931671.png

I simply created the following formula to create the binning

txnelson_2-1683874023026.png

and it worked as desired.

In my example, I used the Semiconductor Capability sample data table, and the PNP3 column.  It has outliers, however, it has no outliers that are less than the LSL value, so I manually changed one row to have a low value, just to test the formula.

specs = :PNP3 << get property( "spec limits" );
If(
	:PNP3 < specs["LSL"], -1,
	specs["LSL"] <= :PNP3 <= specs["USL"], 0,
	1
);

 

 

Jim

View solution in original post

4 REPLIES 4
txnelson
Super User

Re: Binning by Spec limits

Here is an example of one way to handle this

Names Default To Here( 1 );

dt = // Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

dt << New Column( "bin",
	formula(
		As Constant( specs = :PNP3 << get property( "spec limits" ) );
		If( specs["LSL"] <= :PNP3 <= specs["USL"],
			1,
			0
		);
	)
);
Jim
hogi
Level XI

Re: Binning by Spec limits

Thanks @txnelson for the JSL example

The disadvantage: a new column is added.

 

If I do this for all column, it gets quite crowded.

 

I hope a similar functionality is directly implemented in Jmp - but couldn't find it.

neither here:

hogi_0-1683865383653.png

nor here:

hogi_1-1683865461977.png

 

Is it hidden behind a Shift/Alt/Ctrl Click?

txnelson
Super User

Re: Binning by Spec limits

I was able to create a grouping based upon the binning of the Spec Limits

txnelson_0-1683873760096.png

Using the Levels option, and specifying Create Transform Column 

txnelson_1-1683873931671.png

I simply created the following formula to create the binning

txnelson_2-1683874023026.png

and it worked as desired.

In my example, I used the Semiconductor Capability sample data table, and the PNP3 column.  It has outliers, however, it has no outliers that are less than the LSL value, so I manually changed one row to have a low value, just to test the formula.

specs = :PNP3 << get property( "spec limits" );
If(
	:PNP3 < specs["LSL"], -1,
	specs["LSL"] <= :PNP3 <= specs["USL"], 0,
	1
);

 

 

Jim
hogi
Level XI

Re: Binning by Spec limits

So, there is no single click solution?
I also checked the Custom Binning menu. 

Several options are listed, but none to use the spec limits:

hogi_0-1683875335808.png