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
|