Computes the covariance between two columns using the sample method. Source values can be of Integer or Decimal type.
Covariance measures the joint variation between two sets of values. The sign of the covariance tends to show the linear relationship between the two datasets; positive covariance indicates that the numbers tend to increase with each other.
This function is calculated across a sample of all values.
Output: Returns the covariance using the sample method between the values in the
squareFootage column and the
covarsamp(function_col_ref1,function_col_ref2) [group:group_col_ref] [limit:limit_count]
|function_col_ref1||Y||string||Name of column that is the first input to the function|
|function_col_ref2||Y||string||Name of column that is the second input to the function|
For more information on the
limit parameters, see Pivot Transform.
Name of the column the values of which you want to calculate the covariance. Column must contain Integer or Decimal values.
|Required?||Data Type||Example Value|
|Yes||String (column reference)|