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 
List of positive and negative numbers
Computing for the Mean

Compute for 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 
Grouping 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 
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 
3 
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 
1,000.00 
4.55 
Results per field