Document Solutions for Excel, .NET Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
  - AVEDEV
  - AVERAGE
  - AVERAGEA
  - AVERAGEIF
  - AVERAGEIFS
  - BETA.DIST
  - BETA.INV
  - BINOM.DIST
  - BINOM.DIST.RANGE
  - BINOM.INV
  - CHISQ.DIST
  - CHISQ.DIST.RT
  - CHISQ.INV
  - CHISQ.INV.RT
  - CHISQ.TEST
  - CONFIDENCE.NORM
  - CONFIDENCE.T
  - CORREL
  - COUNT
  - COUNTA
  - COUNTBLANK
  - COUNTIF
  - COUNTIFS
  - COVARIANCE.P
  - COVARIANCE.S
  - DEVSQ
  - EXPON.DIST
  - F.DIST
  - F.DIST.RT
  - F.INV
  - F.INV.RT
  - F.TEST
  - FISHER
  - FISHERINV
  - FORECAST
  - FORECAST.LINEAR
  - FREQUENCY
  - GAMMA
  - GAMMA.DIST
  - GAMMA.INV
  - GAMMALN
  - GAMMALN.PRECISE
  - GAUSS
  - GEOMEAN
  - GROWTH
  - HARMEAN
  - HYPGEOM.DIST
  - INTERCEPT
  - KURT
  - LARGE
  - LINEST
  - LOGEST
  - LOGNORM.DIST
  - LOGNORM.INV
  - MAX
  - MAXA
  - MAXIFS
  - MEDIAN
  - MIN
  - MINA
  - MINIFS
  - MODE.MULT
  - MODE.SNGL
  - NEGBINOM.DIST
  - NORM.DIST
  - NORM.S.DIST
  - NORM.S.INV
  - NORMINV
  - PEARSON
  - PERCENTILE.EXC
  - PERCENTILE.INC
  - PERCENTRANK.EXC
  - PERCENTRANK.INC
  - PERMUT
  - PERMUTATIONA
  - PHI
  - POISSON.DIST
  - PROB
  - QUARTILE.EXC
  - QUARTILE.INC
  - RANK.AVG
  - RANK.EQ
  - RSQ
  - SKEW
  - SKEW.P
  - SLOPE
  - SMALL
  - STANDARDIZE
  - STDEV.P
  - STDEV.S
  - STDEVA
  - STDEVPA
  - STEYX
  - T.DIST
  - T.DIST.2T
  - T.DIST.RT
  - T.INV
  - T.INV.2T
  - T.TEST
  - TREND
  - TRIMMEAN
  - VAR.P
  - VAR.S
  - VARA
  - VARPA
  - WEIBULL.DIST
  - Z.TEST
- Text Functions
- Web Functions
File Operations
Document Solutions Data Viewer
API Reference
Release Notes

CORREL

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

Syntax

CORREL(array1, array2)

Arguments

This function has these arguments:

Argument	Description
array1	[Required] A range of cell values
array2	[Required] A second range of cell values.

Examples

CORREL(C1:C10,D1:D10)

CORREL(R1C3:R10C3,R1C4:R10C4)