This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 59,369 times.
Learn more...
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 How.com.vn will teach you how to calculate quartiles in Excel using a formula.
Quick Steps
- Select a cell where you want to display your quartile information.
- In the formula box enter =QUARTILE.INC( or =QUARTILE.EXC(.
- Enter the range of cells you want to calculate, i.e. A1:A20.
- Add , n) where n is 1, 2, 3, or 4, the numbers correlating to quartiles.
- Press Enter to run the formula.
Steps
- Open your project in Excel. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.
- 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.
- Select an empty cell where you want to display your quartile information. 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 - Enter the quartile function: =QUARTILE.INC(. INC stands for "Inclusive," which will give you results that include 0+100.
- Select the cells containing your data. 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.
- Enter ",1)" to finish the formula. 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.[1]
- Press ↵ Enter (Windows) or ⏎ Return (Mac). 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.[2]
- Open your project in Excel. If you're in Excel, you can go to File > Open or you can right-click the file in your file browser.
- 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.
- Select an empty cell where you want to display your quartile information. 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.
- Enter the quartile function: =QUARTILE.EXC(. .EXC displays exclusive results, not showing you the highest and lowest ranges.
- Select the cells containing your data. 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.
- Enter ",1)" to finish the formula. 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.[3]
- Press ↵ Enter (Windows) or ⏎ Return (Mac). 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]
Expert Q&A
Tips
References
About This Article
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).
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.