Statistical

CORREL function

Correlation coefficient of two data sets. CORREL works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=CORREL(array1, array2)

Argument	Use
`array1`	required, repeatable
`array2`	required, repeatable

On live data

In Sheets, CORREL sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

More statistical functions

AVERAGEMean of values AVERAGEIFMean where one criterion matches AVERAGEIFSConditional mean COUNTCount numbers COUNTACount non-empty COUNTIFCount where one criterion matches COUNTIFSConditional count MAXMaximum value MAXIFSLargest value where all criteria match MEDIANMiddle value MINMinimum value MINIFSSmallest value where all criteria match

All 147 statistical functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations