K
Kenwatch
I would like to know the opinion of the forum in the following case.
I am trying to calculate the UCL and LCL for a set of measurements.
I took one measurement per day, three months in a row.
For calculating the limits, I used the following procedure:
1. Calculate the Average
2. Calculate the Median Range
3. Calculate control limits using following formula:
UCL= Average + 3.14*Median Range
LCL= Average - 3.14*Median Range
I was told that this is the correct way to calculate the UCL and LCL. For your convenience, I attached the excel file with my calculation.
Please, let me know what is your opinion in this case. Is this the correct way or should I do it differently?
Thank you,
I am trying to calculate the UCL and LCL for a set of measurements.
I took one measurement per day, three months in a row.
For calculating the limits, I used the following procedure:
1. Calculate the Average
2. Calculate the Median Range
3. Calculate control limits using following formula:
UCL= Average + 3.14*Median Range
LCL= Average - 3.14*Median Range
I was told that this is the correct way to calculate the UCL and LCL. For your convenience, I attached the excel file with my calculation.
Please, let me know what is your opinion in this case. Is this the correct way or should I do it differently?
Thank you,