Manuals/calci/QUARTILE

QUARTILE(Array,Quartile)


  • is the array of numeric values
  • indicates the position of the quartile

Description

  • This function gives the value of quartile for a given set.
  • Quartiles are the values that divide a list of numbers into quarters.
  • A quartile is a type of quantile.
  • In  ,   is the array of numeric values to find the Quartile and   is the position of the quartile.
qu value   QUARTILE(result)
0   -           Minimum value
1   -           First quartile(25th Percentile)
2    -          Median value(50th Percentile)
3    -          Third quartile(75th Percentile)
4    -          Maximum value  
  • The difference between the upper and lower quartiles is called the inter-quartile range.
  • When we are giving   in a decimal value, then it will change in to integer.
  • This function will give the result as error when
 1. The array is empty
 2.   or  
 3. MIN,MEDIAN and MAX will give the same value as QUARTILE when   is 0,2,and 4 respectively.

Examples

Spreadsheet
A B C D E
1 2 3 7 9 15
2 8 12 13 20 25
3 14 3 9 6 15
4 12 23 1 42 17
5
  • =QUARTILE(A1:A4,0) = 2
  • =QUARTILE(A1:A4,1) = 6.5
  • =QUARTILE(B2:E3,3) = 16.25
  • =QUARTILE(A2:B3,3) = 12.5
  • =QUARTILE(A5:E5,3) = NAN

Related Videos

QUARTILE

See Also

References