This function returns the number of unique values that cause a population to be multimodal. In other words, this function only returns results if the population is multimodal. If the population is not multimodal, this function returns 0.
|
V1 |
V2 |
V3 |
V4 |
V5 |
V6 |
|
5 |
25 |
2 |
25 |
25 |
30 |
With a resultset of the following six values (v1, v2, v3, v4, v5, v6), the multimodalcount would be the 0, because the population is not multimodal (there is a single mode, 25).
|
V1 |
V2 |
V3 |
V4 |
V5 |
V6 |
|
5 |
25 |
8 |
7 |
25 |
8 |
In the above example, the multimodalcount would be 2, because the population is multimodal, and the number of unique values that make the population multimodal is two (8 and 25).
value_exp can be an expression of any SQL data type.