Thread: How can I obtain the average of the middle quartile of an array?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default How can I obtain the average of the middle quartile of an array?
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