topic Re: Statistic Summary Table of Multiple Parameters (Min, Max, Mean, Std, Count, Limit, Fail Count, Fail % & CPK) in Discussions

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

OneNorthJMP — Tue, 06 Aug 2019 01:38:04 GMT

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.

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

txnelson — Tue, 06 Aug 2019 02:01:56 GMT

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

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

OneNorthJMP — Tue, 06 Aug 2019 05:59:45 GMT

Hi Jim,

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

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

Harmon-HT — Mon, 30 Jan 2023 21:59:09 GMT

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

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

txnelson — Tue, 31 Jan 2023 00:07:04 GMT

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