turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Number of points outside specification limits

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Sep 11, 2012 11:09 AM
(946 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Sep 12, 2012 2:15 AM
(787 views)

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