Difference between revisions of "Manuals/calci/AVERAGEA"
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...") |
|||
| Line 1: | Line 1: | ||
| − | + | =AVERAGEA(n1, n2, .....)= | |
| − | < | + | *where <math>n1, n2, .....</math> are values or range of cells containing values. |
| − | + | AVERAGEA() calculates the average (arithmetic mean) of the mentioned values. | |
| − | + | == Description == | |
| − | |||
| − | |||
| − | + | AVERAGEA(n1, n2, .....) | |
| − | </ | + | *Arithmetic mean is the sum of values divided by the number of values. |
| − | + | *Argument <math>n1, n2, .....</math> 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. | ||
| − | + | == Examples == | |
| − | < | + | <div id="6SpaceContent" class="zcontent" align="left"> |
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | | class=" " | 20 | ||
| + | | class=" " | | ||
| − | + | |- class="odd" | |
| − | + | | class="sshl_f" |15 | |
| − | + | | class="sshl_f" | | |
| − | - | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |5 | |
| − | |||
| − | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" |10 | |
| − | | class="sshl_f" | | ||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" |Data | |
| − | | class="sshl_f " | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | + | ||
|- class="odd" | |- class="odd" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |||
|} | |} | ||
| − | + | =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.3333333333333335''' as a result. | ||
| + | |||
| + | ==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] | ||
Revision as of 17:37, 20 February 2014
AVERAGEA(n1, n2, .....)
- where are values or range of cells containing values.
are values or range of cells containing values.AVERAGEA() calculates the average (arithmetic mean) of the mentioned values.
Description
AVERAGEA(n1, n2, .....)
- Arithmetic mean is the sum of values divided by the number of values.
- Argument 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.
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.3333333333333335 as a result.