The PERCENTILE.INC function in Excel returns the inclusive percentile of a dataset.
It helps identify the value below which or equal to a given percentage of observations fall.
Formula dasar PERCENTILE.INC
=PERCENTILE.INC(array, k)Hasil/Output penggunaan rumus PERCENTILE.INC
Hasilnya berupa angka yakni: Inclusive percentile
Penjelasan dari contoh rumus PERCENTILE.INC
- The PERCENTILE.INC function takes an array of values and a percentile (k) and returns the inclusive percentile value.
- It is useful for analyzing data distribution and identifying key data points.
Kesimpulan
PERCENTILE.INC is commonly used in statistical analysis and data interpretation.
PERCENTILE.INC
The PERCENTILE.INC function in Excel returns the inclusive percentile of a dataset.
ahliexcel.com - Statistik