writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + Line 9:
Line 9: − + − + − +
no edit summary
=COVAR(a1,a2)=
=COVAR (Array1,Array2)=
where,
where,
*<math>a1</math> is the first array of integers or reference to the cells containing array
*<math>Array1</math> is the first array of integers or reference to the cells containing array
*<math>a2</math> is the second array of integers or reference to the cells containing array
*<math>Array2</math> is the second array of integers or reference to the cells containing array
COVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays.
COVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays.
== Description ==
== Description ==
COVAR(a1,a2)
COVAR (Array1,Array2)
*COVAR is used to determine the relationship between two data sets.
*COVAR is used to determine the relationship between two data sets.
*Arguments <math>a1</math>, <math>a2</math> can be numbers or can be names, arrays or references containing numbers.
*Arguments <math>Array1</math>, <math>Array2</math> can be numbers or can be names, arrays or references containing numbers.
*Values containing text, logical values or empty cells are ignored.
*Values containing text, logical values or empty cells are ignored.
*If either <math>a1</math> or <math>a2</math> is empty, Calci displays a NaN error message.
*If either <math>Array1</math> or <math>Array2</math> is empty, Calci displays a NaN error message.
*The number of data points in <math>a1</math> and <math>a2</math> should be same, else Calci displays a #N/A error message.
*The number of data points in <math>a1</math> and <math>a2</math> should be same, else Calci displays a #N/A error message.