Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
See
http://www.math.bcit.ca/faculty/davi...ples/math2441/ section4/relstanding/RelStanding.htm HTH, Bernd |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
method and function | Excel Worksheet Functions | |||
Help with calculation | Excel Worksheet Functions | |||
Help on automatically ending a calculation | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |