Syntax
=CORREL(array1, array2)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first set of values |
array2 | Required | The second set of values |
How to use CORREL
CORREL takes 2 required arguments. Type =CORREL( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=CORREL({3,2,4,5,6}, {9,7,12,15,17})Result Related statistical functions
- CHISQ.INV.RTReturns the inverse of the right tailed chi squared distribution.
- CHISQ.TESTReturns the chi squared test of independence: the probability of the observed values given the expected ones.
- CONFIDENCE.NORMReturns the margin of error of a population mean using a normal distribution.
- CONFIDENCE.TReturns the margin of error of a population mean using Student's t distribution.
- COUNTCounts how many numbers are in a list or range.
- COUNTACounts the cells and values that are not empty.
- COUNTBLANKCounts the empty cells in a range, including cells holding empty text.
- COUNTIFCounts the cells in a range that meet a condition.
- COUNTIFSCounts the cells that meet all of several conditions.