How can I obtain the average of the middle quartile of an array?

  • Thread starter Thread starter nick
  • Start date Start date
N

nick

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!!
 
Hi,

Try the following array formula:

=AVERAGE(IF((A1:A8>QUARTILE(A1:A8,1))*(A1:A8<QUARTILE(A1:A8,3)),A1:A8,""))

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

Thanks for all your replies. Unfortunately none of them give me the correct
answer.

To be more precise, I need Excel to calculate the Interquartile Mean
(http://en.wikipedia.org/wiki/Interquartile_mean) from an array which is
randomly ordered.

Any further help would really be appreciated!

Thanks again,

Nick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average within quartiles 3
conditional format based on column statistics and loop over columns 1
Condtional Quartile statement 3
Array functions 6
Third Quartile 3
User Defined Functions 1
Match Offset by more than one value 4
Can I calculate quartiles in an Excel 2007 pivot table? 2

Back
Top