| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Throwing Out top & lower percentages
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Throwing Out top & lower percentages
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-Pro "Gary Gonzales" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Throwing Out top & lower percentages
Perfect!
"Ron Coderre" wrote: 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-Pro "Gary Gonzales" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| math formula with upper and lower limits on data but also ranges | Excel Worksheet Functions | |||
| Convert all caps to lower case | New Users to Excel | |||
| How do I change column size for lower half of sheet? | Excel Discussion (Misc queries) | |||
| Convert lower case charecters to upper case | Excel Discussion (Misc queries) | |||
| List vector using upper and lower limits | Excel Discussion (Misc queries) | |||
Linear Mode
