Please SUBSCRIBE:
ru-vid.com_...
scatter plot excel
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:
www.alphabench.com/resources.html
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
10 окт 2016
