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
- :
- Re: JMP-scripting: Control chart not created because avg > UCL

- 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
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 29, 2016 2:25 AM
(7007 views)

Hi Everyone,

I'm currently struggling with an issue. We run a script to pull charts for our customers. One of these charts is a control chart. I place the limits manually. Now I have a chart with an average, which exceeds the upper limit. JMP refuses to create the chart

*Error for Control Chart on data table Sorted tabulated results for 70705499: Control limits out of order: must be LCL<=Avg<=UCL*

Is there anything I can do, so that JMP generates the chart anyway?

JSL:

Control Chart( Sample Label(Column(1)), Group Size(1), Chart Col( Column(i), "Individual Measurement"), Get Limits("C:\Temp\limitsForCC.jmp")

);

i is a counter which loops over all columns.

I cannot change the chart type, as the chart needs to look exactly the same as before (so no different chart types, no chart builders, ...) I just need an option that will ignore the error and create the chart anyway.

Please keep in mind that I'm a developer, and not a statistision (meaning I know next to nothing about statistics, but I know about coding).

Thank you,

Kind regards,

Jan

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

As the error message says, the process mean must be between the lower control limit (LCL) and the upper control limit (UCL). The limits are either calculated from the same data that is plotted or they are previously calculated with an historical sample of data collected when the process was known to be in control and applied to a new set of data. The Shewhart charts center the process mean between the LCL and UCL, which are usually 3*sigma (sigma is short-term measure of process variation as a standard deviation.)

Your problem description suggests that the limits are already determined, so the LimitsForCC.jmp data table must be missing the value for the center line.

Generally speaking, these limits and center are associated with the process, not the data. The data are use to confirm or reject the process values.

Learn it once, use it forever!

1 REPLY 1

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

As the error message says, the process mean must be between the lower control limit (LCL) and the upper control limit (UCL). The limits are either calculated from the same data that is plotted or they are previously calculated with an historical sample of data collected when the process was known to be in control and applied to a new set of data. The Shewhart charts center the process mean between the LCL and UCL, which are usually 3*sigma (sigma is short-term measure of process variation as a standard deviation.)

Your problem description suggests that the limits are already determined, so the LimitsForCC.jmp data table must be missing the value for the center line.

Generally speaking, these limits and center are associated with the process, not the data. The data are use to confirm or reject the process values.

Learn it once, use it forever!