Correlation

Contents[Hide]

The CORRELATION function calculates the correlation between two input data series. It measures the strength of the relationship between the two series. The resulting correlation value ranges between -1 and 1. A correlation value of zero implies that the two series are independent and have no relationship. A correlation value that is close to 1 implies that the two series are positively correlated. Similarly, a correlation value that is close to -1 implies that the two series are negatively correlated. If the correlation value is negative, this means that when the first input is large, the second input is small (and vice-versa).

Correlation shown on the Script Measure column
Correlation shown on the Script Measure column

1. Syntax

CORRELATION(d0,d1)

2. Input

The Correlation function requires the following input series:

  • d0: First Input data values - The first set of data values for which the Correlation is calculated.
  • d1: Second Input data values - The second set of data values for which the Correlation is calculated.

3. Parameters

The Correlation function has no parameters.

4. Output

The Correlation function generates the following outputs:

  • Correlation - A single value representing the correlation between the two sets of input values.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri