In this video you learn how to drop scatter plot and believe dogs scatter plots are also known as X
Y charts and these are also a very common type of chart a scatter plot differs from most of the other
chart types in that both axes display values in a scatter plot.
That is the horizontal axis is not a category axis.
In a scatter plot it is also having values
this type of chart is often used to show the relationship between two variables in this example.
I have taken the monthly marketing emails that the company sent me and the corresponding sales it is
obtaining.
So in the month of January 2080 the company sent out 900 marketing e-mails and the amount of sales that
it did was eighty nine.
So the question that I want to answered is is did any relationship between marketing emails and sales
to find the relationship.
I can block a scatter plot of these two variables.
So on the x axis I can take marketing e-mail and on the y axis I can take the sales value and each point
will be X common.
So 904 comma 89 when you plot each individual point like this.
This whole plot is called a scatter plot and if you look at the scattered plot probably you can imagine
that most of the points are telling you not there is a linear relationship between the x axis variable
and the y axis variable.
That is if you increase the marketing emails among the sales is correspondingly increasing.
So such relationships can be identified using scatter plot
let us learn how to create this get a plot.
I will delete this chart
since scatter plot has two variables.
We will select these two variables that we want to plot
and we will go to recommended targets option and we will to like this scatter plot.
Here I have the scattered plot.
It is looking a little bit different than the previous one.
The reason is that in the previous scatter plot I was showing you the y axis which was starting from
a value of 75.
Here it is starting from the new if your aim is to show the absolute values.
It is better to start from zero.
If your aim is to show the relationship between two variables you can start with a different value such
as 75.
How to change the value you select that y axis labels 2D formatting axis option and you change the bond
from 0 to 75.
Since I want to show that there is some linear relationship I have changed the lower amount of my access
to 75.
Now it is like zooming in into that portion of the chart where most of my points are like
now what are the different types of scatter plots.
We will again go to Jean duct type.
And here you can see that we have created the first one which is a simple scatter plot.
The second one is a scatter plot with smooth lines these scatter plot with smooth lines can be used
to show how the values are changing in the series.
So it will connect all the points in this series from the starting first point to the next one then
to the next line using smooth lanes.
That is if you look at any two points it is not joined by a straight line.
It is joined by a curved line so that it connects all the points
the third option is scattered plot with smooth lines but no data markers.
As you can see the earlier one had these data points.
These small circles highlighting the data point.
If you do not want these small circles you can select the third option.
It will have smooth line but it will have no marker.
The point of this is if you want to emphasize on relationship only
the fourth option is scatter plot red lines
so as I told you the previous one had smooth lines.
That is it had curves instead of straight lines.
If you select this one it has straight lines connecting the two points
next option is scattered plot with lines but no data markers.
Same as before but these small circles will not be present.
It was like this one
one additional feature that comes with scatter plot is trend line as it all you know scatter plot is
used to identify a relationship between two variables.
One method is to visually check out what trend is there between the two variables.
The other option is to draw trend line trend line is another chart element so you can add it by clicking
this plus symbol
if you see completely in line by default it will draw linear trend line.
The other options of trend lines also let us first draw a linear trend line
when I select this trend line this linear red line Excel draws the line such that it minimizes the difference
between each data point and the corresponding value added only
overall.
This trend line is suggesting that there is a positive relationship between sales and marketing.
Image you can also see in this trend line.
If I increase the x axis value that is the marketing e-mails from nearly 70 to 80.
That is there is a hundred units increase.
I send additional hundred emails to the customers.
I will increase the sales by from 79 approximately to eighty eight approximately two by sending out
hundred additional e-mails.
We will have an increased sales of 9 to 10 units to the slope of this line is telling you the change
in the y axis with the change in x axis.
The other types of trend lines also you can change from linear to logarithmic polynomial.
Although we do not see any much difference in this data set.
But in your dataset it is always better to draw all these types of train length first and then visually
identify which is fitting the data better and use that trend line.
So using this trend line you can also forecast this is such that if you know the number of emails you
are going to sing you can find out the corresponding C value basis.
This currently
and once you have plotted this linear trend line and you want to find out what is the equation of this
linear line that is considering this is y axis and this is x axis you want to find out why it is equal
to express B and what is the value of a and b you can do that by taking this option
this will give you the equation of this line is the equation y is equal to point zero eight nine times
x plus eight point eight.
So what this means is if you want to find out what will be your sales then you have when you are sending
out 1000 e-mails you can just put the value of x as 1000 it will come out to eighty nine point seven
plus eight point eight.
So your total sales will be eighty nine point seven plus eight point eight which will be nearly ninety
eight point three.
This is how this equation can be used.
Basically the point of using a scatter plot is to find out the relationship between two variables.
If you identify a relationship visually you can also plot a trend line using this job adding chart elements.
But then once you plot the trend line and you are happy with the trend line and you would like to use
the equation of that trend line you can find that equation by clicking on this line.
Selecting its formatting options and taking this box if you are in italics and you understand the terms
of our squared and an intercept you can add those options also.
So the r squared value for this line is point for it
so this is scatter plot these last two options are remaining.
This is a bubble plot and this is a 3D bubble plot.
Then you want to identify a relationship between two variables only.
We use these two dimensional scatter plot but if you have a third dimension also that is that is a third
variable also.
And you want to see the relationship between first second and third variable.
You can use these to the entry debugger plots.
Let me show you how
industry does it.
I have three Delta cities.
I had eight participant in my weight loss program.
These are the original weight of these eight participant this is the time spent by these participants
in our program and this is the amount of weight lost by each individual participant.
I want to find out the effect of these two variables in data mining.
This third variable so what I'm going to do is I'll use a bubble jar which will have on the x axis the
original rate of each individual participant on the y axis.
It will have the number of weeks the participant was in program and the radius of this bubble will be
this third variable.
The idea behind creating this chart is if in this bubble chart circles with larger radius are coming
in a particular area of this chart you can assign that maximum weight loss is being achieved by people
belonging to that particular category.
For example most of the weight loss has been achieved by people in this range.
So people belonging to the weight category of 200 to 320 probably
achieve the maximum weight loss and at least you should be in the program for two or three weeks.
So this squared area constitute most of the big circles and you can clearly identify the range in which
these circles are occurring.
So basically when you have three data series and you want to find the effect of two of the data it is
on the third day densities up but which are deduced.
So now let us learn how to draw a bubble.
Jack I believe this one we will select these three cities and go to the Bobby Jack by default in Excel.
The first series is taken as the radius of the bubbles and the other two cities are taken as the x axis
and y axis.
But instead what I want to do is I want to take the first variable as x axis.
Second is y axis and deterred a radius.
So I have to go to select that option and I will change
so the x value series is the original word series the y value series is weeks in program and the bubble
radius will be this one.
Okay
and it will automatically decide what should be the horizontal axis labels and then click on okay.
And this is the bubble chart that we wanted to create.
The second option in bubble chart is a treaty will be just as you can see.
This is a truly bubble chart where you have circles if you created in 3-D.
These will become spheres so each circle is now looking like a small ball
so just like scatter plot you can use bubble chart to identify a trend and create trend length
once you have created the trend line you can
automatically trend line also you can change its color weight etc.
So scatter plot and bubble chart.
I basically used to identify a relationship between two or three variables and this is how we create
them.