Analyzing Data With More Than One Variable

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

When you are analyzing data sets with more than one variable (i.e., multivariate analysis), consider using these tools in the QIMacros.

Hotelling T2 Chart

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, analyzed separately, could be stable and predictable, but the two together could have outliers. The Hotelling T2 chart helps evaluate two interacting measurements simultaneously.

Similar to the XmR, 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.

In phase 1, the T21 chart is used to establish control. The goal is to get a stable and predictable process so that you can monitor future production using the T22 chart in phase 2.

T21 Chart

T22 Chart

Matrix Plot (Many Scatter Diagrams)

Matrix Plots are used to evaluate the correlation or cause-effect relationship (if any) between two or more variables (e.g., color, residue and perceived quality in shampoo). Matrix Plot data looks like this:

To run this chart in the QI Macros, select the data and select Matrix Plot from the pull down menu. If the points are tightly clustered along a line like machine gun stitching, then there's probably a strong correlation. If it looks more like a shotgun blast, there is no correlation.

To purchase the QI Macros

If you already own the QI Macros, you can purchase an upgrade. You must purchase one upgrade for each license you own.

Dashboards and Scorecards

Try QI Macros
FREE
For 30-Days

Or Buy It Now!