M
MarkHughes
I have attached a form for calculating Cp and Cpk, however it appears that my calculation for Cpk is actaully calculating Ppk. Can someone help my formula?
Re: HELP - Is my calculation correct?
If the values are consectutive, you can use the moving range to caluclate short term variability (s=movRbar/1.128). For your data the difference is very small.
If the values are consectutive, you can use the moving range to caluclate short term variability (s=movRbar/1.128). For your data the difference is very small.
Re: HELP - Is my calculation correct?
just to confirm Steven's response: we are assuming that your subgroup size was 1?
were these sequential pieces? or were they spread out in time?
and most importantly: are the values listed in descending order in the order in which they were produced? if not you can only calculate Ppk...
just to confirm Steven's response: we are assuming that your subgroup size was 1?
were these sequential pieces? or were they spread out in time?
and most importantly: are the values listed in descending order in the order in which they were produced? if not you can only calculate Ppk...
M
MarkHughes
Re: HELP - Is my calculation correct?
Subgroup size is one. Yes they were sequential, numbered as they came out of the press.
What I'm really curious about is what is wrong with my calculation? The value I am getting in my sheet is what MiniTab gives me for Ppk. MiniTab is giving me a Cpk of 1.02
Is there something wrong with my calculation??
Subgroup size is one. Yes they were sequential, numbered as they came out of the press.
What I'm really curious about is what is wrong with my calculation? The value I am getting in my sheet is what MiniTab gives me for Ppk. MiniTab is giving me a Cpk of 1.02
Is there something wrong with my calculation??
Attachments
A
Atul Khandekar
Re: HELP - Is my calculation correct?
Your sheet is calculating Ppk - uses Excel function STDEV.
Use the formula given above by Steven, and you will get the Cpk of 1.02.
Your sheet is calculating Ppk - uses Excel function STDEV.
Use the formula given above by Steven, and you will get the Cpk of 1.02.
M
MarkHughes
Sorry, this may be a dumb question but, what does each part stand for in the equation? Or how do I calculate this in excel?
s=movRbar/1.128
s is..
mov is...
Rbar is ...
Thank you for everyone's help!!!
s=movRbar/1.128
s is..
mov is...
Rbar is ...
Thank you for everyone's help!!!
Here is a file with the calculations.
A
Atul Khandekar
s = Standard Deviation.
For Subgroup Size of 1,
movR = Moving Range = absolute difference between two consecutive readings.
movRBar = Average Moving Range: Average of all moving Ranges of all pairs of consecutive readings.
http://www.itl.nist.gov/div898/handbook/pmc/section3/pmc322.htm
For Subgroup Size of 1,
movR = Moving Range = absolute difference between two consecutive readings.
movRBar = Average Moving Range: Average of all moving Ranges of all pairs of consecutive readings.
http://www.itl.nist.gov/div898/handbook/pmc/section3/pmc322.htm
Similar threads
