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:
.gif "Ff835548.awfcrrl1_ZA06051129(en-us,office.14).gif")
where x and y are the sample means Average(Arg1) and Average(Arg2).