Hotelling T2 Chart in Excel

Hotelling Chart Evaluates Two Interacting Measurements Simultaneously.

Similar to the XmR chart, the Hotelling T2 chart evaluates the covariances of the ranges between each of the two measures and the covariances of the actual data points. This gives two charts that are similar to the average and Range in the XmR.

Imagine for a moment that you are measuring the location of a hole drilled in a sheet of metal. It could be left or right, up or down. It's possible that both measurements, taken separately, could be stable and predictable, but the two together could have outliers.

To run a hotelling chart in QI Macros, select two columns of data and then select Hotelling chart on the QI Macros Control Chart menu. You will be prompted for a significance level. The most typical values for alpha are 0.05 and 0.01.

hotelling chart alpha value prompt

QI Macros output includes two charts.

T1 Chart

hotelling T1 chart in excel created with QI Macros

T2 Chart

hotelling T2 chart in excel created with QI Macros

To create a Hotelling T2 Chart using QI Macros...
Try It Now!