Calculation Method for Quartiles

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

++++++++++++++++++++++
 
Back
Top