How to find the pearson correlation in Tableau

In this silent video, you'll learn how to find the Pearson correlation of two measures in Tableau Desktop.

Read the full article here: Finding the Pearson Correlation - kb.tableau.com/articles/HowTo/finding-the-pears…

- - - - - - - - - - - - - -

Step 1: Create a scatterplot
This example uses Superstore sample data and is attached to this article. Open the workbook Pearson Correlation.twbx for more information.
1. Drag Profit to Columns and Sales to Rows.
2. In the Analysis menu, uncheck Aggregate Measures.
3. Right-click the view and choose Trend Lines ; Show Trend Lines.
4. Right-click the view again and select Trend Lines ; Describe Trend Model.
5. Locate the R-Squared value in the Describe Trend Model dialog box. In this example, the R-Squared value is 0.229503.

Step 2: Calculate the Pearson correlation
1. Use a calculator or other program
1. Calculate the square root of the R-squared value. Which will be your correlation (r): √0.229498 = 0.4791
2. Rounded to two digits, the value in this example is 0.48.
2. Create a calculated field using the CORR function.
1. Enter a formula similar to the following and click OK:
CORR([Profit], [Sales])
3. Create a calculated field using the WINDOW_CORR function.
1. Enter a formula similar to the following and click OK:
WINDOW_CORR(SUM([Profit]), SUM([Sales]))

Related solutions:
Creating a Correlation Value Matrix - kb.tableau.com/articles/HowTo/creating-a-correl…

- - - - - - - - - - - - - -

Subscribe to the Tableau YouTube channel here: youtube.com/subscription_center?add_user=tablea…

Free Trial of Tableau: tableau.com/products/trial