WorksheetFunction.Correl Method
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 and have a different number of data points, Correl generates an error.If either or is empty, or if s (the standard deviation) of their values equals zero, Correl generates an error.The equation for the correlation coefficient is:
where x and y are the sample means Average(Arg1) and Average(Arg2).
See also:
Arg1 Arg2 Arg1 Arg2