If you want to use the template I have posted here Since it is a rare statistics related post I will give props to the medical stats book I am using these days.

I describe the safety precautions I use but make no promises that they are adequate.

I try to show only products and retailers with whom I have a personal history (with the exception of targeted ads by google).

I especially recommend Rotometals, SierraTradingPost, Northern Brewer and Amazon.

But please email me if you have any trouble with products or retailers linked from this page.

A box and whisker plot shows the minimum value, first quartile, median, third quartile and maximum value of a data set.

The x in the box represents the mean (also 8 in this example).

The median divides the data set into a bottom half 2, 4, 5 and a top half 10, 12, 15.

The bottom line of the box represents the median of the bottom half or 1st quartile (4).

The top line of the box represents the median of the top half or 3rd quartile (12).

The whiskers (vertical lines) extend from the ends of the box to the minimum value (2) and maximum value (15).

Q 1 2. The 3rd quartile (Q 3 ) is the median of the second half.

A data point is considered an outlier if it exceeds a distance of 1.5 times the IQR below the 1st quartile (Q 1 - 1.5 IQR 2 - 1.5 13 -17.5) or 1.5 times the IQR above the 3rd quartile (Q 3 1.5 IQR 15 1.5 13 34.5).

As a result, the top whisker extends to the largest value (18) within this range.

This function interpolates between two values to calculate a quartile.

You can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot.

This makes sense, the median is the average of the middle two numbers.

Again, you can verify this number by using the QUARTILE.EXC function or looking at the box and whisker plot.

Box And Whisker Plot Excel For Mac