RangeCorrel - script and chart function
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 (
Arguments:
Argument | Description |
---|---|
|
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. |
|
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 and results:
Examples | Results |
---|---|
|
Returns 0.269 |
See also:
Thanks for helping us improve!