Ukuthola ukulinganisa okulinganiselwe ne-EXPL's AVERAGE Function

Sebenzisa umsebenzi we-AVERAGE ukuthola i-arithmetic kusho uhlu lwezinombolo

Ngokwezibalo, kunezindlela eziningi zokulinganisa ukuthambekela okuphakathi noma, njengoba kuvame ukubizwa ngokuthi, isilinganiso sesethi yamanani. Lezi zindlela zihlanganisa isichazamazwi sisho , i- median , nemodi .

Isilinganiso esivame ukubalwa ngaso sonke isikhathi sisho ukuthi i-arithmetic isho ukuthini - noma isilinganiso esilula - futhi kubalwa ngokungeza iqembu lezinombolo ndawonye bese uhlukanisa ngokubalwa kwalezo zinombolo. Isibonelo, isilinganiso esingu-2, 3, 3, 5, 7, no-10 ngu-30 sihlukaniswe ngu-6, okungu-5.

Ukuze kube lula ukukala ukuthambekela okuphakathi, i-Excel inemisebenzi eminingi ezobala amanani ajwayelekile ajwayelekile asetshenziselwa. Lokhu kufaka:

• Umsebenzi we-AVERAGE - uthola incazelo ye- arithmetic ohlwini lwamanani
• Umsebenzi we- MEDIAN - uthola inani eliphakathi noma eliphakathi ohlwini lwamanani
• Umsebenzi we- MODE - uthola imodi noma i-value evame kakhulu eyenzeka ohlwini lwamanani

I-Syntax Yesebenzayo ne-Arguments

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

I-syntax ye-AVERAGE umsebenzi yilezi:

= I-AVERAGE (Inombolo1, Inombolo2, ... Inamba255)

• Inombolo1 - (edingekayo) idatha ezobekwa umsebenzi.
• I-Number2 kuya Inombolo 255 - (okukhethwa kukho) amanani engeziwe wedatha afakiwe phakathi. Inombolo ephezulu yokufakwa okuvunyelwe yi-255.

Le mpikiswano ingaqukatha:

• Uhla lwezinombolo ezizobekwa;
• Izinkomba zeselula endaweni yedatha kushidi lokusebenzela;
• Uhla lwezinkomba ezigciniwe;
• Ibanga elibizwe.

Ukuthola umsebenzi we-AVERAGE

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele , njengokuthi = ISIGABA (C1: C7) kufinyelela kuseli lomsebenzi;
2. Ukufaka umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi;
3. Ukufaka umsebenzi nokuphikisana usebenzisa isinqamuleli somsebenzi we-Excel.

ISIKHATHI sesinqamuleli somsebenzi

I-Excel inezinqamuleli zokufaka umsebenzi we-AVERAGE - ngezinye izikhathi ubizwa ngokuthi i- AutoAverage ngenxa yokuhlangana kwayo nesici esaziwa kangcono se- AutoSum - esitholakala kuthebhu laseKhaya lebhebhoni .

Isithonjana kwibha yamathuluzi yalezi kanye neminye imisebenzi eminingi ethandwayo yileligama lesiGreki Sigma ( Σ ). Ngokuzenzakalelayo, umsebenzi we-AutoSum uboniswa eceleni kwesithonjana.

I- Auto ingxenye yegama libhekisela eqinisweni lokuthi uma ufakwa usebenzisa le ndlela, umsebenzi ukhetha ngokuzenzakalelayo lokho okukholelwa ukuthi ububanzi bamaseli abuzofinganiswa nomsebenzi.

Ukuthola Isilinganiso nge-AutoAverage

1. Chofoza kuseli C8 - indawo lapho imiphumela yomsebenzi iboniswa khona;
2. Njengoba kuboniswe esithombeni ngenhla, kuphela i-C7 yeselula okufanele ikhethwe ngumsebenzi - ngenxa yokuthi i-cell C6 ayinalutho;
3. Khetha ibanga elifanele lomsebenzi C1 kuya ku-C7 ;
4. Cindezela ukhiye wokungena kwikhibhodi ukwamukela umsebenzi;
5. Impendulo 13.4 kufanele ivele kuseli C8.

I-Excel ISIVELO Sokusebenza Isibonelo

Izinyathelo ezingezansi zihlanganisa ukuthi ungangena kanjani umsebenzi we-AVERAGE oboniswe emgqeni wesine kusibonelo esithombeni ngenhla usebenzisa isinqamuleli ku-AVERAGE umsebenzi okukhulunywe ngenhla.

Ukufaka i-AVERAGE Umsebenzi

1. Chofoza kuseli D4 - indawo lapho imiphumela yefomula izoboniswa khona;
2. Chofoza kuthebhu yaseKhaya ye-ribbon
3. Chofoza umcibisholo ophansi eceleni kwe- AutoSum inkinobho ebhebheni ukuze uvule uhlu lokudonsela phansi lwemisebenzi
4. Chofoza igama elithi Isilinganiso ohlwini ukuze ufake umsebenzi we-AVERAGE kuseli D4
5. Chofoza kusithonjana seMisebenzi kubha yamathuluzi ngenhla ukuvula uhlu lokudonsela phansi lwemisebenzi;
6. Khetha Isilinganiso kusuka kuhlu ukuze ufake ikhophi engenalutho yomsebenzi kuseli D4;
7. Ngokuzenzakalelayo, umsebenzi ukhetha izinombolo ku-cell D4;
8. Shintsha lokhu ngokugqamisa amaseli A4 kuya ku-C4 ukungena lezi zikhombisi njengezizathu zomsebenzi bese ucindezela ukhiye wokungena kwikhibhodi;
9. Inombolo engu-10 kufanele ivele kuseli D4. Lena isilinganiso samanani amathathu - 4, 20, no-6;
10. Uma uchofoza kumakhalekhukhwini A8 umsebenzi ophelele = I-AVERAGE (A4: C4) ivela kubha yefomula ngaphezulu kwephepha lokusebenzela.

Gcina la manothi engqondweni:

• Amaseli ngabanye, kunokuba uhla oluqhubekayo linganezelwa njengezingxabano kodwa isithenjwa ngasinye se-cell kufanele sihlukaniswe nge-comma.

• Okufakwayo kombhalo namaseli aqukethe ama-Boolean values (TRUE noma FALSE) namaseli angenalutho ayenganakwa ngomsebenzi njengoba kuboniswe kumigqa 6, 8 no-9 ngenhla.

• Ngemuva kokungena kulo msebenzi, uma izinguquko zenziwa kudatha kumaseli akhethiwe, umsebenzi, ngokuzenzakalelayo, uvuselela ngokuzenzakalelayo ukukhombisa ushintsho.

Indlela Yokuzenzakalela Ikhetha Uhlu Lokuphikisana

• Ibanga elizenzakalelayo liqukethe amaseli kuphela aqukethe izinombolo, ububanzi bezinombolo ezikhethiwe ziphazanyiswa yiseli equkethe umbhalo noma iseli elingenalutho.
• Umsebenzi we-AVERAGE uklanyelwe ukungena ngaphansi kwekholomu yedatha noma ekugcineni kwesigcawu sedatha. Ibukeka kuqala idatha yedatha ngenhla bese kwesobunxele.
• Njengoba umsebenzi we-AVERAGE, empeleni, ukuqagela ebangeni owukhethayo ukuphikisana kwenombolo, lokhu kukhethwa kufanele kuhlolwe ngaso sonke isikhathi ukulungisa ngaphambi kokucindezela ukhiye we- Enter ekhibhodi ukuqedela umsebenzi.

Amaseli angenalutho ahambisana ne-Zero

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

Amangqamuzana angenalutho ayengayinaki umsebenzi we-AVERAGE, ongasetshenziswa kakhulu ngoba wenza ukuthi isilinganiso semininingwana engekho emithini yedatha elula kakhulu njengoba kuboniswe kulayini 6 ngenhla.

Amaseli aqukethe inani le-zero, noma kunjalo, afakwe ngokwesilinganiso njengoba kuboniswe kulayini 7.

Ukubonisa i-Zeros

Ngokuzenzakalelayo, i-Excel ibonisa i-zero kumaseli enenani elilinganiselwe - njengomphumela wokubala, kodwa uma lokhu kukhethiwe kuvaliwe, lawa maseli ashiywe ingenalutho, kodwa ahlanganisiwe ekubaleni okulinganiselwe.

Ukuvula lokhu kukhetha:

1. Chofoza kuthebhu yefayela yebhebhoni ukuze ubonise okukhethwa kukho imenyu yefayela;
2. Chofoza Izinketho ohlwini ukuze uvule ibhokisi lengxoxo ye- Excel .
3. Chofoza kusigaba esithuthukile ngakwesokunxele kwesibhokisi sebhokisi ukuze ubone izinketho ezitholakalayo.
4. Esikhathini sokunene kwesandla, kuzinketho zokubonisa zalesi sigaba sekhasi ukususa ibhokisi lokuhlola lokubonisa i-zero kumaseli anebhodi lokuhlola elibiza inani .
5. Ukuze ubonise amanani we-zero (0) kumaseli aqinisekise ukuthi Bonisa i-zero kumaseli ane-zero value checkbox ekhethiwe.