Scatter Plot Matrix in Excel
A scatter plot matrix is 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).
When you're investigating cause-effect links between two or more indicators then you can use the scatter plot matrix to 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.
- Watch video showing how to create a Scatter Plot in Excel using the QI Macros
- Scatter Plot Diagram
- Scatter Plot Examples