Measures the degree to which two variables change together. A positive covariance indicates that the variables tend to increase together, while a negative covariance means that when one increases, the other tends to decrease.
Function:
Covariance(table = string, first_col = string, second_col = string, new_col = string)
Parameters:
Table: Table name on which to perform function
First Column: The 1st column to calculate the covariance
Second Column: The 2nd column to calculate the covariance
New Column Name: Name for new column
Examples:
Covariance(table = Budget, first_col = T&E, second_col = ClosedWonDeals, new_col = T&E_correlation)