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.