Share via


WorksheetFunction.Correl Method (Excel)

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 and Arg2 have a different number of data points, Correl generates an error.

  • If either Arg1 or Arg2 is empty, or if s (the standard deviation) of their values equals zero, Correl generates an error.

  • The equation for the correlation coefficient is: Ff835548.awfcrrl1_ZA06051129(en-us,office.14).gifwhere x and y are the sample means Average(Arg1) and Average(Arg2).

See Also

Concepts

WorksheetFunction Object

WorksheetFunction Object Members