How to use QUARTILE formula in Excel with Example Download

How to use QUARTILE formula in Excel with Example Download

If you want to find quartile (treymeas) of data sales or survey data set, like first or secord or even third quartitle in excel, QUARTILE formula come to place. This formula can use to find mininum and maximum value of data set too.

QUARTILE formula in Excel

QUARTILE returns quartile data set from data distribution.
FORMULA:

=QUARTILE(array,quart)

◾ array: Required, range of cell numbers you want to find.
◾ quart: required, value to return option.
- 0: Minimum Value
- 1: First Quartile
- 2: Second Quartile
- 3: Third Quartile
- 4: Maximum Value
Watch How to use Quartile formula in Excel speak Khmer

DOWNLOAD EXAMPLE EXCEL FILE, Source 1 or 2

Userful links:

How to Download and Install Khmer Unicode for Windows and Mac OSX (apple)
Free ebook Download - free PDF download