This topic has not yet been rated - Rate this topic

# WorksheetFunction.Correl Method (Excel)

Office 2013

Published: July 16, 2012

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