Excel Functions Tutorials
- Statistical Function in Excel
- AVERAGE Excel Function
- Average Formula in Excel
- AverageIF in Excel
- AVERAGEIFS Function in Excel
- CORREL Excel Function
- Correlation Matrix in Excel
- Correlation vs Covariance
- COUNT Excel Function
- Count Formula in Excel
- COUNTA Excel Function
- COUNTIF Excel Function
- COUNTIF Formula in Excel
- COUNTIFS Function in Excel
- COUNTIF with Multiple Criteria
- COUNTIF Examples
- FORECAST Excel Function
- Forecast Formula in Excel
- FREQUENCY Excel Function
- Frequency Formula in Excel
- GROWTH Excel Function
- Growth Formula in Excel
- LARGE Excel Function
- LINEST Excel Function
- Linear Regression in Excel
- Lognormal Distribution in Excel
- MAX Excel Function
- Max Excel Formula
- Mean vs Median
- MEDIAN Excel Function
- MEDIAN Formula in Excel
- MIN in Excel
- MODE Excel Function
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- PERCENTILE Excel Function
- Percentile Formula in Excel
- Percentile Rank Formula
- Poisson Distribution in Excel
- P-Value in Excel
- QUARTILE Excel Function
- RANK Function in Excel
- SLOPE Function in Excel
- SMALL Function in Excel
- Standard Deviation in Excel
- Standard Deviation Formula in Excel
- TREND Function in Excel
- T-TEST in Excel
- Chi Square Test in Excel
- Variance vs Standard Deviation
- Weibull Distribution in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
- Power Bi (35+)
QUARTILE in Excel (Table of Contents)
QUARTILE Function in Excel
It is one of the statistical function of Excel. The functions are used to find the various quartiles of a data set. A quartile is just a quantile. There are 3 quartiles, the first quartile (Q1) is the middle number between the smallest value and the median value of a data set. The second quartile (Q2) is the median of the data. The third quartile (Q3) is the middle value between the median of the data set and the highest value. Along with quartiles, It can also return the minimum and the maximum value of the data set. The first quartile Q1 divides the lowes
Formula
The syntax of the QUARTILE formula is as follows:
Parameters
As it is clear from the syntax shown above it has two mandatory parameters which are explained as below:
Data: The first parameter is a data set, which will be required to find out the quartile.
Quartile: The second parameter defines the type of quartile to be returned by the QUARTILE in excel. QUARTILE parameter can have any value from 0 to 4. Depending on the value of Quartile parameter, the Quartile function returns respective quartile.
Examples
In this section, we will understand the uses of the QUARTILE function in excel and will look at a few examples with help of actual data.
How to Use the QUARTILE Function in Excel?
This Function is very easy to use, and as explained in the previous section, QUARTILE fuses two mandatory parameters.
QUARTILE in Excel – Example #1
Let’s consider the data set and apply the Quartile function on it on the basis of quartile value 0,1,2,3 and 4.
QUARTILE in Excel – Example #2
Let’s take a larger data set this time and we will try to find Q1, Q2, Q3, Minimum, and Maximum values.
Things to Remember
- It can be used as a worksheet function.
- It returns a numeric value.
- It was first introduced in Excel 2000, and is now available in all subsequent versions of excel.
- If the value of Quartile parameter is greater than 4 or less than 0 the function returns a #NUM! Error.
- QUARTILE formula through #NUM! error if the given array is empty.
- QUARTILE function #VALUE! Error if the given value of quart is non-numeric.
QUARTILE Excel Function Video
Recommended Articles
This has been a guide to QUARTILE Function in Excel. Here we will learn how to use QUARTILE in excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –
- Quartile Deviation Formula
- VBA IsEmpty Function
- How to Use Worksheet Function in Excel VBA?
- Excel Mode Formula
- VBA FIND in Excel
- Division Formula in Excel
- FIND Function in Excel
- INT in Excel
- MODE Excel Function
- TREND in Excel
- FREQUENCY in Excel
- SMALL in Excel
