Alternative Methods
Some software packages, including Microsoft Excel (up to the version 2007) use the following method, noted as an alternative by NIST to estimate the value, of the P-th percentile of an ascending ordered dataset containing N elements with values .
The rank is calculated:
and then split into its integer component k and decimal component d, such that . Then is calculated as:
The primary method recommended by NIST is similar to that given above, but with the rank calculated as
These two approaches give the rank of the 40th percentile in the above example as, respectively:
and
- .
The values are then interpolated as usual based on these ranks, yielding 29 and 26, respectively, for the 40th percentile.
Read more about this topic: Percentile
Famous quotes containing the words alternative and/or methods:
“No alternative to the
one-man path.”
—Denise Levertov (b. 1923)
“We are lonesome animals. We spend all our life trying to be less lonesome. One of our ancient methods is to tell a story begging the listener to sayand to feelYes, thats the way it is, or at least thats the way I feel it. Youre not as alone as you thought.”
—John Steinbeck (19021968)