In this video, we will learn how to draw scatterplot and billycart.
Scatterplot are also known as equation's, and these are also a very common type of chart.
A scatterplot differs from most of the other types in that both sexes display values in a scatterplot
that is the horizontal axis is not a category axis in a scatterplot.
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 2008, the company sent out nine hundred four marketing e-mails and the amount
of sales it did was eighty nine.
So the question that I want to answer is, is did any relationship between marketing emails and sales
to find that relationship?
I can blog or scatterplot 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 Y.
So nine hundred for eighty nine.
When you plot each individual point like this, this whole plot is called a scatterplot, and if you
look at the scatterplot, probably you can imagine that most of the points are telling you that there
is a linear relationship between the x axis of evil and the y axis of evil.
That is, if you increase the marketing emails, among the sales is correspondingly increasing.
So such relationships can be identified using scatterplot.
Let us learn how to create the scatterplot elderly discharged.
Since Scatterplot has to be rebuilt, we will select these two variables that we want to plot.
And we will go to recommend a charter option and we will select this scatterplot.
Here I have the scatterplot, it is looking a little bit different than the previous one.
The reason is that in the previous scatterplot I was showing you the Y axis, which was starting from
a value of 75.
Here it is, starting from U.
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 different values
such as 75, how to change the value.
You select that y axis labels to the formatting axis option and you change the bond from zero to 75.
The I want to show that there is some linear relationship.
I have changed the lower amount of my Y-axis 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 scatterplot that will again go to dangerous type?
And here you can see that we have created the first one, which is a simple scatterplot, the second
one is a scatterplot with smooth lines.
The scatterplot with smooth lines can be used to show how the values are changing in the cities, so
it will connect all the points in this series from the starting first point to the next point, then
to the next point using smoothed lines.
That is, if you look at any two point, it is not joined by a straight line.
It is joined by a curved line so that it connects only points.
The third option is scatterplot with smooth lines, but no DaMarcus, as you can see, the earlier one
had these datapoint, these small circles highlighting the data point.
If you do not want these small circles, you can select the third option.
It will have a 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 scatterplot with lined.
So as I told you, the previous one had smooth lines, that it had curves.
Instead of straight lines, if you select this one, it has straight lines connecting the two points.
Next option is to get a lot of lines, but not the same as before.
But the small circles will not be present if you select this one.
One additional feature that comes with Scatterplot is trend line, as I told you, that scatterplot
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 a trend line.
Trend line is another element so you can add it by clicking this symbol.
If you simply click the link by default, it will draw linear trend line.
There are other options of trendlines.
Also, let us first draw linearly.
When I select this train line, this linear rail line itself draws the line such that it minimizes the
difference between each data point and the corresponding value and it 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 emails
from nearly 70 to 80, that is, there is 100 units increase Greece.
I sent additional hundred emails to the customers.
I will increase the sales by from 79 APR to 88 APR to.
By sending out hundred additional emails, we will have an increased sale of nine to 10 units to the
slope of this line is telling you the change in the y axis with the changing x axis.
The other types of criminals and also you're going to change from linear to logarithmic.
Polynomial, although we do not see any much difference in this dataset, 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 old.
So let's that if you know the number of e-mails you are going to think you can find out the corresponding
sales value basis this friendly.
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 is equal
to X plus B and what is the value of A and B?
You can do that by taking this option.
This will give you the description of this line.
Here's the equation, bicycle two 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 when you have when you are sending
out 1000 e-mails, you can just put the value of excess 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.
So this is all this equation can be used, basically the point of using a scatterplot is to find out
the relationship between two variables.
If you identify a relationship visually, you can also plot a trend line using this adding element.
But then once you plot a 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 into that analytics and you understand the terms of R-squared and and intercept, you can
add those options also.
So the R-squared value for this line is point footed.
So the scatterplot these last two options are remaining, this is a bold plot and this is a predictable
plot, then you want to identify a relationship between two variables only we use these two dimensional
scatterplot.
But if you have a third dimension also, that is there is a third variable also and you want to see
the relationship between first, second and the third variable, you can use these to the entry level
plot.
Let me show you how.
In this dataset, I have three data cities, I had eight participants in my weight loss program.
These are the original weight of these eight participants.
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 determining this third variable.
So what I'm going to do is I use a wheelchair, which will have on the x axis the original weight of
each individual participant on the Y axis, it will have the number of weeks department 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 circled with larger areas 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 300, 20 probably
achieved the maximum weight loss and at least you should be in the program for two or three weeks.
So this square 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 cities and you want to find the effect of two of the data is
on the third data cities up bubble chart is used.
So now let us learn how to draw a bubble chart and delete this one.
We will select these three cities and go to the bubble chart 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 it exists in this y axis.
And the third idea it is.
So I have to go to selected option and I will change.
So the X value series is the original with.
Sidis.
The way that you see this is weeks and program and the bubble radius will be this one.
OK.
And it will automatically decide what should be the horizontal axis label.
You can click on Okay and this is the bubble chart that we wanted to create.
The second option in global chart is a bubble chart.
As you can see, this is a truly bubble chart.
Here you have circles.
If you created in 3D, these will become spheres.
So each circle is now looking like a small ball.
So just like Scatterplot, you can use bubble chart to identify trends and create, to invent.
Once you have created the trend line, you can.
Formatted online in line also, you can change its color, weight, etc..
So Scatterplot and Belgard are basically used to identify a relationship between two or three variables.
And this is how we create them.