software

Excel 2003.

I have a column of 11 numbers.
I would like to throw out the two highest,
the two lowest, and get an average of the
remaining 7.
Any help is greatly appreciated.
Thanks SkipOne way:
=TRIMMEAN(A1:A11,4/11)
or
=(sum(a1:a11)-sum(large(a1:a11,{1,2}))-sum(small(a1:a11,{1,2})))/7
Skip wrote:
gt;
gt; Excel 2003.
gt;
gt; I have a column of 11 numbers.
gt; I would like to throw out the two highest,
gt; the two lowest, and get an average of the
gt; remaining 7.
gt; Any help is greatly appreciated.
gt; Thanks Skip

--

Dave Peterson

gt; I would like to throw out the two highest,
gt; the two lowest, and get an average...

Hi. I like to think of it as throwing out '4 of the '11 numbers...

=TRIMMEAN(A1:A11,4/11)

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Skipquot; gt; wrote in message oups.com...
gt; Excel 2003.
gt;
gt; I have a column of 11 numbers.
gt; I would like to throw out the two highest,
gt; the two lowest, and get an average of the
gt; remaining 7.
gt; Any help is greatly appreciated.
gt; Thanks Skip
gt;
One way:

=AVERAGE(LARGE(C1:C11,{3,4,5,6,7,8,9}))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

quot;Skipquot; gt; wrote in message oups.com...
gt; Excel 2003.
gt;
gt; I have a column of 11 numbers.
gt; I would like to throw out the two highest,
gt; the two lowest, and get an average of the
gt; remaining 7.
gt; Any help is greatly appreciated.
gt; Thanks Skip
gt;