Percentile - Alternative Methods

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:

v_P = \begin{cases} v_1, & \mbox{for }n=1 \\ v_N, & \mbox{for }n=N \\ v_k+d(v_{k+1}-v_k), & \mbox{for }1 < n < N \end{cases}

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:

    “Our mother gives us our earliest lessons in love—and its partner, hate. Our father—our “second other”Melaborates on them. Offering us an alternative to the mother-baby relationship . . . presenting a masculine model which can supplement and contrast with the feminine. And providing us with further and perhaps quite different meanings of lovable and loving and being loved.”
    —Judith Viorst (20th century)

    “With a generous endowment of motherhood provided by legislation, with all laws against voluntary motherhood and education in its methods repealed, with the feminist ideal of education accepted in home and school, and with all special barriers removed in every field of human activity, there is no reason why woman should not become almost a human thing. It will be time enough then to consider whether she has a soul.”
    —Crystal Eastman (1881–1928)