RangeCorrel() returns the correlation coefficient for two sets of data. The correlation coefficient is a measure of the relationship between the data sets.
Syntax:
RangeCorrel(x_values , y_values[, Expression])
Return data type: numeric
Data series should be entered as (x,y) pairs. For example, to evaluate two series of data, array 1 and array 2, where the array 1 = 2,6,9 and array 2 = 3,8,4 you would write RangeCorrel (2,3,6,8,9,4) which returns 0.269.
Arguments:
- x-value, y-value: Each value represents a single value or a range of values as returned by an inter-record functions with a third optional parameter. Each value or range of values must correspond to an x-value or a range of y-values.
- Expression: Optional expressions or fields containing the range of data to be measured.
Limitations:
The function needs at least two pairs of coordinates to be calculated.
Text values, NULL values and missing values return NULL.
Examples:
| Example | Result |
|---|---|
|
RangeCorrel (2,3,6,8,9,4) |
Returns 0.269 |
