Calculation Method for Quartiles

[Mike57]

The QUARTILE function calculates Q1 and Q3 differently than my math textbook.
Does anyone know what method Excel uses for this function? For the example
given in Excel Help under Quartile my math text would return 3 as the Q1
value where Excel returns 3.5.

 

[Bernd Plumhoff]

See

http://www.math.bcit.ca/faculty/david_sabo/apples/math2441/
section4/relstanding/RelStanding.htm

HTH,
Bernd

 

[Michael R Middleton]

Mike57 -

Refer to the built-in Help for the Percentile(array,k) function, where
0<=k<=1. Percentile(array,0) = minimum value in the array of n values.
Percentile(array,1) = maximum value in the array. "If k is not a multiple of
1/(n - 1), PERCENTILE interpolates to determine the value at the k-th
percentile." Quartile(array,1) = Percentile(array,0.25).

- Mike

www.mikemiddleton.com

++++++++++++++++++++++