What is a scatter plot: How to read it and method to create it in excel

What is a scatter plot?

Scatter plots also known as scatter charts and scatter diagrams used to show relationships between two variables and the relationship between two variables is called their correlation. It’s a 2-D plot and it plots data points on a horizontal and a vertical axis to show how much one variable is affected by another. In the scatter plot, all data points are represented by dots in the plot.

If the points are close to making a straight line in the plot then it is considered as highly correlated variables. While if they are equally distributed all over the plot then their correlation is weak or zero.

When to use scatter diagram

When we have a … Continue Reading