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