How to Make and Interpret a Scatter Plot in Excel

Опубликовано: 11 Октябрь 2016
на канале: Matt Macarty
77,253
216

Please SUBSCRIBE:
https://www.youtube.com/subscription_...
scatter plot excel
http://alphabench.com/data/scatter-pl...

This tutorial demonstrates how to make a scatter plot in Excel. Scatter Plots are a data visualization tool used to quickly determine if a relationship exists between two variables. You will see three typical scatter plot presentations in this video.

The Excel spreadsheet used to create this video can be downloaded from:
https://alphabench.com/data/scatter-p...

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.

There three basic linear relationships that can exist between two variables:

1. A positive relationship - as one variable increases so does the other;
2. A negative relationship - as one variable increases the other decreases
3. No relationship at all.

Scatter plots are often one of the first steps in data exploration or data analysis


#scatterplot #excel #datascience