Manuals/calci/GEOMEAN - Revision history

Devika: /* Examples */

2020-08-12T10:01:22Z

Examples

2018-08-07T22:15:40Z

2018-06-06T18:42:15Z

2018-02-26T21:03:53Z

ZOS

2017-03-13T06:06:36Z

2017-03-09T11:18:11Z

2015-06-07T19:27:40Z

2015-06-03T16:00:42Z

ZOS Section

2015-03-30T05:23:49Z

Examples

2014-06-27T10:14:09Z

ZOS Section

@@ Line 31: / Line 31: @@
 #=GEOMEAN(2,4,8) = 3.9999999999999996
 #=GEOMEAN(3,5,8,10,12) = 6.786916380543178
-#=GEOMEAN(-2,32) = #ERROR, because the value is < 0.
+#=GEOMEAN(-2,32) = #N/A (NUMBER > 0 REQUIRED)
 ==Related Videos==

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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''GEOMEAN(n1,n2,…)'''</div><br/>
+<div style="font-size:30px">'''GEOMEAN()'''</div><br/>
-*<math>n1,n2...</math> are the positive real numbers.
+*Parameters are any set of  positive real numbers.
 ==Description==
@@ Line 8: / Line 8: @@
 *The Geometric Mean of the three numbers is, the cube root of their product.
 *So the geometric mean of <math>n</math> numbers is defined as the <math>n^{th}</math> root of the product of the numbers.
-*In <math>GEOMEAN(n1,n2...)</math>, <math>n1,n2...</math> are the positive real numbers and <math>n1</math> is required. <math>n2,n3...</math> are optional.
+*In <math>GEOMEAN()</math>, Parameters are any set of positive real numbers and first parameter is required. From second parameters are optional.
 *The  arguments  can be numbers,names,arrays or references that contain numbers.
 *Also we can directly use logical values and text representations of numbers.
@@ Line 21: / Line 21: @@
 ==ZOS==
-*The syntax is to calculate GEOMEAN in ZOS is <math>GEOMEAN(n1,n2,...)</math>.
+*The syntax is to calculate GEOMEAN in ZOS is <math>GEOMEAN()</math>.
-**<math>n1,n2...</math> are the positive real numbers.
+**Parameters are any set of positive real numbers.
 *For e.g.,GEOMEAN(1,2,3,4,5),GEOMEAN(11.5..20.5..0.5)
 {{#ev:youtube|me2sEpY6LD4|280|center|Geometric Mean}}

@@ Line 23: / Line 23: @@
 *The syntax is to calculate GEOMEAN in ZOS is <math>GEOMEAN(n1,n2,...)</math>.
 **<math>n1,n2...</math> are the positive real numbers.
-*For e.g.,geomean(1,2,3,4,5),geomean(11.5..20.5..0.5)
+*For e.g.,GEOMEAN(1,2,3,4,5),GEOMEAN(11.5..20.5..0.5)
 {{#ev:youtube|me2sEpY6LD4|280|center|Geometric Mean}}

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


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

@@ Line 20: / Line 20: @@
 .Any one of the references cannot be translated in to numbers.
-==ZOS Section==
+==ZOS==
 *The syntax is to calculate GEOMEAN in ZOS is <math>GEOMEAN(n1,n2,...)</math>.
 **<math>n1,n2...</math> are the positive real numbers.

@@ Line 28: / Line 28: @@
 ==Examples==
 #=GEOMEAN(3,27) = 9
-#=GEOMEAN(2,4,8) = 4
+#=GEOMEAN(2,4,8) = 3.9999999999999996
 #=GEOMEAN(3,5,8,10,12) = 6.786916380543178
-#=GEOMEAN(-2,32) = NAN, because the value is < 0.
+#=GEOMEAN(-2,32) = #ERROR, because the value is < 0.
 ==See Also==