Calculation Method for Quartiles
 

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.

See

http://www.math.bcit.ca/faculty/davi...ples/math2441/
section4/relstanding/RelStanding.htm

HTH,
Bernd

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

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

"Mike57" wrote in message
...
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.