Scatter Plot Diagram in Excel

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

Scatter plot diagrams are used to evaluate the correlation or cause-effect relationship (if any) between two variables (e.g., speed and gas consumption in a vehicle).

When you think there's a cause-effect link between two indicators (e.g., calories consumed and weight gain) then you can use the scatter plot to prove or disprove it. If the points are tightly clustered along the trend line, then there's probably a strong correlation. If it looks more like a shotgun blast, there is no correlation.

Here is an example of a scatter plot diagram created using the QI Macros SPC Software.

If the R² correlation of determination (square of the correlation coefficient) from the scatter plot is greater than 0.8, then 80% of the variability in the data is accounted for by the equation. Most statistics books imply that this means that you have a strong correlation. R² close to 1.0 means a perfect fit.

• Scatter Plot Examples
• How to Make a Scatter Plot
• Scatter Plot Matrix
• Watch video showing how to create a Scatter Plot in Excel using the QI Macros

The Scatter Plot Diagram is just one of the tools included in the QI Macros for Excel SPC Software.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!