Thread: How can I obtain the average of the middle quartile of an array?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default How can I obtain the average of the middle quartile of an array?
Hi,

Try the following array formula:

=AVERAGE(IF((A1:A8QUARTILE(A1:A8,1))*(A1:A8<QUART ILE(A1:A8,3)),A1:A8,""))

Press Shift+Ctrl+Enter to enter it. You my change the to = but I leave
that up to you.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"nick" wrote:

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