請教統計Ppk之用法&Excel如何計算? - Yahoo!奇摩知識+

n1~n5>>>查表n=5時,d2= 2.326 由上表計算 Rbar = (0.2+0.2+0.3+0.3+0.1)/5 =0.22 Xbar = AVERAGE (B2:B6)=2.12 PpK的 s =STDEV(D2:H6)= 0.0957 CpK的 s= Rbar/d2 =0.22/ 2.326 =0.0946 至於PpK或CpK計算公式均相同 =Min((USL-Xbar)/(3*s),(Xbar-LSL)/(3*s)

tw.knowledge.yahoo.com