Need to Draw a Matrix Plot but Don't Know How?

QI Macros can create a matrix plot for you right in Excel!

Use a matrix plot or scatter plot matrix to evaluate the cause-effect when you have two or more variables.

Matrix Plot Example

The matrix plot is really just a series of mini scatter diagrams. In this example we want to evaluate the cause-effect relationship between several factors (foam, scent, color, and residue) on the perceived quality of shampoo.

example of matrix plot data

To create a scatter plot matrix in Excel using QI Macros just select your data, and then Matrix Plot from QI Macros menu:

matrix plot in excel

Example of Matrix Plot drawn by QI Macros in Excel

matrix plot in excel

Column E represents the cause-effect relationship between each individual factor and its effect (or not) on the perceived quality. In this, example there is no correlation between any of the factors and the perceived quality.

Summary

When you're investigating cause-effect links between two or more indicators, the scatter plot matrix can quickly identify correlations. 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. If you aren't sure, run a scatter diagram for the two variables and look at the R2 value. If R 2 is greater than .80, there is a strong correlation.

Learn More...