Manuals/calci/AVG - Revision history

Devika: /* Examples */

2021-06-30T08:01:12Z

Examples

2018-11-27T20:29:41Z

Examples

2018-06-05T20:08:34Z

2017-03-13T05:57:59Z

2017-03-09T10:58:51Z

2016-11-21T20:04:04Z

Description

2016-11-21T19:53:14Z

Description

2016-11-21T19:52:33Z

Description

2016-11-21T19:51:47Z

Description

2016-11-21T19:47:34Z

@@ Line 14: / Line 14: @@
 #AVG(201..624) = 412.5
 # AVG(1000..34521) = 17760.5
 ==Related Videos==

@@ Line 14: / Line 14: @@
 #AVG(201..624) = 412.5
 # AVG(1000..34521) = 17760.5
 ==See Also==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''AVG(array)'''</div><br/>
+<div style="font-size:30px">'''AVG()'''</div><br/>
-*<math>array</math> are set of real numbers.
+*Parameters are any set of real numbers.
 ==Description==

← Older revision		Revision as of 05:57, 13 March 2017
Line 25:		Line 25:


−	[[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:58, 9 March 2017
Line 23:		Line 23:
	==References==		==References==
	[http://en.wikipedia.org/wiki/Average\| Average]		[http://en.wikipedia.org/wiki/Average\| Average]
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 20:04, 21 November 2016
Line 9:		Line 9:
	*In this function <math>array</math> are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.		*In this function <math>array</math> are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
	*This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.		*This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.
		+
		+	==Examples==
		+	#AVG(1,2,3,4,5,6,7,8,9,10) = 5.5
		+	#AVG(201..624) = 412.5
		+	# AVG(1000..34521) = 17760.5
		+
		+	==See Also==
		+
		+	*[[Manuals/calci/SUM \| SUM]]
		+	*[[Manuals/calci/AVERAGE \| AVERAGE ]]
		+	*[[Manuals/calci/AVERAGEA \| AVERAGEA ]]
		+
		+	==References==
		+	[http://en.wikipedia.org/wiki/Average\| Average]

@@ Line 7: / Line 7: @@
 *It is also called Arithmetic mean.
 *i.e.If n numbers are given and each number is denoted by <math>a_i</math>, where i=1 to n, then <math>A.M= \frac{1}{n} \sum_{i=1}^n  (a_i)= \frac{1}{n}(a_1+a_2+.....+a_n)</math>
-*In this function N1,N2,... are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
+*In this function <math>array</math> are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
 *This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.

@@ Line 6: / Line 6: @@
 *Average means sum of all the given elements is divided by Number of the given elements.
 *It is also called Arithmetic mean.
-*i.e.If n numbers are given and each number is denoted by <math>a_i</math>, where i=1 to n, then <math>A.M= 1/n sum_{i=1}^n  (a_i)= 1/n(a
+*i.e.If n numbers are given and each number is denoted by <math>a_i</math>, where i=1 to n, then <math>A.M= \frac{1}{n} \sum_{i=1}^n  (a_i)= \frac{1}{n}(a_1+a_2+.....+a_n).
-_1+a_2+.....+a_n). *In this function N1,N2,... are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
+*In this function N1,N2,... are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
 *This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.

← Older revision		Revision as of 19:47, 21 November 2016
Line 1:		Line 1:
−	==~~AVG~~==	+	<div style="font-size:30px">'''AVG(array)'''</div><br/>
		+	*<math>array</math> are set of real numbers.
		+
		+	==Description==
		+	*This function gives the Average for given set numbers.
		+	*Average means sum of all the given elements is divided by Number of the given elements.
		+	*It is also called Arithmetic mean.
		+	*i.e.If n numbers are given and each number is denoted by <math>a_i</math>, where i=1 to n, then <math>A.M= 1/n sum_{i=1}^n (a_i)= 1/n(a
		+	_1+a_2+.....+a_n). *In this function N1,N2,... are either it can be numbers,arrays ,references of cells or we can enter the logical values directly.
		+	*This function will show the result as Error ,when the numbers are error values or text that cannot change in to numbers.