How to Create a Scatter Diagram in Excel

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.

The QI Macros can create a scatter plot for you and calculate R² the correlation of determination. For more information see http://qimacros.com/qiwizard/scatter-plot.html

Download 30 day trial at http://www.qimacros.com/freetrial.html

This video shows you how to create a scatter diagram in Excel using the QI Macros

Category:

Science & Technology

Tags:

• scatter
• plot
• diagram
• excel
• software
• cause
• effect
• relationship
• correlation
• of
• determination
• coefficient