Indlela yokufumana iMedian (Umyinge) kwi-Excel

Ukusebenzisa Umsebenzi weMEDIAN kwi-Microsoft Excel

Isibalo seMathematika, kukho iindlela ezininzi zokulinganisa ukutyekela okuphakathi okanye, njengoko kuthethwa ngokuqhelekileyo, umyinge weesethi zexabiso . Umyinge ophakathi kwinqanaba okanye emkhatsini weqela lamanani kwinani lokusabalalisa.

Kwimeko ye-median, yinani eliphakathi kwinqanaba lamanani. Isiqingatha manani axabisekileyo awona mkhulu, kwaye isiqingatha seenombolo zixabisekileyo ezingaphantsi komlambo. Umzekelo, umlambo kwinqanaba "2, 3, 4, 5, 6" ngu-4.

Ukwenza kube lula ukulinganisa ukutyekela kwe-central, i-Excel inemisebenzi embalwa eya kubala ixabiso eliqhelekileyo elisetyenziswa ngokuqhelekileyo:

• Umsebenzi waseMediya: Ufumanisa ixabiso eliphakathi okanye eliphakathi kwoluhlu lwamanani
• Umsebenzi WENKCAZELO : Ufumana i- arithmetic kuthetha ukuthatha uluhlu lwamanani
• Umsebenzi weMODE : Ufumana imodi okanye ubuninzi bexabiso eliqhelekileyo kwiluhlu lwamanani

Indlela umsebenzi weMediya usebenza ngayo

Umsebenzi we-MEDIA uhamba ngeengxoxo ezibonelelwe ukufumana ixabiso eliwela ngokukhawuleza phakathi kweqela.

Ukuba inani elingaqhelekileyo leengxabano linikezelwa, umsebenzi uchonga inani eliphakathi phakathi kwoluhlu njengexabiso eliphakathi.

Ukuba kukho inani leengxabano ezinikezelwayo, umsebenzi uthatha i-arithmetic ithetha okanye umyinge wexabiso eliphakathi emibini njengexabiso eliphakathi.

Qaphela : Iimpawu ezinikezelwa njengeengxoxo azidingeki ukuba zihlelwe kuyo nayiphi na into efanelekileyo ukuze umsebenzi usebenze. Uyabona ukuba ekudlaleni kumqolo wesine kumzekelo ongezantsi.

Umsebenzi waseMediya

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.

Le yile syntax yomsebenzi we-MEDIA:

= UMEDIAN ( Inombolo1 , Inombolo2 , Inombolo3 , ... )

• = IMPILO : Yile ndlela zonke iindlela zeMEDIAN zifuna ukuqala, ngoko oku akunako ukutshintshwa.
• Inombolo1: Idatha efunekayo ukuba ihlawulwe ngumsebenzi
• Inani2 : Iimpawu zengcaciso ezongezelelweyo ezongezelelweyo zifakwe kumyinge. Inani eliphezulu lokungeniswa livunyelwe ngu-255, elowo lifuna ukuba lihlukaniswe yi-comma.

Le ngxabano ingaquletheka:

• uluhlu lweenombolo eziza kubalwa
• izikhokelo zeseli kwindawo yendawo kwiphepha lokusebenzela
• uluhlu lweenkcukacha zeeseli
• uluhlu olukhethiweyo

Izinketho zokungena emsebenzini kunye neengxoxo zayo:

• Ukuthayipha umsebenzi opheleleyo, njenge = MEDIAN (A2: F2) , kwifayile yeshidi
• Ukufaka umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi

Umsebenzi weMediya Umzekelo

Ezi nyathelo iinkcukacha zokungena kumsebenzi weMEDIAN kunye neengxabano usebenzisa ibhokisi yencoko yomzekelo wokuqala oboniswe kulo mfanekiso:

1. Cofa kwiseli G2. Le yindawo apho iziphumo ziza kuboniswa khona.
2. Jonga kwiifomula> Imisebenzi engakumbi> Imenyu yemenyu yesitatimende ukukhetha iMEDIAN ukusuka kwoluhlu.
3. Kwibhokisi yokuqala yombhokisi kwibhokisi yencoko, qinisa iiseli A2 ukuya kwiF2 kwiphepha lokusebenzela ukuze ufake ngokuzenzekelayo eloluhlu.
4. Cofa Kulungile ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela.
5. Impendulo 20 ifanele ivele kwiseli G2
6. Ukuba ucofa kwi-cell G2, umsebenzi opheleleyo, = UMEDIAN (A2: F2) , uvela kwibha yefomula ngaphezu kwephepha lokusebenzela.

Kutheni ixabiso eliphakathi kwama-20? Ngomzekelo wokuqala kumfanekiso, kuba kunenani elingavumelekanga leengxabano (ezintlanu), ixabiso eliphakathi libalwe ngokufumana inombolo ephakathi. Kuyi-20 apha kuba kukho iinombolo ezimbini ezinkulu (49 no-65) kunye namanani amancinci (4 no-12).

Iisalathisi ezingenanto ngeZero

Xa kuziwa ekufumaneni i-median kwi-Excel, kukho umehluko phakathi kweenqunu ezingenanto okanye ezingenanto kunye nalabo abanexabiso lentengo.

Njengoko kuboniswe kwimimiselo engentla, iiseli ezingenanto zingagcinwa ngumsebenzi weMEDIAN kodwa kungekhona ezo zinto ezinexabiso lexabiso.

• Utshintsho lwangaphakathi phakathi kwemizekelo yokuqala neyesibini kuba i-zero yongezwa kwiseli A3 ngelixa i-cell A2 ingenanto.
• Ukongezwa kwe-zero kwi-cell A3 kutshintsha inani leengxabano ezidluliselwe kumsebenzi kwi-cell G3 ukususela ezintlanu ukuya ezintandathu-kunye nenani. Ngenxa yoko, i-median ibalwa ngokufaka ixabiso eliphakathi (12 no-20) kunye kunye nokwahlula kabini ukufumana umyinge wabo (16).

Ngokungagqibekanga, i-Excel ibonisa i-zero (0) kwiiseli ezinenani elixabisekileyo - njengoko kuboniswe kumzekelo ongentla. Olu khetho lunokucinywa kwaye, xa lwenziwa, loo maseli ashiywe engagqibekanga, kodwa ixabiso lexabiso lelo lisele lisabandakanywa njengengxabano yomsebenzi xa ubala i-median.

Nantsi indlela yokuguqula olu khetho kwaye ukhupha:

1. Hamba kwiFayile> Imenyu yeenketho (okanye i- Excel Options kwiinguqu ezidala ze-Excel).
2. Yiya kwinqanaba eliphambili ukusuka kwikhompini yesobunxele yezinketho.
3. Ngakwesokudla, skrolela phantsi uze ufumane "Iindlela zokubonisa kule candelo".
4. Ukufihla ubuncinci bezisele kwiiseli, cima i- Show zero kwiiseli ezinenani elifanelekileyo . Ukubonisa i-zeros, faka isheke kwibhokisi.
5. Gcina nayiphi na utshintsho ngeqhosha le- OK .