Manuals/calci/AVERAGEA - Revision history

Devika at 21:17, 7 August 2018

2018-08-07T21:17:09Z

2018-08-07T21:16:20Z

2018-08-07T21:15:45Z

2018-06-05T20:07:00Z

Description

2018-06-05T20:06:41Z

2018-02-26T19:42:35Z

Examples

2017-03-13T05:38:52Z

2017-03-09T10:57:56Z

2015-10-05T05:45:12Z

2015-06-04T16:55:14Z

← Older revision		Revision as of 21:17, 7 August 2018
Line 2:		Line 2:

	*Parameters are values or range of cells containing values.		*Parameters are values or range of cells containing values.
−
	**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.		**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.

@@ Line 3: / Line 3: @@
 *Parameters are values or range of cells containing values.
-AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
+**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
 == Description ==

@@ Line 1: / Line 1: @@
-=AVERAGEA()=
+<div style="font-size:30px">'''AVERAGEA ()'''</div><br/>
 *Parameters are values or range of cells containing values.
-AVERAGEA() calculates the average (arithmetic mean) of the given values.
+AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
 == Description ==

@@ Line 7: / Line 7: @@
 == Description ==
-AVERAGEA(n1, n2, .....)
+AVERAGEA()
 *Arithmetic mean is the sum of values divided by the number of values.

@@ Line 1: / Line 1: @@
-=AVERAGEA(n1, n2, .....)=
+=AVERAGEA()=
-*where <math>n1, n2, .....</math> are values or range of cells containing values.
+*Parameters are values or range of cells containing values.
 AVERAGEA() calculates the average (arithmetic mean) of the given values.
@@ Line 10: / Line 10: @@
 *Arithmetic mean is the sum of values divided by the number of values.
-*Argument <math>n1, n2, .....</math> can be numbers, names, arrays, or range of cells containing numbers, logical values etc.
+*Arguments can be numbers, names, arrays, or range of cells containing numbers, logical values etc.
 *If logical values and text representation of numbers is entered directly as a part of argument, it is counted.
 *Logical value TRUE is evaluated as 1 and logical value FALSE is evaluated as 0.
@@ Line 19: / Line 19: @@
 ==ZOS==
-*The syntax is to calculate AVERAGEA in ZOS is <math>AVERAGEA(n_1,n_2,n_3,...)</math>.
+*The syntax is to calculate AVERAGEA in ZOS is <math>AVERAGEA()</math>.
-**<math>n_1,n_2,n_3...</math> are any  numbers,including  text, and logical values.
+**Parameters are any  numbers,including  text, and logical values.
 *For e.g.,AVERAGEA(20..35,TRUE)
 *AVERAGEA(-100..-75,FALSE)

@@ Line 61: / Line 61: @@
   =AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0. <br />Returns '''10''' as a result.
   =AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored. <br />Returns '''10''' as a result.
-  =AVERAGEA(4,6,TRUE) : Calculates the average of numbers and logical value TRUE (1). <br />Returns '''3.3333333333333335''' as a result.
+  =AVERAGEA(4,6,TRUE) : Calculates the average of numbers and logical value TRUE (1). <br />Returns '''3.6666666666666665''' as a result.
 ==Related Videos==

← Older revision		Revision as of 05:38, 13 March 2017
Line 75:		Line 75:
	*[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean]		*[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean]

		+	*[[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 10:57, 9 March 2017
Line 74:		Line 74:
	*[http://en.wikipedia.org/wiki/Average#Arithmetic_mean Average]		*[http://en.wikipedia.org/wiki/Average#Arithmetic_mean Average]
	*[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean]		*[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean]
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 16: / Line 16: @@
 *For invalid argument values, Calci displays error message.
 *AVERAGE() function can be used if arguments do not contain text or logical values.
 == Examples ==