Community Member

Joined:

Sep 11, 2012

## Number of points outside specification limits

Hi Everyone

If I have a data set of, for example 200, and want to know how many values are outside of the specification limits, is there a way for JMP to calculate how many points are outside those limits for each of those 200 lots if I for example have anywhere from 6 to 12 values for each lot.

ex: spec limits: 2-5%

Lot A values: 2, 3, 6, 7, 4, 3 (2 outside limits)

Lot B etc...

Thanks

Stats1

Super User

Joined:

Jun 23, 2011

## Re: Number of points outside specification limits

It can be done with a column formula. I don't know how your data is arranged but if all values are in a single column you can combine the Col Sum() function with the desired condition as in the example below (3rd column).

New Table( "Example",

New Column( "Lot", Character,

Set Values(

{"A", "A", "A", "A", "A", "A",

"B", "B", "B", "B", "B", "B", "B", "B", "B", "B", "B", "B",

"C", "C", "C", "C", "C", "C", "C"})

),

New Column( "Values", Formula( Random Integer( 10 ) ) ),

New Column( "N_outside", Formula( Col Sum( :Values < 2 | :Values > 5, :Lot ) ) )

) << summary( Group( :Lot ), Mean( :N_outside ) );