The mode is used to indicate the location of the center of a population. The mode is not an indicator of the frequency of the score that occurs most often, but rather the actual value of the score.
|
V1 |
V2 |
V3 |
V4 |
V5 |
V6 |
|
5 |
25 |
2 |
7 |
25 |
30 |
With a resultset of the following six values (v1, v2, v3, v4, v5, v6), the mode would be the 25, because it occurs the most number of times.
|
V1 |
V2 |
V3 |
V4 |
V5 |
V6 |
|
5 |
25 |
8 |
7 |
25 |
8 |
In the above example, the Mode would be NULL, because there is more than one value that repeats at the highest frequency (both 25 and 8 repeat twice). This is called a "multi-modal" population.
value_exp can be an expression of any SQL data type.