Scatter plots are often one of the first steps in data exploration or data analysis A negative relationship - as one variable increases the other decreases A positive relationship - as one variable increases so does the other Ģ. There three basic linear relationships that can exist between two variables:ġ. The scatter plot or scatter diagram is a data science workhorse of data analytics and can be used to determine whether or not a relationship exists between two variables, and how strong that relationship is. The Excel spreadsheet used to create this video can be downloaded from: You will see three typical scatter plot presentations in this video. Scatter Plots are a data visualization tool used to quickly determine if a relationship exists between two variables.
#HOW TO MAKE SCATTER CHART IN EXCEL HOW TO#
This tutorial demonstrates how to make a scatter plot in Excel.