Hi;
Lets say I have a list of values 1 2 3 4 5 6 7 8 9 10.
and I want to find the 20percentile I whould do this.
20/100*10=2 position two which just happens to have the value of 2 thats fine.
Now lets say I have this list of values 1 2 3 4 5 6 7 8 9
and I want to find the 20 percentile I whould do this.
20/100*9=1.8 because this now produces a decimal do just round up to position two
which just happens to have the value of 2.
because if I find the average of the first ad secund value I get a decimal again ie 1.5.
Conclution: If theres an even number of values just take that value and if theres an odd
number of values round up and take that value?
Thanks.


LinkBack URL
About LinkBacks