Kendall's Tau

Greg_Deckler — Sat, 16 Feb 2019 20:17:46 GMT

As explained here: https://www.statisticshowto.datasciencecentral.com/kendalls-tau/, Kendall's Tau, or Kendall Rank Correlation Coefficient, is a non-parametric measure of relationships between columns of ranked data. The Tau correlation coefficient returns a value of 0 to 1, where:

0 is no relationship
1 is a perfect relationship

A quirk of this test is that it can also produce negative values (i.e. from -1 to 0). Unlike a linear graph, a negative relationship doesn’t mean much with ranked columns (other than you perhaps switched the columns around), so just remove the negative sign when you’re interpreting Tau.

Several version’s of Tau exist.

Tau-A and Tau-B are usually used for square tables (with equal columns and rows). Tau-B will adjust for tied ranks
Tau-C is usually used for rectangular tables. For square tables, Tau-B and Tau-C are essentially the same.

Most statistical packages have Tau-B built in, but you can use the following formula to calculate it by hand:

Kendall’s Tau = (C – D / C + D)

Where C is the number of concordant pairs and D is the number of discordant pairs.

Pay attention to the setup of this one, you need to make sure that you start with a sorted, ranked column of values. The measure in Power BI looks like this:

Kendall's Tau = 
VAR __table = 'Data'
VAR __table1 = ADDCOLUMNS(__table,"__Concordant",COUNTROWS(FILTER(__table,[Index]>EARLIER([Index])&&[Interviewer2]>EARLIER([Interviewer2]))))
VAR __table2 = ADDCOLUMNS(__table1,"__Discordant",COUNTROWS(FILTER(__table,[Index]>EARLIER([Index])&&[Interviewer2]<EARLIER([Interviewer2]))))
VAR __C = SUMX(__table2,[__Concordant])
VAR __D = SUMX(__table2,[__Discordant])
RETURN
ABS(DIVIDE(__C - __D , __C + __D,0))

eyJrIjoiYzViZWY5NjQtMzM1Ny00MzQ4LTkxMzQtMjgzMWRhZjljYTc2IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

Re: Kendall's Tau

VandanaPulluri — Mon, 15 Jul 2019 09:50:55 GMT

This is really fantastic!

Do you have any work around the Mann Kendall P value, I want to calcualte the Mann Kendall P value by multiple groups like (Region, Country, Department, Product).

Thank you,

topic Kendall's Tau in Quick Measures Gallery

Kendall's Tau

Re: Kendall's Tau