Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the top 5% observations
Hi,
I have an array of data, and would like to chop off the top 5% and the bottom 5% observations. How can I do this? thank you very much |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the top 5% observations
You want to "chop off the top 5% and the bottom 5%"?
I'm not quite sure what you mean by "chop off". Delete them from the list? Filter them out? Perform a calculation on the list, but excluding the top/bottom 5%? or something else? *********** Regards, Ron XL2002, WinXP "Bin" wrote: Hi, I have an array of data, and would like to chop off the top 5% and the bottom 5% observations. How can I do this? thank you very much |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the top 5% observations
sorry for the confusion.
I want to find the cut-off point and delete the observations above the point(top 5%) and below the point (bottom 5%) thank you "Ron Coderre" wrote: You want to "chop off the top 5% and the bottom 5%"? I'm not quite sure what you mean by "chop off". Delete them from the list? Filter them out? Perform a calculation on the list, but excluding the top/bottom 5%? or something else? *********** Regards, Ron XL2002, WinXP "Bin" wrote: Hi, I have an array of data, and would like to chop off the top 5% and the bottom 5% observations. How can I do this? thank you very much |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the top 5% observations
Use Autofilter:
Let's say we have a header cell in A1 and data from A2 on down. Sort this data. In B1 and C1 put header information in B2 put =ROW() and copy down in C2 put =B2/MAX(B:B) and copy down Then in C1 switch-on Autofilter and select Custom: Greater than .05 and Less than .95 The top 5% and bottom 5% should be filtered out. -- Gary''s Student "Bin" wrote: Hi, I have an array of data, and would like to chop off the top 5% and the bottom 5% observations. How can I do this? thank you very much |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find the top 5% observations
this works
thanks a lot "Gary''s Student" wrote: Use Autofilter: Let's say we have a header cell in A1 and data from A2 on down. Sort this data. In B1 and C1 put header information in B2 put =ROW() and copy down in C2 put =B2/MAX(B:B) and copy down Then in C1 switch-on Autofilter and select Custom: Greater than .05 and Less than .95 The top 5% and bottom 5% should be filtered out. -- Gary''s Student "Bin" wrote: Hi, I have an array of data, and would like to chop off the top 5% and the bottom 5% observations. How can I do this? thank you very much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |