Difference between revisions of "Manuals/calci/AVERAGEA"
Jump to navigation
Jump to search
| (10 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =AVERAGEA( | + | <div style="font-size:30px">'''AVERAGEA ()'''</div><br/> |
| − | * | + | *Parameters are values or range of cells containing values. |
| − | + | **AVERAGEA(), returns the average of its arguments, including numbers, text, and logical values. | |
| − | AVERAGEA() | ||
== Description == | == Description == | ||
| − | AVERAGEA( | + | AVERAGEA() |
*Arithmetic mean is the sum of values divided by the number of values. | *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. | *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. | *Logical value TRUE is evaluated as 1 and logical value FALSE is evaluated as 0. | ||
| Line 16: | Line 15: | ||
*For invalid argument values, Calci displays error message. | *For invalid argument values, Calci displays error message. | ||
*AVERAGE() function can be used if arguments do not contain text or logical values. | *AVERAGE() function can be used if arguments do not contain text or logical values. | ||
| + | |||
| + | ==ZOS== | ||
| + | |||
| + | *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) | ||
== Examples == | == Examples == | ||
| Line 54: | Line 60: | ||
=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: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(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, | + | =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== | ==See Also== | ||
| Line 63: | Line 73: | ||
*[http://en.wikipedia.org/wiki/Average#Arithmetic_mean Average] | *[http://en.wikipedia.org/wiki/Average#Arithmetic_mean Average] | ||
*[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean] | *[http://en.wikipedia.org/wiki/Arithmetic_mean Arithmetic Mean] | ||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15: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.