Difference between revisions of "Manuals/calci/COVAR"

Latest revision as of 15:52, 7 August 2018

COVAR (Array1,Array2)

where,

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

COVAR (Array1,Array2)

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

The syntax is to use the COVAR function in ZOS is
- $Array1$ and $Array2$ 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])

=COVAR(A2:A6,B2:B6) : Returns 4 as the output.
=COVAR(A2:A5,[12,13,14,15]) : Returns 2.5 as the output.

@@ Line 1: / Line 1: @@
-=COVAR (Array1,Array2)=
+<div style="font-size:30px">'''COVAR (Array1,Array2)'''</div><br/>
 where,
 *<math>Array1</math> is the first array of integers or reference to the cells containing array
 *<math>Array2</math> is the second array of integers or reference to the cells containing array
+**COVAR(), returns covariance, the average of the products of paired deviations.
-COVAR calculates the covariance, the average of the products of deviations for each data point pair in two arrays.
 == Description ==