CORRELATION: Calculating the Degree of Correlation Between Two Sets of Data

How to:

Calculate the Correlation Coefficient Between Two Fields

The CORRELATION function calculates the correlation coefficient between two numeric fields. The function returns a numeric value between zero (0.0) and 1.0.

Syntax: How to Calculate the Correlation Coefficient Between Two Fields

CORRELATION(field1, field2)

where:

field1

Numeric

Is the first set of data for the correlation.

field2

Numeric

Is the second set of data for the correlation.

Example: Calculating a Correlation

CORRELATION calculates the correlation between DOLLARS and BUDDOLLARS.

CORRELATION(DOLLARS, BUDDOLLARS)

For DOLLARS=46,156,290.00 and BUDDOLLARS=46,220,778.00, the result is 0.895691073.

	WebFOCUS