QUARTILE « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. QUARTILE
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