![]() To do this, I will have to calculate the 1st and the 3rd quartile, and then using it calculate the upper and the lower limit.īelow is the formula to calculate the first quartile in cell E2: =QUARTILE.INC($B$2:$B$15,1)Īnd here is the one to calculate the third quartile in cell E3: =QUARTILE.INC($B$2:$B$15,3) For example, if you have 12 data points, then the first quartile would be the bottom three data points, the second quartile would be the next three data points, and so on.īelow is the data set where I want to find the outliers. In statistics, a quartile is one-fourth of the data set. Now let’s talk about a more scientific solution that can help you identify whether there are any outliers or not. ![]() It’s not a scientific method but works well Finding Outliers Using the Quartile Functions Note: This method works with small datasets where you can manually scan the data. In our example, I can see that the first two values are way higher than the rest of the values (and the bottom two are way lower). Now you can manually scan the data and see if there are any outliers. The above steps would sort the call duration column with the highest values at the top.
0 Comments
Leave a Reply. |