Excel stops copying the formula when it reaches the last cell with adjacent data. Enter "=Average (C:C)-2.66*Average (A:A)" in cell D2 and copy the formula down the column to create the lower limit.

Control charts usually present a graphic display of process stability and/or instability with time, from which the you can determine mean and standard deviation.

When the process is in statistical control, a point may fall outside the control limits purely by chance, resulting in a false out-of-control signal. However, when the Shewhart chart correctly signals ...

Abstract: Artificial neural networks (ANN) had been used for the detection and classification of patterns in control charts. It has been shown that neural network can detect smaller shifts better than ...