View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah Sarah is offline
external usenet poster
 
Posts: 231
Default Quartile funciton...quintile?

Hi there

1. I like the quartile function but I actually need quintiles. Is there a
way to force the function to break up the range into 5 instead of 4?

2. Instead of returning the value at the top of the quartile (or quintile),
I would prefer it averages the range in the specific quartile. How would I do
that?

Thanks!