Thread: percentiles
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default percentiles

On Fri, 18 Apr 2008 03:23:00 -0700, RodrigoBriceno
wrote:

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.


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