Mean
The mean of the selection.
Returns the average of a given set of numbers.
The mean is the sum of all the values in a set of numbers, divided by the number of values.
Sample 1
Given a list of arbitrary numbers:
| Arbitrary |
| 3 |
| 2 |
| 1 |
| 0 |
| -1 |
| -2 |
| -3 |
| 0 |
| 0 |
| 0 |
A list of positive and negative numbers
- Compute the sum of the values.
3 + 2 + 1 + 0 + -1 + -2 + -3 + 0 + 0 = 0
- Divide it by the number of values.
0/10 = 0
Sample 2
Assuming that the same list of numbers has multiple groupings or breakdowns as shown below:
| Grouping | Arbitrary |
| 1 | 3 |
| 1 | 2 |
| 1 | 1 |
| 1 | 0 |
| 2 | -1 |
| 2 | -2 |
| 2 | -3 |
| 3 | 0 |
| 3 | 0 |
| 3 | 0 |
The list of values with groupings
Computing for the mean of the Arbitrary field based on the Grouping field will result in the table below:
| Grouping | Arbitrary |
| 1 | 2 |
| 2 | -2 |
| 3 | 0 |
The final result
Computation Details:
Group 1: 3 + 2 + 1 + 0 = 6/4 = 1.5
Group 2: -1 + -2 + -3 = -6/3 = -2
Group 3: 0 + 0 + 0 = 0/3 = 0
Sample 3
Given the following sample fields:
| Number | Arbitrary | Negative Values | Positive Values | One | Binary | Currency | Decimal |
| 1 | 3 | -1 | 1 | 1 | 0 | $1.00 | 1.01 |
| 2 | 2 | -2 | 2 | 1 | $10.00 | 2.02 | |
| 3 | 1 | -3 | 3 | 0 | $100.00 | 3.03 | |
| 4 | 0 | -4 | 4 | 1 | $1,000.00 | 4.04 | |
| 5 | -1 | -5 | 5 | 0 | $10,000.00 | 5.05 | |
| 6 | -2 | -6 | 6 | 1 | -$1.00 | 6.06 | |
| 7 | -3 | -7 | 7 | 0 | -$10.00 | 7.07 | |
| 8 | 0 | -8 | 8 | -$100.00 | 8.08 | ||
| 9 | 0 | -9 | 9 | -$1,000.00 | 9.09 | ||
| 10 | 0 | -10 | 0 | $0.00 | 0.00 |
Sample fields
Mean results:
| Number | Arbitrary | Negative Values | Positive Values | One | Binary | Currency | Decimal |
| 6 | 0 | -6 | 5 | 1 | 0 | 1000.00 | 4.55 |
The results per field
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.