writer
2,661
edits
Changes
no edit summary
where,
where,
*<math>a1</math> first array of integers or reference to the cells containing array
*<math>a1</math> is the first array of integers or reference to the cells containing array
*<math>a2</math> second 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
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.
=COVAR(A2:A6,B2:B6) : Returns ''4'' as the output.
=COVAR(A2:A6,B2:B6) : Returns ''4'' as the output.
=COVAR(A2:A5,{12,13,14,15}) : Returns '2.5'' as the output.
=COVAR(A2:A5,[12,13,14,15]) : Returns ''2.5'' as the output.
== See Also ==
== See Also ==