Difference between revisions of "Manuals/calci/AVERAGE"

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">''' <font size="3"><font face="Times New Roman">'''AVERAGE''' (A1, A2...)</fo...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">'''AVERAGE''' (A1, A2...)</font></font> <font size="3"><font face="Times New Roman">A1, A2 ...   are positive integers.</font></font> '''</font></font></div>
+
<div style="font-size:30px">'''AVERAGE(n1,n2,n3)'''</div><br/>
----
 
<div id="1SpaceContent" class="zcontent" align="left">
 
  
AVERAGE is a function that calculates the average (arithmetic mean) of the arguments.
+
*Where N1,N2,N3 .... are any real numbers.  
  
</div>
+
==Description==
----
+
*This function gives the Average for given set numbers.
<div id="7SpaceContent" class="zcontent" align="left">
+
*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 ai,
 +
*where i=1 to n, then A.M= 1/n Summation i=1 to n (ai)= 1/n(a1+a2+.....+an).
 +
*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.
 +
*Also if the distribution is symmetric, then we can use this function to find the central tendency.
 +
*The three most common measures of central tendency are: A.M, Median,& Mode.A.M: 
 +
*It is calculating by adding the given set of numbers and divided by the count of the given set of  numbers. *E.g:Average of 2,4,2,7,2,3 and 5 is 3.6
 +
*Median: It is the middle number of a sorted list(Ascending order) of numbers.
 +
*E.g:The median of 2,2,2,3,4,5,7 is 3
 +
*Mode: It is the most frequently  repeated number in a given set of numbers.
 +
*E.g.The mode of 2,2,2,3,4,5 and 7 is 2
  
<font size="3">·</font>        <font size="3"><font face="Times New Roman">Arguments can be numbers, names, arrays, or references. </font></font>
+
==Examples==
  
<font size="3">·</font>        <font size="3"><font face="Times New Roman">Logical values and text representations of numbers are calculated. </font></font>
+
*AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125
  
</div>
+
*AVERAGE(5,-2,7,8,11,20,25,-9)=8.125
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">AVERAGE </div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left">
 
  
Let’s see an example
+
==See Also==
  
AVERAGE (A1, A2…….)
+
*[[Manuals/calci/AVEDEV  | AVEDEV ]]
 +
*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
  
''' '''B
 
  
12
+
==References==
 
+
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
16
 
 
 
5
 
 
 
18
 
 
 
<nowiki>=AVERAGE (B2:B5) is 12.75</nowiki>
 
 
 
<nowiki>=AVERAGE (B2:B5,4) is 11 </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="odd"
 
| class=" " | Row1
 
| class="sshl_f" | 12
 
| class="sshl_f" | 12.75
 
| class="sshl_f" |
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f  " | 16
 
| class="sshl_f" | 11
 
| class="sshl_f" |
 
|- class="odd"
 
| Row3
 
| class="sshl_f" | 5
 
| class="SelectTD" |
 
| class="sshl_f" |
 
|- class="even"
 
| Row4
 
| class=" " | 18
 
| class="sshl_f" |
 
|
 
|- class="odd"
 
| class="sshl_f" | Row5
 
| class="sshl_f" |
 
| class="  " |
 
|
 
|- class="even"
 
| class=" " | Row6
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|}
 
 
 
<div align="left"></div>''''''</div></div>
 
----
 

Revision as of 04:37, 19 November 2013

AVERAGE(n1,n2,n3)


  • Where N1,N2,N3 .... are any 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 ai,
  • where i=1 to n, then A.M= 1/n Summation i=1 to n (ai)= 1/n(a1+a2+.....+an).
  • 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.
  • Also if the distribution is symmetric, then we can use this function to find the central tendency.
  • The three most common measures of central tendency are: A.M, Median,& Mode.A.M:
  • It is calculating by adding the given set of numbers and divided by the count of the given set of numbers. *E.g:Average of 2,4,2,7,2,3 and 5 is 3.6
  • Median: It is the middle number of a sorted list(Ascending order) of numbers.
  • E.g:The median of 2,2,2,3,4,5,7 is 3
  • Mode: It is the most frequently repeated number in a given set of numbers.
  • E.g.The mode of 2,2,2,3,4,5 and 7 is 2

Examples

  • AVERAGE( 2, 3, 11, 13, 17, 26, 34, 47)=19.125
  • AVERAGE(5,-2,7,8,11,20,25,-9)=8.125

See Also


References

Complex Numbers