S
Stephen
Can anyone advise on a question to do with finding cut-off
values in a set of data?
I want to analyse a set of data to find - not the average
value, but - that value above which x% of the data entries
will lie, where x is a variable which I want to be able to
manipulate up and down.
If x = 50% it's easy - the "median" function in Excel
which will do this.
But what if x is any other value? Can this be calculated
in Excel, and how easy would it be to automate (e.g. by
using a macro?).
This operation needs to be repeated hundreds of times with
different datasets so ideally I don't want a solution
which involves much (any) manual intervention, counting,
etc.
Thanks in advance for anyone's bright ideas!
Stephen.
values in a set of data?
I want to analyse a set of data to find - not the average
value, but - that value above which x% of the data entries
will lie, where x is a variable which I want to be able to
manipulate up and down.
If x = 50% it's easy - the "median" function in Excel
which will do this.
But what if x is any other value? Can this be calculated
in Excel, and how easy would it be to automate (e.g. by
using a macro?).
This operation needs to be repeated hundreds of times with
different datasets so ideally I don't want a solution
which involves much (any) manual intervention, counting,
etc.
Thanks in advance for anyone's bright ideas!
Stephen.