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
If you provide values manually, enter them 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:
| Argument | Description |
|---|---|
| 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 are disregarded.
Examples and results:
| Examples | Results |
|---|---|
|
RangeCorrel (2,3,6,8,9,4) |
Returns 0.269 |
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!