Syntax
=COVARIANCE.S(array1, array2)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first set of values |
array2 | Required | The second set of values |
How to use COVARIANCE.S
COVARIANCE.S takes 2 required arguments. Type =COVARIANCE.S( 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.
=COVARIANCE.S({2,4,8}, {5,11,12})Result Related statistical functions
- 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.
- COVARIANCE.PReturns the population covariance of two sets of numbers.
- DEVSQReturns the sum of squared deviations of the numbers from their mean.
- EXPON.DISTReturns the exponential distribution.
- F.DISTReturns the left tailed F probability distribution.
- F.DIST.RTReturns the right tailed F probability distribution.
- F.INVReturns the inverse of the left tailed F distribution.