In this video, we will learn how to handle the outlying values in our dataset.
We have identified from univariate analysis that in hot rooms contained exceptionally large values.
These values are outliers and we have to treat them.
From the lecture, we have told you that when we have an outlier, we cap the values in the variable
to upper limit to find the upper limit, we find either a non outlaying value and find a multiplication
factor.
All we use the 99 percent daily value and use the multiplication factor to get the upper value.
We don't change the values of all the old values to this upper value.
To do the same thing in and courtrooms, we need to first identify those cells which contain the outline
values.
To identify the cells, we are going to apply a filter first to apply filters on the table, we select
the top row of our table, then we go to data.
And we click on this filter option.
You can see that these additional small boxes containing a small triangle are coming with each column.
These boxes are giving us the filtering and sorting option for this column here.
You can see that all the values of this column are listed in this small box.
So if we go to any rooms now and open this small box for.
You can see the values are starting from ten point zero five and it goes on and suddenly the values
increase from fifteen point four to eighty one point one two and then one hundred one point one two.
So we have to treat these two exceptionally large values.
And to get the valley of upper limit, we are going to use this largest normal value.
Which is fifteen point four, and we will use a multiplication factor of three.
So the value we are going to replace these outlying values is three and to fifteen point four, which
is forty six point two.
So to select these two cells will first and check all of them and go and check these last three cells.
You can see we have only those observations with us, which have these three types of values.
Now, to change the value in this particular cell, to train to fifteen point four, we will rate is
equal to three in do fifteen point four.
For this also, we will continue to train to fifteen point four.
So this method of treating outliers, that is we create an upper limit and change the outlying values
to that upper limit is very subjective.
You can choose any non Nordling value.
You can choose any multiplication factor to establish the value and change these outlying values according
to your business need.
So with these actions, we have treated the outlying values in our dataset.
Now we will take this select Altec box to get the whole table.
Now you can see that we do not have those two exceptionally large values.
We have this value.
If you think this is still too big, you can treat it further.
You can get a smaller value here.
For now, we are going to keep this value as the upper limit porras and courtroom's variable.