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!!
and then obtain an average of whats left.
Thanks!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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.
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.
M
Mike H
Try
=QUARTILE(A1:A8,2)
Mike
=QUARTILE(A1:A8,2)
Mike
M
Mike Middleton
N
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
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
N
nick
Sorry, just found that this does in fact work!
Thanks!
Thanks!