|
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
Steps:
1. Compute the sum of the values.
3 + 2 + 1 + 0 + -1 + -2 + -3 + 0 + 0 = 0
2. 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 |
Groupings of numbers
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 resulting table
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.