Find Quartiles In Excel Using Quartile Function - Dynamic Example Included

In this video, I cover how to use the QUARTILE function with a test result example. In the second half of the video, I cover how you can use the QUARTILE Function more dynamically.

A quartile divides the number of data points into four parts close to equal size. Quartiles can be described as a form of order statistic. The 3 quartiles of a data set are described below:

1st quartile (Q1)- Middle number that lies between the smallest number and the median. This quartile is known as the 25th empirical quartile, where 25% of the data is below this point.
2cd quartile (Q2)- This is the median of a data set. Also, 50% of the data is below this point.
3rd quartile (Q3)- is the value between the median and the highest number. It's known as the 75th empirical quartile and 75% of the data is below this point.

====== PROFILE ======

===== CHAPTERS =====
00:00 Start
01:28 Enter QUARTILE Function
03:55 Dynamic Example
04:22 Add Dropdown Men
04:58 IFS Function
07:20 Enter Quartile Function

======= TAGS =======
#msexcel #excel #exceltutorial #statistics #descriptivestatistics #exceltips #microsoftexcel #exceltricks #quartiles