How to Create and Read Scatter Plots

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *

Already have an account? Sign In »

9 hours 53 minutes
Video Transcription
Hi, guys. Welcome back. I'm Katherine MacGyver, and this is lean six Sigma Green Belt, and we're going to pick up where we left off on regression analysis.
So what we're gonna do today is we're gonna have an introduction to scatter plots were gonna understand how to create them and understand how to read them.
The first step in regression analysis is creating a scatter plot. This will give you a two fold one. It will allow you to read the relationship between the data visually
and to You'll be able to then do your regression analysis,
which will formulaic Lee give you that relationship. So
a scatter plot
is an X Y graph. You have two measurements. You always have your X and your Y variables. And from that you will be able to create a single point on a Cartesian system. Remember that from middle school
that will give you a measurement of that data element.
as you read scatter plots, a upward slant to the right is a positive relationship. A downward slant to the right, so we're gonna read from left to right is a negative relationship.
We will notice from the okay, Cuba data.
Um, that you are more likely to receive messages if you are measured as more attractive. Eso there is our relationship. Your dependent variable is going to be your Why access in the OK, Cupid's case. It is the number of messages received
and your independent variable
is your X axis. And in case of OK, cupid is going to be measured. Attractiveness. So as you are measured as more attractive, you are going to receive more messages.
If this were a negative relationship as you are measured as more attractive, you will receive less messages.
Um, this is important for us to know both directions of the relationship because remember, our independent variables are the variables we can change. Our dependent variables are the ones that were looking to change or our process outputs.
So independent variable. How maney work orders dependent variable. How long does it take us to complete those work orders? So when we're creating a scatter plot in Excel, remember that
we like excel because almost everybody has it in excel. You're going to want to capture your two data sets as columns eso the the two data sets that we're looking at here is the year our presidents were born and the year they were elected.
So two columns that you're going to select both of them.
You're going to click insert graph and you're going to insert a scatter plot. It is going to give you a graph like we are looking at right now. And what I can tell you by looking at this is that there is a pretty good relationship from the year that the president was born and the year that they were elected, we could
determine that if you were,
you were probably not gonna be elected before you were born. So we see no negative relationships. And honestly, if we look at it, the data is pretty tightly clustered. Which tells us that there is pretty. There's a lot of consistency between those relationship, So this is a really nice scatter plot to review
because it's very clear we're looking at a positive
or a strongly positive result between our presidents, year of birth and the year they were elected.
today we did an overview of our scatter plots. You know that your dependent is your y variable. Your independent is your ex variable and two created an excel. It's Azizi is click, click, Click. So you're going to go ahead and capture your data, Create your scatter plot, and you're gonna take a visual sniff test and see.
Yeah, presidents are probably not going to be elected to office before they're born, So a positive relationship makes sense.
Our next module, we're gonna go into more in depth. We're gonna actually do our correlation analysis, so I will see you guys there.
Up Next