Statistics How To

5 Number Summary in Excel: Easy Steps with Video

Main Index> Basic Statistics>

 
Watch the video or read the article below:

How to find a 5 number summary in Excel

A five number summary is a way to describe data. It is made up of five statistics:

  • The median (the middle).
  • The maximum value.
  • The minimum value.
  • Q1, the first quartile.
  • Q3, the third quartile.

The first quartile marks the line at the 25th percentile of data and the third quartile marks the link at the 75th percentile. The data that lies between these two points is called the interquartile range.
Excel doesn’t have a single command to calculate a five number summary, but you can find a 5 number summary in Excel by using basic functions to calculate the median, max, minimum, Q1 and Q3.

5 Number Summary in Excel: Steps

Sample question: Calculate the five number summary in Excel for the following data set: 10, 11, 14, 15, 16, 17, 18,, 32, 33, 31, 13, 12.

Step 1: Type your data into a single column in Excel. For this sample question, type the values into cells A1 through A12.

Step 2: Click an empty cell, then type “MAX(A1:A12)” (without parentheses). A1 is the first cell your data is in, A12 is the last. The two values are separated by a colon. Press “Enter” to find the max: 33.

Finding the MAX in a five number summary.

Finding the MAX in a five number summary.

Step 3: Repeat Step 2 for the minimum: “MIN(A1:A12)”.
five number summary 2

Step 4: Repeat Step 2 for the median: “MEDIAN(A1:A12)”.

Step 5: Repeat Step 2 for the first quartile: “QUARTILE(A1:12,1)”. The “1” after A1:a12 lets Excel know you want the first quartile.

Step 6: Repeat Step 2 for the third quartile: “QUARTILE(A1:12,3)”. The “3” after A1:a12 lets Excel know you want the third quartile.

5 number summary in Excel

Your five number summary is in B1:B5.

Related articles:
How to Find a Five Number Summary

Check out our YouTube channel for more stats help and tips!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>