Spread Formula Reference
CORREL

This function returns the correlation coefficient of the two sets of data.

Syntax

CORREL(array1,array2)

Arguments

The two arrays of data in the arguments of this function should meet these criteria:

Data Types

Accepts arrays of numeric data for both arguments. Returns numeric data.

Examples

CORREL(C1:C10,D1:D10)

CORREL(R1C3:R10C3,R1C4:R10C4)

CORREL({5,10,15,20,25},{4,8,16,32,64}) gives the result 0.9332565253

CORREL({73000,45000,40360},{42,70,40}) gives the result -0.3261046660

Version Available

This function is available in product version 1.0 or later.

See Also

COVAR | Statistical Functions

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options