Jifunze Excel PERCENTILE(): Pata Thamani ya Percentile Kwenye Data

Jifunze jinsi ya kutumia PERCENTILE() kwenye Excel kupata thamani ya percentile fulani ya dataset. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. PERCENTILE() Function

PERCENTILE() inarudisha value ya data ambayo ipo katika percentile fulani. Ni muhimu kwa statistical analysis, performance evaluation, na reporting.

Syntax:

PERCENTILE(array, k)


array = range ya numbers

k = percentile unayotaka (0 ≤ k ≤ 1)

Mfano: 0.25 → 25th percentile

0.5 → 50th percentile (median)

0.75 → 75th percentile

Kutoka Excel 2010+, unaweza pia kutumia PERCENTILE.INC() (inclusive) au PERCENTILE.EXC() (exclusive) kwa ulinganifu zaidi.

2. Mfano Rahisi
A
10
20
30
40
50

Formula: Pata 25th percentile

=PERCENTILE(A2:A6,0.25)


Result:
20

Median (50th percentile): =PERCENTILE(A2:A6,0.5) → 30

75th percentile: =PERCENTILE(A2:A6,0.75) → 40

3. PERCENTILE() Pamoja na FILTER()

Unaweza kupata percentile ya subset ya data kulingana na criteria:

Score Class
80 A
90 B
70 A
85 B

Formula: 25th percentile ya Class A

=PERCENTILE(FILTER(A2:A5,B2:B5="A"),0.25)


FILTER() inachuja scores za Class A tu

PERCENTILE() inapata value ya 25th percentile ya filtered data

4. Tips Muhimu

PERCENTILE() ni muhimu kwa performance evaluation, statistical reporting, na data analysis.

Pamoja na FILTER(), inawezesha conditional statistical analysis.

Kutumia PERCENTILE.INC() au PERCENTILE.EXC() kunapunguza mchanganyiko wa inclusive/exclusive datasets.

Inaweza kuunganishwa na QUARTILE(), SORT(), LARGE(), SMALL(), na RANK() kwa dashboards za data analysis.

Links Muhimu

Tazama tutorials zaidi za Excel: https://www.faulink.com

Download mifumo ya Excel bure: https://www.faulink.com/excel_mifumo.php

Msaada wa WhatsApp: https://wa.me/255693118509