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.

Over the past decades, control charts, one of the essential tools in Statistical Process Control (SPC), have been widely implemented in manufacturing industries as an effective approach for Anomaly ...

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

Monitoring multivariate quality variables or data streams remains an important and challenging problem in statistical process control (SPC). Although the multivariate SPC has been extensively studied ...