Formula Excel PERCENTRANK.EXC
statistik
The PERCENTRANK.EXC function in Excel returns the exclusive rank of a value in a dataset.
It indicates the percentage of values in the dataset that are less than the given value.
Formula dasar PERCENTRANK.EXC
=PERCENTRANK.EXC(array, x, [significance])
Hasil/Output penggunaan rumus PERCENTRANK.EXC
Hasilnya berupa angka yakni: Exclusive rank
Penjelasan dari contoh rumus PERCENTRANK.EXC
- The PERCENTRANK.EXC function takes an array of values, a specific value (x), and an optional significance parameter.
- It returns the exclusive rank of the value within the dataset.
Kesimpulan
PERCENTRANK.EXC is useful for assessing the relative standing of a value within a dataset in comparison to other values.