A
amna77
Hi there, i have cpk formula, somehow its not giving me the right value.
Standard CPK formula is Mean - Lower Tolerance Limit / 3 sigma.
can you please check my attachnment, and see whats wrong with my formula. Thanks
my formula in there is
CPK=min(((Nominal+lower Tolerance) - average ) / (3*((max(sample1:sample5)-min(sample1:sample5)/2.326)),(average-(nominal-lower tolerance))/(3*((max(sample1:sample5)-min(sample1:sample5))/2.326)))
please see attachment.
I don't know if i arrange this formula right, cause sometime it gives me differnt value then other software.
Thanks in advance
Standard CPK formula is Mean - Lower Tolerance Limit / 3 sigma.
can you please check my attachnment, and see whats wrong with my formula. Thanks
my formula in there is
CPK=min(((Nominal+lower Tolerance) - average ) / (3*((max(sample1:sample5)-min(sample1:sample5)/2.326)),(average-(nominal-lower tolerance))/(3*((max(sample1:sample5)-min(sample1:sample5))/2.326)))
please see attachment.
I don't know if i arrange this formula right, cause sometime it gives me differnt value then other software.
Thanks in advance