I have been trying to recreate the JMP calculations in SQL and can duplicate all of the process controls with the exception of Cpm. I am using JMP 12 and the Cpm formula from the "Process Capability in JMP 12 - A New Look" article. The equation is also on the image of the Xbar chart. I have include a .jmp data file to recreate the chart to see if the calculated Cpm is what you expect. Any help would be appreciated. Here are the calculated values using SQL:
Cp | Cpk | Cpm | Cpl | Cpu | Sigma | Average |
6.945 | 4.855 | 6.944 | 9.036 | 4.855 | 0.04799 | 0.301 |
