used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart

S

salud007

Dear all, hello !

Book: AIAG SPC-3 Reference Manual
Section: CHAPTER II - Section B Defining "out of control" signals
Page: p77 or p87
Question:
1- as the Page show:
====
Shift in Target
σ(Xbar's) ARL
0 -------->59.8
0.5 ----->17.9
1.0 ------>8.7
3.0 ------>2.0
====
2- above ARL [59.8] calculated with rule1 (out-of-control signal) and rule2 (the runs test of 7-points in a row on one side of centerline).
3- So, could you tell me, where are the 59.8 from? what excel formula can get the result (calculated with Rule1 & 2 )?
4- if I need calculated ARL's with Rule1 & Rule2 & Rule4 together, the excel formula ???
5- the ARL with Rule1, excel formula like = 1/(1-p1) = 1/(1-.0.9973) = 1/ 0.0027 = 370.3704, but i don't know how to calculated with Rule1&2.
Thanks a lot !
 
Last edited by a moderator:
Top Bottom