T
Tom Freeman
What is the best way to calculate quintile returns for a long list of return
data?
data?
T
Tom Freeman
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.
in which I want to calculate the quintile return based on the # of employees.
S
Shane Devenshire
Hi,
I'm not completely sure what a quintile return is but Excel has a QUINTILE
function which you might want to consider.
I'm not completely sure what a quintile return is but Excel has a QUINTILE
function which you might want to consider.
T
Tom Freeman
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.
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.
S
Shane Devenshire
Hi,
Sorry, I missed that. Try this instead:
=PERCENTILE(E1:E4,0.2)
You can do any ...tile with this. In your case use .2, .4, .6, .8, 1
Sorry, I missed that. Try this instead:
=PERCENTILE(E1:E4,0.2)
You can do any ...tile with this. In your case use .2, .4, .6, .8, 1