QUARTILE(array,quart) returns the quartile of a data set : QUARTILE « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =QUARTILE(B2:B9,1). Press Enter to get the result.
Input the formula: =QUARTILE(B2:B9,1)
21.61.QUARTILE
21.61.1.QUARTILE(array,quart) returns the quartile of a data setQUARTILE(array,quart) returns the quartile of a data set
21.61.2.=QUARTILE(A1:A10,0) returns Minimum value in the data.=QUARTILE(A1:A10,0) returns Minimum value in the data.
21.61.3.=QUARTILE(A1:A10,1) returns the value at the 25th percentile=QUARTILE(A1:A10,1) returns the value at the 25th percentile