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.

Fuzzy control charts represent a significant evolution in Statistical Process Control (SPC) by addressing intrinsic uncertainties in measurement and human evaluation that classical approaches ...

In statistical process control, a state of statistical control is identified with a process generating independent and identically distributed random variables. It is often difficult in practice to ...

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 ...