writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: − + − + Line 55:
Line 55: − +
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 ==