Difference between revisions of "Manuals/calci/Average, AverageA, AverageX Example"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
| − | <div style="font-size:24px">''' | + | <div style="font-size:24px">'''AVERAGE()'''</div> |
*Parameters are values or range of cells containing values. | *Parameters are values or range of cells containing values. | ||
| − | * | + | *AVERAGE() returns the average (arithmetic mean) of all the numbers in a column.<br></br> |
<div style="font-size:16px">'''NOTE:'''</div> | <div style="font-size:16px">'''NOTE:'''</div> | ||
| Line 31: | Line 31: | ||
*Cells with the value zero are included. | *Cells with the value zero are included. | ||
*If Data type is Integer/ Numeric/ Decimal, Average skip the null value. | *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> | ||
| + | |||
| + | |||
| + | <div style="font-size:24px">'''AVERAGEA()'''</div> | ||
| + | *Parameters are values or range of cells containing values. | ||
| + | *AVERAGEA() returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.<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: | ||
| + | |||
| + | *It support Logical values. | ||
| + | *Logical value TRUE count as 1 & FALSE count as 0 (zero). | ||
| + | *Values that contain non-numeric text count as 0 (zero). | ||
| + | *Empty text (“”) counts as 0 (zero). | ||
'''AVERAGE(A2:A5) = 2.5<br> | '''AVERAGE(A2:A5) = 2.5<br> | ||
'''AVERAGE(B2:B5) = 1333.33<br></br> | '''AVERAGE(B2:B5) = 1333.33<br></br> | ||
Revision as of 20:04, 19 September 2021
DATA
| A | B | C | D | |||
|---|---|---|---|---|---|---|
| 1 | ID | Amount | Blank | Boolean | SalesDate | Name |
| 2 | 1 | TRUE | 29/5/2020 | A | ||
| 3 | 2 | 1000 | FALSE | B | ||
| 4 | 3 | 2000 | TRUE | 29/5/2020 | ||
| 5 | 4 | 1000 | FALSE | 28/5/2020 | C |
AVERAGE()
- Parameters are values or range of cells containing values.
- AVERAGE() returns the average (arithmetic mean) of all the numbers in a column.
NOTE:
- 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.
- Cells with the value zero are included.
- If Data type is Integer/ Numeric/ Decimal, Average skip the null value.
AVERAGE(A2:A5) = 2.5
AVERAGE(B2:B5) = 1333.33
AVERAGEA()
- Parameters are values or range of cells containing values.
- AVERAGEA() returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.
NOTE:
- 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).
- Values that contain non-numeric text count as 0 (zero).
- Empty text (“”) counts as 0 (zero).
AVERAGE(A2:A5) = 2.5
AVERAGE(B2:B5) = 1333.33