Ukufumana umlinganiselo wexabiso kunye ne-Excel's AVERAGE Function

Sebenzisa umsebenzi we-AVERAGE ukufumana i-arithmetic ithetha ukuba uluhlu lwamanani

Isibalo seMathematika, kukho iindlela ezininzi zokulinganisa ukutyekela okuqhelekileyo okanye, njengoko kuthethwa ngokuqhelekileyo, umyinge weesethi zexabiso. Ezi ndlela ziquka i- arithmetic ithetha , i- median , kunye nemodi .

Inqanaba eliqhelekileyo eliqhelekileyo lokubaluleka kwetendistanti lithetha ukuthini - okanye i-average average - kwaye ibalwa ngokungeza iqela lamanani kunye nokuhlula ngokubala kwala manani. Ngokomzekelo, umyinge we-2, 3, 3, 5, 7, no-10 ngowama-30 ahlukaniswe ngo-6, ngowama-5.

Ukwenza kube lula ukulinganisa ukutyekela kwe-central, i-Excel inemisebenzi embalwa eya kubala inani eliqhelekileyo elisetyenziswayo. Ezi ziquka:

• Umsebenzi we-AVERAGE - ufumana i- arithmetic ithetha ukuba uluhlu lwamanani
• Umsebenzi weMEDIAN - ufumana ixabiso eliphakathi okanye elingaphakathi kwimihlu yamanani
• Umsebenzi we- MODE - ufumana imo okanye ubuninzi bexabiso eliqhelekileyo kwiluhlu lwamanani

ISISHWANKATHELO Sokusebenza seStell ne-Arguments

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

I-syntax yomsebenzi we-AVERAGE yile:

= ISIGABA (Inani1, Inani2, ... Inani255)

• Inombolo1 - (efunekayo) idatha iya kuba ngumsebenzi.
• Inani2 ukuya kwiNombolo 255 - (okukhethwa kukho) ixabiso leenkcukacha ezongezelelweyo ukuba zifakwe kumyinge. Inani eliphezulu lokungeniswa livunyelwe ngu-255.

Le ngxabano ingaquletheka:

• Uludwe lweenombolo eziza kubalwa;
• Iingqungquthela zesalathisi kwindawo yendawo kwiphepha lokusebenzela;
• Uludwe lweetekethi zeeseli;
• Uluhlu o luthetha.

Ukufumana ISIGABA SOMSEBENZI

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi ogqityiweyo , njenge = ISIGABA (C1: C7) kwiseshishini lomsebenzi;
2. Ukufaka umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi;
3. Ukufaka umsebenzi kunye neengxabano usebenzisa i-Excel's Work average shortcut.

ISISHWANKATHELO Sokusebenza

I-Excel inendlela encinane yokungena kwi-AVERAGE function - ngamanye amaxesha ibizwa ngokuba yi- AutoAverage ngenxa yobudlelwane bayo kunye ne- AutoSum eyaziwayo engcono-eyaziwayo kwiTable yasekhaya yerbhoni .

Ikhonkco kwibar yamathuluzi kule mi sebenzi emininzi iyimpawu yesiGrike Sigma ( Σ ). Ngokungagqibekanga, umsebenzi we-AutoSum uboniswa eceleni kwe icon.

Inxalenye ye- Auto egama libhekisela kwinto yokuba xa ufakwe usebenzisa le ndlela, umsebenzi ukhetha ngokuzenzekelayo oko kukholelwa ukuba uluhlu lwamaseli ukuba lufakwe ngumsebenzi.

Ukufumana Umyinge kunye neAppAverage

1. Cofa kwiseli C8 - indawo apho iziphumo zomsebenzi ziboniswa khona;
2. Njengoko kuboniswe kumfanekiso ongentla, kuphela i-cell C7 kufuneka ikhethwe ngumsebenzi - ngenxa yokuba i-cell C6 ayinanto;
3. Khetha uluhlu oluchanekileyo lomsebenzi C1 ukuya kwiC7 ;
4. Cinezela ukhiye wokungena kwibhodibhodi ukwamukela umsebenzi;
5. Impendulo 13.4 kufuneka ibonakale kwiseli C8.

I-Excel ISIGABA Sokusebenza Umzekelo

Amanyathelo angezantsi ajonga indlela yokufaka umsebenzi WENKQUBO oboniswe kumqolo wesine kumzekelo osemfanekisweni ongentla usebenzisa i-shortcut kwi-AVERAGE umsebenzi ekhankanywe ngasentla.

Ukufaka i-AVERAGE Function

1. Cofa kwiseli D4 - indawo apho iziphumo zefomula ziza kuboniswa khona;
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwisalathiso esingaphantsi kwekhompyutheni ye - AutoSum kwidbhoni ukuvula uluhlu lokuhlahla lwemisebenzi
4. Cofa kwigama Umyinge oluhlu ukufaka umsebenzi WENKQUBO kwiseli D4
5. Cofa kwi Impawu zeSebenzi kwibhar ye toolbar ngasentla ukuvula uluhlu lokuhlahla lwemisebenzi;
6. Khetha Umyinge ukusuka kuloluhlu ukubeka ikopi engenanto yomsebenzi kwi-cell D4;
7. Ngokungagqibekanga, umsebenzi ukhetha amanani kwi-cell D4;
8. Tshintsha oku ngokugqamisa iiseli A4 ukuya kwi C4 ukufaka ezi ngqangi njengengxabano yomsebenzi uze ucine iqhosha lokungena kwikhibhodi;
9. Inombolo 10 kufuneka ibonakale kwiseli D4. Lo ngumyinge wamanani amathathu-4, 20, no-6;
10. Xa ucofa kwi- cell A8 umsebenzi opheleleyo = I-AVERAGE (A4: C4) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

Gcina la manqaku engqondweni:

• Amaseli ngabanye, kunokuba uhla oluqhubekayo lunokudibaniswa njengengxoxo kodwa isalathisi nganye kufuneka ihlukaniswe yi-comma.

• Ukufakwa kwamagama kunye neeseli eziqulethe ixabiso le-Boolean (TRUE okanye FALSE) kunye neeseli ezingenanto zingagcinwa ngumsebenzi njengoko kuboniswe kumqolo 6, 8 no-9 ngasentla.

• Emva kokungena kumsebenzi, ukuba utshintsho lwenziwa kwidata kwiiseli ezikhethiweyo, umsebenzi, ngokuzenzakalelayo, uhlaziya ngokuzenzekelayo ukubonisa utshintsho.

Indlela Yokwenza Imothamo Yokwenza I-AutoAverage ikhetha Uhlu Lokuphikisana

• Uluhlu olungapheli luquka kuphela iiseli ezinamanani, uluhlu lwamanani akhethiweyo luphazamiseka ngetekisi equkethe itekisi okanye i-cell engenanto.
• Umsebenzi we-WVERAGE wenzelwe ukuba ungeniswe phantsi kwekholomu yedata okanye ekupheleni kwesigcaziso sedatha. Ubheka kuqala idatha yedatha engentla kwaye emva kwesokunxele.
• Ekubeni umsebenzi we-AVERAGE, ngokwenene, ukuqwalasela kwinqanaba elikhethayo ingxabano yeNombolo, olu khetho lufanele luhlolwe ngokuchanekileyo ngokuchanekileyo ngaphambi kokucofa iqhosha lokungena kwikhibhodi ukugqiba umsebenzi.

Amaseli angenanto ngokubhekiselele kwiZero

Xa kuziwa ekufumaneni ixabiso eliqhelekileyo kwi-Excel, kukho umehluko phakathi kwamangqamuzana angenanto okanye angenalutho kunye nalawo anexabiso lentengo.

Amaseli angenanto ayamkelwa yi-AVERAGE umsebenzi, onokuba luncedo kakhulu kuba ufumana umyinge weeseli ezingafaniyo zedatha lula kakhulu njengoko kuboniswe kumgca 6 ngentla.

Iiseli ezinexabiso lexabiso, nangona kunjalo, zibandakanyiwe kumyinge njengoko kuboniswe kumqolo 7.

Ukubonisa iZeros

Ngokungagqibekanga, i-Excel ibonisa i-zero kwiiseli ezinenani elixabisekileyo-njengemiphumo yokubala, kodwa ukuba olu khetho luvaliwe, iiseli ezinjalo zishiywe zingenanto, kodwa zibandakanyiwe ngokubala.

Ukuguqula le ndlela:

1. Cofa kwifayile yefayile yebhebhoni ukubonisa ukhetho lwemenyu yefayile;
2. Cofa Khetha kwiluhlu ukuvula ibhokisi yencoko yebhokisi ye- Excel .
3. Cofa kwiCandelo eliPhezulu kwicala lasekhohlo lebhokisi yencoko ukuze ubone iinketho ezikhoyo.
4. Kwiphepha lesandla sokunene, kwiinketho zokubonisa kwesi sigaba sekhasi lo msebenzi kucima ibhokisi yokujonga yokubonisa i-zero kwiiseli ezinenani elibalulekileyo lebhokisi yokukhangela.
5. Ukubonisa ubungakanani bexabiso (0) kwiiseli ziqinisekisa ukuba Bonisa i-zero kwiiseli ezinenani elincinci lebhokisi yokukhangela likhethiwe.