Manuals/calci/COVAR

From ZCubes Wiki
Jump to navigation Jump to search
COVAR (Array1,Array2)


where,

  • is the first array of integers or reference to the cells containing array
  • is the second array of integers or reference to the cells containing array
    • COVAR(), returns covariance, the average of the products of paired deviations.

Description

COVAR (Array1,Array2)

  • 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.

ZOS

  • The syntax is to use the COVAR function in ZOS is
    • and are the set of values to find the Covariance.
  • For e.g.,COVAR([10,20,15,17,19],[12,22,31,16,45])
  • COVAR([50..57],[17..24])

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.

Related Videos

Covariance

See Also

References