WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » QUARTILE Excel Function

QUARTILE Excel Function

QUARTILE Function in Excel

It is one of the statistical functions 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:

QUARTILE Formula

Parameters

As it is clear from the syntax shown above, it has two mandatory parameters, which are explained below:

Data: The first parameter is a data set, which will be required to find out the quartile.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

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 the Quartile parameter, the Quartile function returns the 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 the help of actual data.

Parameter

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.

You can download this QUARTILE-Function-in-Excel here – QUARTILE-Function-in-Excel

QUARTILE in Excel – Example #1

Let’s consider the data set and apply the Quartile function on it on the basis of quartile values 0,1,2,3, and 4.

Example 1

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.

Example #2

Example 2-1

Things to Remember

  1. It can be used as a worksheet function.
  2. It returns a numeric value.
  3. It was first introduced in Excel 2000 and is now available in all subsequent versions of excel.
  4. If the value of the Quartile parameter is greater than 4 or less than 0, the function returns a #NUM! Error.
  5. QUARTILE formula through #NUM! error if the given array is empty.
  6. 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 –

  • VBA Worksheet Function
  • Excel Mode Formula
  • Division Formula in Excel
  • INT in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download QUARTILE-Function-in-Excel

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More