Chat with our AI personalities
Boxplot
Excel does not have a native BOXPLOT function, but you can replicate the function by following the instructions in the related links.
Go into your data to determine which values are outliers and if they're significant and random (not an apparent group), eliminate them. This will take them out of your boxplot.
A box and whisker plot is used to show range, you must first find out the quartiles. The first quartile is the left edge of the box, the third quartile is the right edge of the box and the median is the line in the middle. The whiskers are the highest and lowest values in your data set. Sometimes if you have a value in your data that is a long way out then you may not use it as a whisker, this is an outlier.A boxplot is a way of depicting groups of numerical data. They have many lines extending vertically from the whiskers (boxes).
When John Tukey invented the boxplot he suggested (somewhat arbitrarily) that any data points more than 1.5 times the length of the box (ie, the distance between the upper and lower quartiles) from the nearest end of the box should be regarded as outliers.For example, suppose the box length were 2, that the lower quartile were 5 and that the smallest data point were 1.1.5 * 2 = 35 - 3 = 21 < 2; in other words, this data point is too far away from the box.Hence, the smallest data point is an outlier.