Syntax
=COVAR(array1, array2)Arguments
| Argument | Required | Description |
|---|---|---|
array1 | Required | The first set of values |
array2 | Required | The second set of values |
How to use COVAR
COVAR is kept so older workbooks keep working. It calculates the same way as COVARIANCE.P, which is the name to use in new formulas.
COVAR takes 2 required arguments. Type =COVAR( 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.
=COVAR({3,2,4,5,6}, {9,7,12,15,17})Result Related compatibility functions
- CHIDISTReturns the right tailed chi squared probability (older name of CHISQ.DIST.RT).
- CHIINVReturns the inverse of the right tailed chi squared distribution (older name of CHISQ.INV.RT).
- CHITESTReturns the chi squared test of independence (older name of CHISQ.TEST).
- CONFIDENCEReturns the margin of error of a population mean (older name of CONFIDENCE.NORM).
- CRITBINOMReturns the smallest number of successes reaching a cumulative probability (older name of BINOM.INV).
- EXPONDISTReturns the exponential distribution (older name of EXPON.DIST).
- FDISTReturns the right tailed F distribution (older name of F.DIST.RT).
- FINVReturns the inverse of the right tailed F distribution (older name of F.INV.RT).
- FTESTReturns the result of an F test (older name of F.TEST).