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.

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

Eg
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

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=557732

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