Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > QUARTILE
 

QUARTILE(array, quart)

 
 Returns the quartile of a data set.

 arrayThe array or cell range of numeric values.
 quartThe number to indicate the quartile you want to return.

 REMARKS
 
  		• If "array" is empty or contains more than 8,191 data points, then #NUM! is returned.
     
  		• If "quart" is not an integer, it is truncated.
     
  		• If "quart" < 0, then #NUM! is returned.
     
  		• If "quart" > 4, then #NUM! is returned.
     
  		• If "quart" = 1, then this is equivalent to the 25th percentile.
     
  		• If "quart" = 2, then this is equivalent to the 50th percentile.
     
  		• If "quart" = 0, then this is equivalent to the MIN() function.
     
  		• If "quart" = 2, then this is equivalent to the MEDIAN() function.
     
  		• If "quart" = 4, then this is equivalent to the MAX() function.
     
  		• Quartiles are often used in sales and survey data to divide populations into groups.
     
  		• This function could be used to find the top 25 percent of incomes in a population.

     EXAMPLES
     
     A
    1=QUARTILE({1,2,4,7,8,9,10,12},1) = 3.5
    2=QUARTILE({10,20,10},3) = 15
    3=QUARTILE({10,90},2) = 50
    4=QUARTILE({10,90},4) = 90
    5=QUARTILE({15,200,10,40,90},0) = 10
    6=QUARTILE({15,200,10,40,90},4) = 200
    7=QUARTILE({15,200,10,40,90},2) = 40
    8=MEDIAN({15,200,10,40,90}) = 40
    9=QUARTILE({1},5) = #NUM!
    10=QUARTILE({1},"some text") = #VALUE!
    		 
     Functions - Q | Index - Q | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top