View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How to find the top 5% observations

You want to "chop off the top 5% and the bottom 5%"?

I'm not quite sure what you mean by "chop off".

Delete them from the list?
Filter them out?
Perform a calculation on the list, but excluding the top/bottom 5%?
or something else?

***********
Regards,
Ron

XL2002, WinXP


"Bin" wrote:

Hi,
I have an array of data, and would like to chop off the top 5% and the
bottom 5% observations. How can I do this?
thank you very much