How to use the COVAR function
The COVAR function calculates the covariance meaning the average of the products of deviations for each pair in two different datasets. This function is outdated and has been replaced with the COVARIANCE.P and COVARIANCE.S functions.
The covariance is positive if greater values in the first data set correspond to greater values in the second data set. The covariance is negative if greater values in the first data set correspond to smaller values in the second data set.
Formula in cell C18:
Excel Function Syntax
COVAR(array1, array2)
Arguments
| array1 | Required. The first data set. |
| array2 | Required. The second data set. |
Comments
Text, logical or empty values are ignored, however, 0 (zeros) are included.
The COVAR function returns
- #N/A error value if the number of data points in array1 and array2 is not equal.
- #DIV/0! error value if either array1 or array2 is empty.
The equation for COVAR is:
x ̅ is the sample means AVERAGE(array1) and y ̅ is the sample means AVERAGE(array2).
n is the sample size.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Compatibility'
The COVAR function function is one of many functions in the 'Compatibility' category.
How to use the BETADIST function
The BETADIST function calculates the beta distribution representing an outcome in the form of probability. This function is in the compatibility […]
How to use the BETAINV function
The BETAINV function calculates the inverse of the beta distribution. This function is outdated and replaced by the BETA.INV function […]
How to use the BINOMDIST function
The BINOMDIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]
How to use the CHIDIST function
The CHIDIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. The […]
How to use the CHIINV function
The CHIINV function calculates the inverse probability of the chi-squared distribution. The CHIINV function is outdated and you will find […]
How to use the CHITEST function
The CHITEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]
How to use the CONFIDENCE function
The CONFIDENCE function calculates the confidence interval for a population mean, using a normal distribution. Formula in cell B6: =CONFIDENCE(B3, […]
The COVAR function calculates the covariance meaning the average of the products of deviations for each pair in two different […]
How to use the CRITBINOM function
The CRITBINOM function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]
How to use the EXPONDIST function
The EXPONDIST function calculates the exponential distribution representing an outcome in the form of probability. This function is in the compatibility […]
The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is […]
The FLOOR function rounds a number down, toward zero, to the nearest multiple of significance. Excel Function Syntax FLOOR(number, significance) Arguments […]
How to use the FORECAST function
The FORECAST function calculates a value based on existing x and y values using linear regression. Use this function to […]
The FTEST function calculates the value from an F-test. The value shows if the variances from two data sets are […]
How to use the GAMMADIST function
The GAMMADIST function calculates the gamma often used in queuing analysis in probability statistics. This function is outdated and has […]
How to use the LOGNORMDIST function
The LOGNORMDIST function calculates the cumulative lognormal distribution of argument x, based on a normally distributed ln(x) with the arguments of […]
The MODE function calculates the most frequent number in a cell range. Number 4 exists 3 times on picture above […]
How to use the PERCENTRANK function
The PERCENTRANK function calculates the percent rank of a given number compared to the whole data set. The image above […]
How to use the QUARTILE function
The QUARTILE function returns the quartile of a data set, use the QUARTILE function to divide data into groups. This […]
The RANK function calculates the rank of a specific number compared to a list of numbers. Formula in cell C3: […]
The STDEV function calculates the standard deviation of a group of values. Standard deviation shows how much the values differ from the […]
English
Spanish
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form