View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Quintile Returns

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?