View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Percentile Value

Look in Excel help at the percentile worksheet function.

--
Regards,
Tom Ogilvy


"Charles Deng" wrote in message
...
Hi All:

Is there any formula I can use to calculate percentile
value? Suppose I want to know top 75 percentile value of
a varialbe, can I just write a formula to obtain that
value as we do for mean, max, min, frequency, etc.? Any
advice will be highly appreciated.

If this question is stupid or impossible, please let me
know, too. Thanks.


Charles