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!

Quartile funciton...quintile?
 

Use PERCENTILE for first question
Note that
QUARTILE(range,1) = PERCENTILE(range,0.25)
QUARTILE(range,2) = PERCENTILE(range,0.5)
etc
It would follow that
"QUINTILE(range,1)" =PERCENTILE(range,0.2)
"QUINTILE(range,2)" =PERCENTILE(range,0.4)
etc

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sarah" wrote in message
...
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!