Statistic Summary Table of Multiple Parameters (Min, Max, Mean, Std, Count, Limit, Fail Count, Fail % & CPK)

[#1]

I have a input table with hundreds of tests with embeded spec. I want to generate a quick summary statistic table of multiple parameters with all below info (Min, Max, mean, Std, Count, lower spec limit, upper spect limit, fail count, fail % & Cpk). 

I understand that i can use tabulate function to get the min, max , mean, std, count, pretty quickly. But i have no idea how to generate lower spec limit, upper spec limit, fail count, fail % & cpk in one table. 

Can any JMP expert can advise me? Thanks. Attached my jmp file for reference. 

[#2 · Accepted solution]

My suggestion is to use the Process Capability Platform to do this.

     Analyze==>Quality and Process==>Process Capability

I think it may get you close to what you want.. You may need to write a scrip to generate the fail counts and then join the results of that back into the table generated from the Process Capability

[#3]

Hi Jim,

Thanks for feedback. It is close enough to what i want to accomplish.

[#4]

How did you get your process capability to output into a table like this?

[#5]

Using the data table supplied above, I then selected

      Analyze==>Quality and Process==>Process Capability

Within the dialog box then displayed, Move all of the WAC columns to the Y Process selection area.  Then click OK.

The Spec Limits dialog box then opens.  Just click on OK and then Continue in the next displayed box.  After some processing an output display will be presented.  Under the red triangle, select 

     Summary Reports=>Within Sigma Summary Report