Corr

The Corr function calculates the Pearson correlation coefficient, also known as the bivariate correlation, of two numerical columns.

Syntax

Corr(number column 1, number column 2)

Function arguments:

• number column 1 (required) - A column of numbers representing the dependent data.

• number column 2 (required) - A column of numbers representing the independent data.

Example

Corr([Quantity], [Price])

📘With this negative correlation, we can see that as price increases, the quantity of purchased item decreases.