Difference between revisions of "Manuals/calci/COVAR"

From ZCubes Wiki
Jump to navigation Jump to search
Line 16: Line 16:
 
*If either <math>a1</math> or <math>a2</math> is empty, Calci displays a NaN error message.
 
*If either <math>a1</math> or <math>a2</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.
 +
 +
==ZOS==
 +
*The syntax is to use the COVAR function in ZOS is <math>COVAR (Array1,Array2)</math>
 +
**<math>Array1</math> and <math>Array2</math> 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 ==
 
== Examples ==

Revision as of 12:18, 5 June 2015

COVAR(a1,a2)

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

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