QUARTILE Function in Excel: Focus on Operating Profit

 QUARTILE Function is very simple to use. Let us now see how to use the TILE function in Excel with the help of this example.

Let us focus on Operating Profit.

Here, we will calculate the minimum value, First Quartile, Second Quartile, Third Quartile, and Maximum value by using the QUARTILE Function. We will take the value of the second argument QUART from 0-4 of the QUARTILE function like the below screenshot for this calculation.

Now we will apply the QUARTILE function to the OPERATING PROFIT data.

We will calculate the QUARTILE function for all values one by one by selecting the values from a drop-down list.

Similarly, we will find other values. The final result is shown below:

QUARTILE Function divides the dataset into 4 equal parts.

1st quartile value is 2308, 2nd quartile value is 5055, and 3rd quartile value is 6242.