The PERCENTILE function in Excel is a compatibility function that returns the exclusive percentile of a dataset.
It is recommended to use PERCENTILE.EXC or PERCENTILE.INC for more clarity.
Formula dasar PERCENTILE
=PERCENTILE(array, k)Hasil/Output penggunaan rumus PERCENTILE
Hasilnya berupa angka yakni: Exclusive percentile
Penjelasan dari contoh rumus PERCENTILE
- The PERCENTILE function takes an array of values and a percentile (k) and returns the exclusive percentile value.
- It is recommended to use PERCENTILE.EXC or PERCENTILE.INC for more clarity and specificity.
Kesimpulan
PERCENTILE is provided for backward compatibility; however, it is advisable to use PERCENTILE.EXC or PERCENTILE.INC for better understanding.
PERCENTILE
The PERCENTILE function in Excel is a compatibility function that returns the exclusive percentile of a dataset.
ahliexcel.com - Kompatibilitas