Quintile Returns
There is a quartile function but no quintile function. I am basically
looking to split the data in the following way:
# of employess
Largest 20% Rank
21%-40%
41%-60%
61%-80%
81%-100%
And than show the average return for each group.
"Shane Devenshire" wrote:
Hi,
I'm not completely sure what a quintile return is but Excel has a QUINTILE
function which you might want to consider.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Tom Freeman" wrote:
I am specifically looking at a table with two fields (# of employees, Return)
in which I want to calculate the quintile return based on the # of employees.
"Tom Freeman" wrote:
What is the best way to calculate quintile returns for a long list of return
data?
|