Calculate Quartiles In Excel

Steps to calculate quartiles in Excel

• Step 1: Select a cell and type the formula =QUARTILE.INC( to begin.
• Step 2: Choose the range of data you want to calculate the quartile for.
• Step 3: Type a comma , and choose a number from 0 to 4 to specify the quartile:
  • 0 = Minimum
  • 1 = First quartile (Q1)
  • 2 = Median (Q2)
  • 3 = Third quartile (Q3)
  • 4 = Maximum
• Step 4: Close the parentheses and press Enter.
  (Example: =QUARTILE.INC(A1:A10, 1))

Result: Excel will return the quartile value based on your selected range and quartile type.

Tip: You can also use QUARTILE.EXC for exclusive quartile calculation, which excludes the minimum and maximum in Q1–Q3.