## Corr Studies

Tableau 10.2 came out a couple weeks ago and a small but notable feature included in this version of our product is the Corr() and Window_Corr() functions. These calculations compute a coefficient of correlation based on two variables. I’ve done linear algebra in Tableau before, and it’s often quite complicated and looks like this: The idea with making Corr a simple function in Tableau is to give users a faster and simpler way to find statistical results. But I was confused. correlation coefficients operate on large groups of numbers, so why would it make sense to aggregate a pair of measures with Corr()? How would the aggregation change based on the layout of a Tableau worksheet? And how could I check the results to make sure I was seeing the correlation coefficient I wanted to see? When doing complex calculations, you often get a seemingly arbitrary number as a result, and some faith is required to trust that the number is answering the question you intended to ask, and not a different question. Below are some findings from my Corr studies: A quick preamble about my math background. I was always pretty good at math growing up, but I […]