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