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

[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!!

 

[Shane Devenshire]

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.

 

[Mike H]

Try

=QUARTILE(A1:A8,2)

Mike

 

[Mike Middleton]

nick -

=TRIMMEAN(data_range,0.5)

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

 

[nick]

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

 

[nick]

Sorry, just found that this does in fact work!

Thanks!