tertiles

[Sriram]

Any idea how I can get tertiles in excel. I cannot find any such functions
and it seems it should not be very hard to get this in microsoft excel.

 

[Dav]

The percentile and Quartile functions exist, these can easily b
manipulated to get the tertile

E
if(a1<quantile(range,1),1,if(a1<quantile(range,2),2,if(a1<quantile(range,3),3,4)))

If tertiles are what i think them to be!

Regards

Da

 

[bplumhoff]

Hello,

You might want to use PERCENTILE(range,1/3), PERCENTILE(range,2/3),
PERCENTILE(range,3/3) as proxies for 1st, 2nd and 3rd tertile. Please
notice that this might differ slightly from the correct solution.

HTH,
Bernd