percentiles

R

RodrigoBriceno

I have a set of 32 observations and I want to assign each value with its
corresponding decile. That means, at the end each observation will be
classified with values between 1 and 9. Does anybody knows how to handle that
in Excel? Thanks for your help.
 
R

Ron Rosenfeld

I have a set of 32 observations and I want to assign each value with its
corresponding decile. That means, at the end each observation will be
classified with values between 1 and 9. Does anybody knows how to handle that
in Excel? Thanks for your help.
Click to expand...

Take a look at the PERCENTILE worksheet function.
--ron
 
Top