cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hogi
Level XIII

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 XIII

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 XIII

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

 

Recommended Articles