

The correlation between two datasets is positive If the data points’ pattern on the plot goes from lower left to upper right.The correlation between two variables is said to be strong if the data points are concentrated around a line on the plot.If the data points on a plot are spread widely on the plane, then it implies that the correlation between two variables is weak.If the data points on the plot look like they are randomly scattered, then it implies that there is no correlation between the two variables.We can interpret the scatter plots in the following manner: Scatter with straight lines and markers.In MS Excel, some layouts that are available for scatter plot are:

Scatter plots use the Cartesian axes or coordinates so as to display the two data sets’ values. Excel functions, formula, charts, formatting creating excel dashboard & others
