how to find the five number summary

A5 number summaryis a way to summarize a dataset using the following v values:

The minimum
The outset quartile
The median
The tertiary quartile
The maximum

The five number summary is useful because it provides a concise summary of the distribution of the data in the following ways:

Information technology tells u.s. where the eye value is located, using the median.
It tells us how spread out the data is, using the first and 3rd quartiles.
It tells united states the range of the data, using the minimum and the maximum.

By but knowing these five values, nosotros tin can know a bang-up deal about a dataset.

How to Find the V Number Summary in Excel

We can find the 5 number summary of a dataset in Excel using the following steps:

Footstep 1: Enter the data values in one column.

How to calculate five number summary in Excel

Step 2: Observe the five number summary.

The five values of the v number summary are shown in cavalcade D and the formulas used to find these values are shown in column E:

Five number summary in Excel calculations

Thus, the five number summary for this data is as follows:

Minimum:4

1st Quartile:vii.5

Median:17

tertiary Quartile:22

Max:28

Technical Note:

There are technically ii quartile functions in Excel:

QUARTILE.INC()– Calculates percentiles using "greater than or equal to" in an "inclusive" style.

QUARTILE.EXC()– Calculates percentiles using "greater than" in an "exclusive" fashion.

The default functionQUARTILE()uses theQUARTILE.INC()method.

Visualizing a Five Number Summary Using a Boxplot

One of the easiest means to visualize a five number summary is past creating a boxplot, sometimes called a box-and-whisker plot, which uses a box with a line in the middle along with "whiskers" that extend on each end.

Boxplot explanation

You lot can perform the post-obit steps to create a boxplot in Excel:

Pace 1: Highlight the data values.

Boxplot for five number summary in Excel

Stride 2: In theInserttab in the Chartsgroup along the top ribbon, click the tiny arrow in the lesser left corner to "Run into All Charts."

Charts in Excel

Step three: Select "Box & Whisker" and click OK.

Boxplot in Excel

A box and whisker plot will automatically be displayed.

Boxplot in Excel

The meridian whisker represents the max, the meridian of the box represents the 3rd quartile, the middle line in the box represents the median, the tiny "x" in the box represents the average, the lesser of the box represents the 1st quartile, and the lesser whisker represents the minimum value:

Five number summary boxplot in Excel