RiskCpk

Description

RiskCpk(cellref or output name, Sim#, RiskSixSigma(LSL,USL, Target,LongTerm Shift,Number of Standard Deviations)) calculates the Cpk process capability Index for cellref or output name in Sim#.This function is similar to the RiskCp function, but it adjusts the Cp for a mean that isn’t necessarily halfway between LSL and USL. The formula for Cpk is either (USL-Mean) / (3 x sigma) or (Mean-LSL) / (3 x sigma), whichever is the smaller.

Examples

RiskCpk(A10) returns the Cpk index for output cell A10.  In this case, a RiskSixSigma property function is required in the RiskOutput function in cell A10, and it must list LSL and USL, the values required to calculate Cpk.

RiskCpk(A10, ,RiskSixSigma(100,120,110,1.5,6)) returns the Process Capability Index for the output cell A10, using LSL 100 and USL 120. The last three arguments, 110, 1.5, and 6, are ignored for this calculation.

Guidelines

None.