software

I have a list of numbers not in any particular order,

1, 33, 5 , 15, 22, 489, 100, 56, 17, 109, 367, 54, 20

I want to throw out the top 10% and botton 10% and do an average of the
remaining numbers, how do I do this?

p.s. I just provided 10% as an example, I need to be able to change this to
any percentage.
Check Excel Help for the TRIMMEAN function. I think it pretty much does what
you're looking for.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Gary Gonzalesquot; wrote:

gt; I have a list of numbers not in any particular order,
gt;
gt; 1, 33, 5 , 15, 22, 489, 100, 56, 17, 109, 367, 54, 20
gt;
gt; I want to throw out the top 10% and botton 10% and do an average of the
gt; remaining numbers, how do I do this?
gt;
gt; p.s. I just provided 10% as an example, I need to be able to change this to
gt; any percentage.
gt;
gt;

Perfect!

quot;Ron Coderrequot; wrote:

gt; Check Excel Help for the TRIMMEAN function. I think it pretty much does what
gt; you're looking for.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Gary Gonzalesquot; wrote:
gt;
gt; gt; I have a list of numbers not in any particular order,
gt; gt;
gt; gt; 1, 33, 5 , 15, 22, 489, 100, 56, 17, 109, 367, 54, 20
gt; gt;
gt; gt; I want to throw out the top 10% and botton 10% and do an average of the
gt; gt; remaining numbers, how do I do this?
gt; gt;
gt; gt; p.s. I just provided 10% as an example, I need to be able to change this to
gt; gt; any percentage.
gt; gt;
gt; gt;