Calculation Method for Quartiles

M

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.
 
M

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

++++++++++++++++++++++
 
Top