How to Calculate Quartiles in Excel

PDF download Download Article
PDF download Download Article

A quartile is the name for a percentage of data in four parts, or quarters, which is especially helpful for marketing, sales, and teachers scoring tests. Do you have data entered into your Excel sheet and want to see the quartiles (like the top 25%)? This wikiHow will teach you how to calculate quartiles in Excel using a formula.

Quick Steps

  1. Select a cell where you want to display your quartile information.
  2. In the formula box enter =QUARTILE.INC( or =QUARTILE.EXC( .
  3. Enter the range of cells you want to calculate, i.e. A1:A20 .
  4. Add , n) where n is 1, 2, 3, or 4, the numbers correlating to quartiles.
  5. Press Enter to run the formula.
Method 1
Method 1 of 2:

Using "QUARTILE.INC"

PDF download Download Article
  1. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser. [1]
    • This method works for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019-2007, Excel 2019-2011 for Mac, and Excel Starter 2010.
  2. This can be anywhere on your spreadsheet.
    • For example, you can select cell E7 even if all your data is located in cells A2-A20.
    Advertisement
  3. =QUARTILE.INC( . INC stands for "Inclusive," which will give you results that include 0+100. [2]
  4. You can drag your cursor to select the entire range or you can select the first cell then press CTRL + SHIFT + Down arrow .
    • After you've selected the data set, you'll see it entered into your formula. It'll look something like "=QUARTILE.INC(A2:A20" . Don't add the closing parentheses because you'll need to add more information to the function.
  5. The number after the data range can represent either Q1, Q2, Q3, or Q4, so you can use any number 1-4 in the function instead of 1.
    • The function QUARTILE.INC(A2:A20,1) will show you the first quartile (or 25th percentile) of your data set. [3]
  6. The cell you have selected will display the quartile function result. You can repeat this process using the other quartile function to see the differences. [4]
    7. Advertisement
Method 2
Method 2 of 2:

Using "QUARTILE.EXC

PDF download Download Article
  1. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser. [5]
    • This method works for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019-2007, Excel 2019-2011 for Mac, and Excel Starter 2010.
  2. This can be anywhere on your spreadsheet.
    • For example, you can select cell E7 even if all your data is located in cells A2-A20.
  3. =QUARTILE.EXC(. .EXC displays exclusive results, not showing you the highest and lowest ranges. [6]
  4. You can drag your cursor to select the entire range or you can select the first cell then press CTRL + SHIFT + Down arrow .
    • After you've selected the data set, you'll see it entered into your formula. It'll look something like "=QUARTILE.EXC(A2:A20" . Don't add the closing parentheses because you'll need to add more information to the function.
  5. The number after the data range can represent either Q1, Q2, Q3, or Q4, so you can use any number 1-4 in the function instead of 1.
    • The function QUARTILE.EXC(A2:A20,1) will show you the position of the first quartile in your data set. [7]
  6. The cell you have selected will display the quartile function result. You can repeat this process using the other quartile function to see the differences. [8]
    7. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      Advertisement

      References

      1. ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
      2. ↑ https://support.microsoft.com/en-us/office/quartile-inc-function-1bbacc80-5075-42f1-aed6-47d735c4819d
      3. ↑ https://support.microsoft.com/en-us/office/quartile-inc-function-1bbacc80-5075-42f1-aed6-47d735c4819d
      4. ↑ https://youtu.be/UseEZnBYHEY?t=192
      5. ↑ https://edu.gcfglobal.org/en/excel2016/creating-and-opening-workbooks/1/
      6. ↑ https://support.microsoft.com/en-us/office/quartile-exc-function-5a355b7a-840b-4a01-b0f1-f538c2864cad
      7. ↑ https://support.microsoft.com/en-us/office/quartile-exc-function-5a355b7a-840b-4a01-b0f1-f538c2864cad
      8. ↑ https://youtu.be/UseEZnBYHEY?t=192

      About This Article

      Article Summary X

      1. Open your project in Excel.
      2. Select an empty cell where you want to display your quartile information.
      3. Enter "=QUARTILE.INC(" or "=QUARTILE.EXC(" .
      4. Select the cells containing your data.
      5. Enter ",1)" to finish the formula.
      6. Press Enter (Windows) or Return (Mac).

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 83,910 times.

      Is this article up to date?

      Advertisement