Quintile Returns

[Tom Freeman]

What is the best way to calculate quintile returns for a long list of return
data?

 

[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.

 

[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.

 

[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.

 

[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