WorksheetFunction.Correl Method

  • Article
Excel Developer Reference

Returns the correlation coefficient of the Arg1 and Arg2 cell ranges.

Syntax

expression.Correl(Arg1, Arg2)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data Type Description
Arg1 Required Variant A cell range of values.
Arg2 Required Variant A second cell range of values.

Return Value
Double

Remarks

Use the correlation coefficient to determine the relationship between two properties. For example, you can examine the relationship between a location's average temperature and the use of air conditioners.

  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

  • If

    Arg1

  • If either

    Arg1

  • The equation for the correlation coefficient is:

    Equation

    where x and y are the sample means Average(Arg1) and Average(Arg2).

See Also