Difference between revisions of "Manuals/calci/AVERAGEA"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''AVERAGEA''' (A1, A2...)</font></font> <font size="3"><font face="Ti...")
 
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''AVERAGEA ()'''</div><br/>
  
−
<font size="3"><font face="Times New Roman">'''AVERAGEA''' (A1, A2...)</font></font>
+
*Parameters are values or range of cells containing values.
 +
**AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values.
  
−
<font size="3"><font face="Times New Roman">Where A1, A2... ranges of cells, or values.</font></font>
+
== Description ==
  
−
</div>
+
AVERAGEA()
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
<font size="3"><font face="Times New Roman">AVERAGEA is a function which calculates the average (arithmetic mean) of the values in the list of arguments. </font></font>
+
*Arithmetic mean is the sum of values divided by the number of values.
 +
*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.
 +
*Empty text ("") is ignored. Cells containing text are evaluated as 0.
 +
*For invalid argument values, Calci displays error message.
 +
*AVERAGE() function can be used if arguments do not contain text or logical values.
  
−
</div>
+
==ZOS==
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
<font size="3">·</font>        <font size="3"><font face="Times New Roman">Arguments can be numbers, names, arrays, or references. </font></font>
+
*The syntax is to calculate AVERAGEA in ZOS is <math>AVERAGEA()</math>.
 +
**Parameters are any  numbers,including  text, and logical values.
 +
*For e.g.,AVERAGEA(20..35,TRUE)
 +
*AVERAGEA(-100..-75,FALSE)
  
−
<font size="3">·</font>        <font size="3"><font face="Times New Roman">Logical values and text representations of numbers are calculated. </font></font>
+
== Examples ==
  
−
<font size="3">·</font>        <font size="3"><font face="Times New Roman">Arguments that contain TRUE evaluate as 1; and FALSE evaluate as 0 (zero). </font></font>
+
<div id="6SpaceContent" class="zcontent" align="left">
  
−
<font size="3" face="Times New Roman"> </font>
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class="  " | 20
 +
| class="  " |
  
−
</div>
+
|- class="odd"
−
----
+
| class="sshl_f" |15
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">AVERAGEA </div></div>
+
| class="sshl_f" |
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Let’s see an example
+
|- class="even"
 +
| class="sshl_f" |5
 +
| class="sshl_f" |
  
−
AVERAGEA (A1, A2……….)
+
|- class="odd"
−
 
+
| class="sshl_f" |10
−
B
+
| class="sshl_f" |
  
−
4
 
−
 
−
6
 
−
 
−
14
 
−
 
−
<nowiki>=AVERAGEA (B2:B4) is 8 </nowiki>
 
−
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left"><div>
 
−
 
−
{| id="TABLE1" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| class="            " | Column2
 
−
| class="    " | Column3
 
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
+
| class="sshl_f" |Data
−
| class="sshl_f " | 4
 
−
| class="sshl_f" | 8
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 +
 
|- class="odd"
 
|- class="odd"
−
| Row3
 
−
| class="sshl_f" | 6
 
−
| class="SelectTD" |
 
 
| class="sshl_f" |
 
| class="sshl_f" |
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f " | 14
 
 
| class="sshl_f" |
 
| class="sshl_f" |
−
|
+
 
−
|- class="odd"
 
−
| class="sshl_f" | Row5
 
−
|
 
−
| class="  " |
 
−
|
 
 
|- class="even"
 
|- class="even"
−
| class=" " | Row6
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
−
|
 
 
|}
 
|}
  
−
<div align="left"></div>''''''</div></div>
+
=AVERAGEA(A1:A4) : Calculates the average of numbers in the range A1 to A4. <br />Returns '''12.5''' as a result.
−
----
+
=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.6666666666666665''' as a result.
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|EFg7vh2WGk0|280|center|AVERAGEA}}
 +
 
 +
==See Also==
 +
 
 +
*[[Manuals/calci/AVERAGE | AVERAGE]]
 +
 
 +
==References==
 +
*[http://en.wikipedia.org/wiki/Average#Arithmetic_mean Average]
 +
*[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean]
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:17, 7 August 2018

AVERAGEA ()


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

Description

AVERAGEA()

  • Arithmetic mean is the sum of values divided by the number of values.
  • 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.
  • Empty text ("") is ignored. Cells containing text are evaluated as 0.
  • For invalid argument values, Calci displays error message.
  • AVERAGE() function can be used if arguments do not contain text or logical values.

ZOS

  • The syntax is to calculate AVERAGEA in ZOS is .
    • Parameters are any numbers,including text, and logical values.
  • For e.g.,AVERAGEA(20..35,TRUE)
  • AVERAGEA(-100..-75,FALSE)

Examples

20
15
5
10
Data 
=AVERAGEA(A1:A4) : Calculates the average of numbers in the range A1 to A4. 
Returns 12.5 as a result.
=AVERAGEA(A1:A5) : Calculates the average of numbers in the range A1 to A5. Text 'Data' is evaluated as 0. 
Returns 10 as a result.
=AVERAGEA(A1:A6) : Calculates the average of numbers in the range A1 to A6. Empty cell is ignored. 
Returns 10 as a result.
=AVERAGEA(4,6,TRUE) : Calculates the average of numbers and logical value TRUE (1). 
Returns 3.6666666666666665 as a result.

Related Videos

AVERAGEA

See Also

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/AVERAGEA&oldid=210915"