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.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks