topic Re: Formula for Cp, Cpk in QlikView

Formula for Cp, Cpk

Wed, 08 Jan 2014 15:54:15 GMT

Hi all,

Can anyone let me know the formula for Cp, Cpk ? And how they can be written in qlikview expressions.

Greatly appreciated for your solutions.

Thanks in advane.

Regards,

Venkat

Re: Formula for Cp, Cpk

mjm — Wed, 08 Jan 2014 16:00:59 GMT

Hello Venkat,

from looking at Google, I found the following site:

Cp Cpk Template for Excel | Calculate Cp Cpk in Excel with this Fill in the Blank Template

This mentions how to calulate CP and CPK. If you have the existing data which can be loaded into QlikView, then you would build the calculation in the same way as you see in the example mentioned in this site.

I hope this helps. Please mark as helpful if so.

Re: Formula for Cp, Cpk

Wed, 08 Jan 2014 16:40:17 GMT

Hi Mark,

Thanks for response.

From the given link please can you let me know how we will get the calculation value for Rbar/d2 ?

Cp = (USL-LSL)/6*Rbar/d2

Thanks in advance.

Regards,

Venkat