Altair® Panopticon

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

1. Compute for the sum of the values.

3 + 2 + 1 + 0 + -1 + -2 + -3 + 0 + 0 = 0

1. 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