Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Correl Method
Collapse the table of content
Expand the table of content

WorksheetFunction.Correl Method (Excel)

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

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

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: awfcrrl1_ZA06051129where x and y are the sample means Average(Arg1) and Average(Arg2).

Show:
© 2015 Microsoft