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
stats1
Level I

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

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

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",

  Add Rows( 25 ),

  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 ) );