Computing the Quartiles in Excel

Fundamentals of Social Statistics by Adam J. McKee

To provide the interquartile range, you must compute the values that divide the data into fourths.  This can be done easily in Excel using the QUARTILE function.

Figure 15: Quartiles in Excel
Figure 15: Quartiles in Excel

The QUARTILE function has two arguments.  “Array” is the list of scores (GPA in our example) and “Quart” is the number corresponding to the quartile that you want to be returned, either 1, 2, 3, or 4.  Note that the function does not return an array, but a single quartile.  To get all four quartiles, you need to set up four functions.

[ Back | Contents | Next ]

Last Modified:  06/03/2021

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.