QUARTILE.EXC Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. If you want to get the quartile values for the given data set, you can use QUARTILE.EXC function.
In this tutorial, we will guide you to know how to use Excel QUARTILE.EXC Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:
https://www.microsoft.com/en-in/microsoft-365/excel
Description of QUARTILE.EXC Function
- It is one of the built-in functions in Microsoft Excel.
- This function returns the quartile of a given set of data.
- QUARTILE.EXC function can only return the first, second, and third quartile.
Syntax
- Here, you will see the syntax of the QUARTILE.EXC function.
- To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just click on the Enter button to get the result.
=QUARTILE.EXC(array, quart)
Arguments Explanation:
- Array – It is the input array or cell range with numeric values for which you need to find the quartile value.
- Quart – This is the quartile value to return.
The quart argument determines which quartile value to return and it accepts only three values, which are listed in the below table.
Note:
1) If the array is empty and then this function returns #NUM! Error.
2) If the quart argument is less than or equal to 0 or greater than or equal to 4, then it returns #NUM! Error.
3) If the quart argument is non-numeric values such as letters and symbols and then this function returns #VALUE! Error.
Examples
Here, we come up with some examples to make you understand how this function works.
- Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
- In the below screenshot, you can be able to see the input range in Column B, and its quart values are given in Column D.
- We will get the quartile for a given set of data using the QUARTILE.EXC function.
- Then, we have to apply the above-mentioned formula in Cell F3, as shown in the following screenshot.
- Finally, we need to click on the Enter button to get the result. Then, you will need to drag down the first cell to fill the remaining range of cells.
- If the quart argument is less than or equal to 0 or greater than or equal to 4, it returns #NUM Error.
- If the quart argument is non-numeric values such as letters and symbols and then this function returns #VALUE! Error.
From the above examples, you can understand how to use QUARTILE.EXC Function in Excel.
Verdict
In this tutorial, we guided you to learn the usage of Excel QUARTILE.EXC Function with its syntax, explanation, and examples. Drop your feedback in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.
Video Tutorial
The following video will show you how to apply Excel QUARTILE.EXC function in the worksheet.
Read Ahead:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Hi there, I’m Sridhar – an Excel enthusiast with over 10 years of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their operations and save time and money.
Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.
