Jifunze Excel QUARTILE(): Pata Quartile Kwenye Data

Jifunze jinsi ya kutumia QUARTILE() kwenye Excel kupata quartile fulani ya data. Tazama tutorials zaidi, pakua mifumo ya Excel bure, na pata msaada wa WhatsApp.”

1. QUARTILE() Function

QUARTILE() inarudisha nth quartile kutoka kwenye range ya numbers. Ni muhimu kwa statistical analysis, data distribution, na reporting.

Syntax:

QUARTILE(array, quart)

array = range ya numbers

quart = nambari inayoonyesha quartile unayotaka:

0 → Minimum value

1 → First quartile (Q1)

2 → Median / Second quartile (Q2)

3 → Third quartile (Q3)

4 → Maximum value

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

2. Mfano Rahisi
A
10
20
30
40
50

Formula: Pata first quartile (Q1)

=QUARTILE(A2:A6,1)

Result:
20

Hii inarudisha value ya Q1 ya dataset

3. Median na Third Quartile

Median (Q2):

=QUARTILE(A2:A6,2)

Result: 30

Third Quartile (Q3):

=QUARTILE(A2:A6,3)

Result: 40

Minimum: =QUARTILE(A2:A6,0) → 10

Maximum: =QUARTILE(A2:A6,4) → 50

4. QUARTILE() Pamoja na FILTER()

Unaweza kupata quartile ya subset ya data kulingana na criteria:

Score Class
80 A
90 B
70 A
85 B

Formula: Quartile ya Class A

=QUARTILE(FILTER(A2:A5,B2:B5="A"),1)

FILTER() inachuja scores za Class A tu

QUARTILE() inapata Q1 ya filtered data

5. Tips Muhimu

QUARTILE() ni muhimu kwa data analysis, boxplots, na statistical reporting.

Pamoja na FILTER(), inawezesha conditional statistical analysis.

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

Inaweza kuunganishwa na SORT(), UNIQUE(), 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