How Do I Calculate A Five Number Summary In Google Sheets? (2024)

Afive number summaryis a way to summarize a dataset using the following five values:

• The minimum
• The first quartile
• The median
• The third 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:

• It tells us where themiddle valueis located, using the median.
• It tells us howspread outthe data is, using the first and third quartiles.
• It tells us the range of the data, using the minimum and the maximum.

By simply knowing these five values, we can know a great deal about a dataset.

How to Find a Five Number Summary in Google Sheets

We can use the following steps to find the five number summary of a dataset in Google Sheets:

Step 1: Enter all data values in one column.

First, enter the values of the dataset in one column:

Step 2: Calculate the five number summary.

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

Thus, the five number summary of this dataset is:

• Minimum: 4
• 1st Quartile: 7.5
• Median: 17
• 3rd Quartile: 22
• Maximum: 28

From these five numbers we can get a good idea of where the center of the dataset is located, how spread out the values are, and the range of values.

Technical Note:

There are two quartile functions in Google Sheets:

QUARTILE.INC()– Calculates percentiles using “greater than or equal to” in an “inclusive” manner.

QUARTILE.EXC()–Calculates percentiles using “greater than” in an “exclusive” manner.

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

Visualize a Five Number Summary

One of the easiest ways to visualize a five number summary is by creating aboxplot, which uses a box with a line in the middle along with “whiskers” that extend on each end to represent the minimum and maximum values.

Feel free to use the Statology Boxplot Generator to automatically create a boxplot for a given dataset.

You can also follow this tutorial to find out how to create a boxplot in Google Sheets for a given dataset.