QUARTILE Excel Function | How to Use Excel QUARTILE Function?

In this video on QUARTILE Excel Function, here we discuss how to use QUARTILE in excel along with excel example.

𝐐𝐔𝐀𝐑𝐓𝐈𝐋𝐄 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧 𝐢𝐧 𝐄𝐱𝐜𝐞𝐥
--------------------------------------------------

It's one of Excel's statistical functions. The functions are used to find an data set's different quartiles.

𝐐𝐔𝐀𝐑𝐓𝐈𝐋𝐄 𝐄𝐱𝐜𝐞𝐥 𝐅𝐨𝐫𝐦𝐮𝐥𝐚
---------------------------------------------

=QUARTILE (array, quart)

𝐀𝐫𝐠𝐮𝐦𝐞𝐧𝐭𝐬
----------------------

array - A reference containing data to analyze.
quart - The quartile value to return

𝐓𝐡𝐢𝐧𝐠𝐬 𝐭𝐨 𝐑𝐞𝐦𝐞𝐦𝐛𝐞𝐫 𝐰𝐡𝐢𝐥𝐞 𝐮𝐬𝐢𝐧𝐠 𝐐𝐔𝐀𝐑𝐓𝐈𝐋𝐄 𝐄𝐱𝐜𝐞𝐥 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧
--------------------------------------------------------------------------------------------------------

#1 - It can be used as a worksheet function.
#2 - It was first launched in Excel 2000 and is now accessible in all of excel's subsequent versions.
#3 - If the parameter value of Quartile exceeds 4 or less than 0, the function returns a # NUM! Error.
#4 - QUARTILE function #VALUE! Error if the given value of quart is non-numeric.