[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

CORREL

Syntax:

CORREL ( array-1 , array-2 )

Description: Computes the correlation coefficient of the two cell ranges designated by array-1 and array-2.

Mathematical Formula:

The equation for the correlation coefficient is:

where x and y are the sample means AVERAGE(array-1) and AVERAGE(array-2).

Arguments:

Name

Type

Description

array-1

array, reference

The first cell range. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

array-2

array, reference

The second cell range. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

 

Return Type and Value: number – The correlation coefficient of the cells in two cell ranges.

However, if

array-1 and array-2 have a different number of data points, the return value is unspecified.

array-1 and array-2 is empty, the return value is unspecified.

The standard deviation of the values in array-1 or array-2 equals zero, the return value is unspecified.

[Example:

CORREL({2.532,5.621;2.1,3.4},{5.32,2.765;5.2,6.7}) results in -0.714976

end example]