Thread: How can I obtain the average of the middle quartile of an array?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nick nick is offline
external usenet poster
  
Posts: 192
Default How can I obtain the average of the middle quartile of an arra
Sorry, just found that this does in fact work!

Thanks!

"Mike Middleton" wrote:

nick -

=TRIMMEAN(data_range,0.5)

- Mike Middleton
http://www.MikeMiddleton.com



"nick" wrote in message
...
I have a list of numbers and I want to discard the first and last quartile,
and then obtain an average of whats left.

Thanks!!



Reply With QuoteReply With Quote