R
Rob
Hi everyone,
I need help setting up a formula.
I have N observations (usually between 60 and 100 observations).
I want to choose the observation that estimates the 95th percentile.
Industry guidelines suggest that the observations be ranked and the 95th
percentile observation be chosen based on the following formula:
95th percentile observation ~= observation in position (N*(95/100)+0.5)
If there are 87 observations ranked from smallest to largest, the 95th
percentile observation would be at position 83.15
In cases like this the value of the 95th percentile would be estimated by
linear interpolation of the results at position 83 and position 84 as
follow:
Value at position 83 + 0.15(Value at position 84 - Value at position 83)
Is there some way to set this up as a single formula?
Thank you,
Rob
I need help setting up a formula.
I have N observations (usually between 60 and 100 observations).
I want to choose the observation that estimates the 95th percentile.
Industry guidelines suggest that the observations be ranked and the 95th
percentile observation be chosen based on the following formula:
95th percentile observation ~= observation in position (N*(95/100)+0.5)
If there are 87 observations ranked from smallest to largest, the 95th
percentile observation would be at position 83.15
In cases like this the value of the 95th percentile would be estimated by
linear interpolation of the results at position 83 and position 84 as
follow:
Value at position 83 + 0.15(Value at position 84 - Value at position 83)
Is there some way to set this up as a single formula?
Thank you,
Rob