# Trying to Create Hotelling T2 Charts in Excel?

## QI Macros can create them for you in seconds!

Use a Hotelling T2 chart when you want to evaluate two interacting measurements simultaneously.

#### To draw a Hotelling T2 Chart using QI Macros:

2. Click on QI Macros menu > Control Charts (SPC) > Special> Hotelling T2.
3. QI Macros will do the math and draw the chart for you.

### What is a Hotelling Chart?

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.

### Hotelling Chart Template in QI Macros for Excel:

Find the Hotelling Chart template by clicking on the QI Macros menu > Control Chart Templates > Special > Hotelling Chart. Input your data into the yellow shaded cells and the charts are automatically drawn for you.