Manuals/calci/COVAR

Revision as of 10:57, 21 January 2014 by Swapna (talk | contribs)

COVAR(a1,a2)

where,

  •   first array of integers or reference to the cells containing array
  •   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.

Description

COVAR(a1,a2)

  • COVAR is used to determine the relationship between two data sets.
  • Arguments  ,   can be numbers or can be names, arrays or references containing numbers.
  • Values containing text, logical values or empty cells are ignored.
  • If either   or   is empty, Calci displays a NaN error message.
  • The number of data points in   and   should be same, else Calci displays a #N/A error message.

Examples

Array 1 Array 2
2 21
4 22
6 23
8 24
10 25
=COVAR(A2:A6,B2:B6) : Returns 4 as the output.
=COVAR(A2:A5,{12,13,14,15}) : Returns '2.5 as the output.

See Also

References