Manuals/calci/COVAR - Revision history

Devika at 21:52, 7 August 2018

2018-08-07T21:52:35Z

2018-06-06T17:59:26Z

Description

2018-06-06T17:58:36Z

2017-03-13T06:01:58Z

2017-03-09T11:03:07Z

2015-06-05T17:18:43Z

2015-05-09T20:59:52Z

2014-01-21T15:59:03Z

2014-01-21T15:57:38Z

@@ 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.
 == Description ==

@@ Line 15: / Line 15: @@
 *Values containing text, logical values or empty cells are ignored.
 *If either <math>Array1</math> or <math>Array2</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>Array1</math> and <math>Array2</math> should be same, else Calci displays a #N/A error message.
 ==ZOS==

@@ Line 1: / Line 1: @@
-=COVAR(a1,a2)=
+=COVAR (Array1,Array2)=
 where,
-*<math>a1</math> is the first array of integers or reference to the cells containing array
+*<math>Array1</math> is the first 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
+*<math>Array2</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.
@@ Line 9: / Line 9: @@
 == Description ==
-COVAR(a1,a2)
+COVAR (Array1,Array2)
 *COVAR  is used to determine the relationship between two data sets.
-*Arguments <math>a1</math>, <math>a2</math> can be numbers or can be names, arrays or references containing numbers.
+*Arguments <math>Array1</math>, <math>Array2</math> can be numbers or can be names, arrays or references containing numbers.
 *Values containing text, logical values or empty cells are ignored.
-*If either <math>a1</math> or <math>a2</math> is empty, Calci displays a NaN error message.
+*If either <math>Array1</math> or <math>Array2</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.

← Older revision		Revision as of 06:01, 13 March 2017
Line 77:		Line 77:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:03, 9 March 2017
Line 74:		Line 74:

	*[http://en.wikipedia.org/wiki/Covariance Covariance]		*[http://en.wikipedia.org/wiki/Covariance Covariance]
		+
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 56: / Line 56: @@
   =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 ==