Indlela Yokuthola i-Median (Isilinganiso) ku-Excel

Ukusebenzisa umsebenzi we-MEDIAN ku-Microsoft Excel

Ngokwezibalo, kunezindlela eziningi zokukala ukuthambekela okuphakathi noma, njengoba kubizwa ngokuvamile, isilinganiso sesethi yamanani . Isilinganiso sibe yisikhungo noma esiphakathi kweqembu lezinombolo ekusakazeni izibalo.

Endabeni yomphakathi, yinombolo ephakathi eqenjini lezinombolo. Isiqingatha izinombolo zinamanani amakhulu kunomphakathi, futhi isigamu samanani anamanani angaphansi kwamaphakathi. Isibonelo, umlingani webanga "2, 3, 4, 5, 6" ngu-4.

Ukuze kube lula ukukala ukuthambekela okuphakathi, i-Excel inemisebenzi eminingi ezobala amanani ajwayelekile avamile asetshenziswe:

• Umsebenzi we-MEDIAN: Uthola inani eliphakathi noma eliphakathi ohlwini lwamanani
• Umsebenzi WOKUPHAKATHI : Uthola isichazamazwi sisho uhlu lwamanani
• Umsebenzi we- MODE : Uthola imodi noma iningi elivame ukwenzeka ohlwini lwamanani

Indlela umsebenzi waseMediya osebenza ngayo

Umsebenzi we-MEDIAN uhamba ngezimpikiswano ezihlinzekwe ukuthola inani eliwela phansi ngokweqile phakathi kweqembu.

Uma inamba engavamile yeziphakamiso zinikezwa, lo msebenzi uveza inani eliphakathi phakathi kobubanzi njengenani eliphakathi.

Uma kunesibalo esiphezulu sezingxabano ezinikezwayo, umsebenzi uthatha isichazamazwi kusho noma isilinganiso semikhakha emibili ephakathi njengenani eliphakathi.

Qaphela : Amagugu anikezwa njengama-arguments akudingeki ahlelwe kunoma yimuphi umyalelo ukuze umsebenzi usebenze. Ungabona ukuthi ekudlaleni emgqeni wesine kusibonelo esingezansi.

I-MEDIAN Function Syntax

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.

Leli yi-syntax yomsebenzi we-MEDIAN:

= I- MEDIAN ( Inombolo1 , Inombolo2 , Inombolo3 , ... )

• = I-MEDIAN : Yile ndlela zonke izindlela ze-MEDIAN zidinga ukuqala, ngakho-ke lokhu akukwazi ukuguqulwa.
• Inombolo1: Idatha edingekayo ukuze ibe nomsebenzi
• Inombolo2 : Amanani wedatha owengeziwe angakhethayo afakiwe phakathi. Inombolo ephezulu yokufaka okuvunyelwe yi-255, ngayinye yayo edinga ukuhlukaniswa ngomahlaya.

Le mpikiswano ingaqukatha:

• uhlu lwezinombolo ezingalinganiselwe
• amasetferensi weselula endaweni yedatha kushidi lokusebenzela
• ububanzi bezinkomba zocingo
• ibanga elibizwe

Izinketho zokufaka umsebenzi kanye neziphakamiso zayo:

• Ukuthayipha umsebenzi ophelele, njengo = MEDIAN (A2: F2) , kufinyelele esitokisini somsebenzi
• Ukufaka umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi

I-MEDIAN Function Isibonelo

Lezi zinyathelo zedatha ukuthi ungangena kanjani umsebenzi we-MEDIAN nezimpikiswano usebenzisa ibhokisi lengxoxo yesibonelo sokuqala esiboniswe kulesi sithombe:

1. Chofoza kuseli G2. Lona indawo lapho imiphumela izoboniswa khona.
2. Hamba kuya kumafomula> Imisebenzi eminingi> Into yemenyu yesitatimende ukuze ukhethe i- MEDIAN ohlwini.
3. Ebhokisini lokuqala lombhalo ebhokisini lebhokisi, qokomisa amaseli A2 kuya ku-F2 ekhasini lokusebenzela ukuze ufake ngokuzenzakalelayo lelo banga.
4. Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela.
5. Impendulo 20 kufanele ivele esitokisini G2
6. Uma uchofoza ku-cell G2, umsebenzi ophelele, = MEDIAN (A2: F2) , ivela kubha yamasombulu ngaphezu kwephepha lokusebenzela.

Kungani kubaluleka okungama-20? Ngesibonelo sokuqala esithombeni, njengoba kunombhalo ongaqondakali wezingxabano (ezinhlanu), inani lokulinganisa libalwe ngokuthola inombolo ephakathi. Kukhona lapha ngoba kunezinombolo ezimbili ezinkulu (49 no-65) nezinombolo ezimbili ezincane (4 no-12).

Amaseli angenalutho vs Zero

Uma kuziwa ekutholeni i-median ku-Excel, kunomehluko phakathi kwamangqamuzana angenalutho noma angenalutho nalabo abanesilinganiso senani.

Njengoba kuboniswe kulezi zibonelo ezingenhla, amangqamuzana angenalutho ayenganakwa umsebenzi we-MEDIAN kodwa hhayi lawo anesilinganiso senani.

• Izinguquko eziphakathi phakathi kwezibonelo zokuqala nezibili ngoba i-zero yanezelwa esitokisini A3 kanti iseli A2 ayinalutho.
• Ukwengezwa kwe-zero esitokisini se-A3 kushintsha inani lezingxabano ezidluliselwe emsebenzini ku-cell G3 kusuka ku-5 kuya kweyisithupha-ngisho nenombolo. Ngenxa yalokho, umlingani ubalwa ngokungeza amanani amabili aphakathi (12 no-20) ndawonye bese ehlukaniswa kabili ukuthola isilinganiso sabo (16).

Ngokuzenzakalelayo, i-Excel ibonisa i-zero (0) kumaseli ngenani le-zero - njengoba kuboniswe kusibonelo esingenhla. Lolu khetho lungavaliwe futhi, uma lwenziwa, lawa maseli ashiywanga lutho, kodwa inani le-zero lalo seli lisekhona njengengxabano yomsebenzi uma kubalwa umlingani.

Nakhu ukuthi ungayintsha kanjani le ndlela bese uyivala:

1. Hamba kufayela> Imenyu yezinketho (noma Izinketho ze-Excel ezinkathini ezidala ze-Excel).
2. Ngena esigabeni esithuthukile ukusuka kwikhompuyutha yesokunxele yezinketho.
3. Ngakwesokudla, skrolela phansi uze uthole "Izinketho zokubonisa zalesi sigaba sokusebenzela".
4. Ukufihla izindinganiso zama-zero kumaseli, cisha i- Show zero kumaseli ane-zero value hlola ibhokisi. Ukubonisa i-zeros, faka isheke ebhokisini.
5. Londoloza noma yiziphi izinguquko ngenkinobho OK .