Manuals/calci/Average, AverageA, AverageX Example - Revision history

Joseph at 19:51, 19 October 2021

2021-10-19T19:51:07Z

2021-09-20T01:20:17Z

2021-09-20T01:08:32Z

2021-09-20T01:08:16Z

2021-09-20T01:07:05Z

2021-09-20T01:04:51Z

2021-09-20T01:02:01Z

2021-09-20T01:01:38Z

2021-09-20T01:01:22Z

2021-09-20T01:01:08Z

@@ Line 54: / Line 54: @@
 <div style="font-size:16px">'''NOTE:'''</div>
-The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
+The AVERAGEX function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
 *The function takes a table as its first argument, and an expression as the second argument.
@@ Line 61: / Line 61: @@
 *When there are no rows to aggregate, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
 *Does not support Logical/ boolean values.
-'''AVERAGEA(A2:A5) = 2.5<br>
+'''AVERAGEX(A2:A5) = 2.5<br>

← Older revision		Revision as of 01:20, 20 September 2021
Line 48:		Line 48:
	'''AVERAGEA(B2:B5) = 1333.33<br>		'''AVERAGEA(B2:B5) = 1333.33<br>
	'''AVERAGEA(D2:D5) = 0.5<br></br>		'''AVERAGEA(D2:D5) = 0.5<br></br>
		+
		+
		+	<div style="font-size:24px">'''AVERAGEX()'''</div>
		+	*AVERAGEX() calculates the average (arithmetic mean) of a set of expressions evaluated over a table.<br></br>
		+
		+	<div style="font-size:16px">'''NOTE:'''</div>
		+	The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
		+
		+	*The function takes a table as its first argument, and an expression as the second argument.
		+	*The AVERAGEX function enables you to evaluate expressions for each row of a table, and then take the resulting set of values and calculate its arithmetic mean.
		+	*You cannot include non-numeric or null cells. Both the table and expression arguments are required.
		+	*When there are no rows to aggregate, the function returns a blank. When there are rows, but none of them meet the specified criteria, then the function returns 0.
		+	*Does not support Logical/ boolean values.
		+	'''AVERAGEA(A2:A5) = 2.5<br>

@@ Line 44: / Line 44: @@
 *Logical value TRUE counts as 1 &  FALSE counts as 0.
 *Values that contain non-numeric text count as 0.
-*Empty text ("") counts as 0.
+*Empty text (" ") counts as 0.
 '''AVERAGEA(A2:A5) = 2.5<br>
 '''AVERAGEA(B2:B5) = 1333.33<br>
 '''AVERAGEA(D2:D5) = 0.5<br></br>

@@ Line 39: / Line 39: @@
 <div style="font-size:16px">'''NOTE:'''</div>
-* The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
+The AVERAGEA function takes a column and averages the numbers, but also handles non-numeric data types according to the following rules:
 *It support Logical values.
-*Logical value TRUE count as 1 &  FALSE count as 0 (zero).
+*Logical value TRUE counts as 1 &  FALSE counts as 0.
-*Values that contain non-numeric text count as 0 (zero).
+*Values that contain non-numeric text count as 0.
-*Empty text (“”) counts as 0 (zero).
+*Empty text ("") counts as 0.
 '''AVERAGEA(A2:A5) = 2.5<br>
 '''AVERAGEA(B2:B5) = 1333.33<br>
 '''AVERAGEA(D2:D5) = 0.5<br></br>

@@ Line 3: / Line 3: @@
 {| class="wikitable"
 |-
-! !! A !! B !!C !!D
+! !! A !! B !!C !!D !! E !! F
 |-
 ! 1
@@ Line 36: / Line 36: @@
 <div style="font-size:24px">'''AVERAGEA()'''</div>
 *AVERAGEA() returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.<br></br>
@@ Line 46: / Line 45: @@
 *Values that contain non-numeric text count as 0 (zero).
 *Empty text (“”) counts as 0 (zero).
-'''AVERAGE(A2:A5) = 2.5<br>
+'''AVERAGEA(A2:A5) = 2.5<br>
-'''AVERAGE(B2:B5) = 1333.33<br></br>
+'''AVERAGEA(B2:B5) = 1333.33<br>

@@ Line 22: / Line 22: @@
-<div style="font-size:24px">'''AVERAGEA()'''</div>
+<div style="font-size:24px">'''AVERAGE()'''</div>
 *Parameters are values or range of cells containing values.
-*AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.<br></br>
+*AVERAGE() returns the average (arithmetic mean) of all the numbers in a column.<br></br>
 <div style="font-size:16px">'''NOTE:'''</div>
@@ Line 31: / Line 31: @@
 *Cells with the value zero are included.
 *If Data type is Integer/ Numeric/ Decimal, Average skip the null value.
 '''AVERAGE(A2:A5) = 2.5<br>
 '''AVERAGE(B2:B5) = 1333.33<br></br>

@@ Line 26: / Line 26: @@
 *AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.<br>
-<div style="font-size:20px">'''NOTE:'''</div>
+<div style="font-size:16px">'''NOTE:'''</div>
 *This function takes the specified column as an argument and finds the average of the values in that column.
 *Does not support Logical and Text Values.