Kukho iindlela ezininzi zokulinganisa ukutyekela okuqhelekileyo okanye, njengoko kuthethwa ngokuqhelekileyo, umyinge, kwixabiso lexabiso.
Inqanaba eliqhelekileyo eliqhelekileyo lokubaluleka kwetendistanti lithetha ukuthini - okanye i-average average - kwaye ibalwa ngokungeza iqela lamanani kunye nokuhlula ngokubala kwala manani. Ngokomzekelo, umyinge we-4, we-20, kunye no-6 wongeziweyo kunye kunye no-10 njengoko kuboniswe kumqolo 4.
Iipredishithi zeGoogle zineemisebenzi emininzi eyenza kube lula ukufumana ezinye zexabiso eliqhelekileyo elisetyenziswa rhoqo. Ezi ziquka:
- Umsebenzi we-AVERAGE - ufumana i-arithmetic ithetha ukuba uluhlu lwamanani.
- Umsebenzi weMEDIAN - ufumana ixabiso eliphakathi phakathi kwoluhlu lwamanani.
- Umsebenzi we- MODE - ufumanisa ixabiso eliqhelekileyo eliqhelekileyo kwiluhlu lwamanani.
ISISHWANKATHELO Sokusebenza se-Syntax kunye neengxoxo
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yomsebenzi we-AVERAGE yile:
= ISIGABA (inombolo_1, inombolo_2, ... inombolo_30)
- inombolo_1 - (efunekayo) idatha iya kuba ngumsebenzi
- inombolo_2 ukuya kwinani_30 - (ukhetho) ezongezelelweyo iimpawu zedatha zifakwe kumyinge. Inani eliphezulu lokungena elivunyelwe li-30
Inombolo yeziphakamiso zingabandakanya:
- Uludwe lweenombolo eziza kubalwa;
- Iingqungquthela zesalathisi kwindawo yendawo kwiphepha lokusebenzela;
- Uludwe lweetekethi zeeseli;
- Uluhlu o luthetha.
Qaphela: Okungeniswa kwamagama kunye neeseli ezinexabiso le-Boolean (TRUE okanye FALSE) zinyanzelwa ngumsebenzi njengoko kuboniswe kumqolo 8 no-9 kumfanekiso ongentla.
Ukuba iiseli ezingenanto okanye eziqulethe itekisi okanye iimpawu zeBoolean zitshintshelwe kamva ukuba zibambe amanani, umyinge uya kuphinda abuyele kwakhona ukulungiselela ukutshintsha.
Amaseli angenanto ngokubhekiselele kwiZero
Xa kuziwa ekufumaneni ixabiso eliqhelekileyo kwi-Google Spreadsheets, kukho umehluko phakathi kwezinto ezingenanto okanye ezingenanto kunye nalabo abanexabiso 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.
Ukufumana ISIGABA SOMSEBENZI
Njengamanye eminye imisebenzi eyakhelwe kwiiGoogle Spreadsheets, umsebenzi we-AVERAGE ungagqalwa ngokuchofoza Ukufaka > Umsebenzi kumamenyu ukuvula uluhlu olwehlayo lwemisebenzi esetyenziswa ngokuqhelekileyo equka umsebenzi we-AVERAGE.
Ngenye indlela, ngenxa yokuba isetyenziswe ngokuqhelekileyo, inqumla kumsebenzi sele yongezwe kwibar yomhla weprogram, ukwenza kube lula ukuyifumana nokuyisebenzisa.
Ikhonkco kwibar yamatye yale nto neminye eminye imisebenzi eyaziwayo yincwadi yesiGrike Sigma ( Σ ).
I-Google Spreadsheets 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
- Cofa kwiseli D4 - indawo apho iziphumo zefomula ziza kuboniswa.
- Cofa Impawu zeSebenzi kwibar ye toolbar ephezulu kwiphepha lokusebenzela ukuze uvule uluhlu lwezinto eziphantsi.
- Khetha Umyinge ukusuka kuloluhlu ukufaka ikopi engenanto yomsebenzi kwi-cell D4.
- Khanyisa iiseli ze-A4 ukuya kwiC4 ukufaka ezi ziboniso njengeengxabano zomsebenzi uze ucinezela ukhiye wokungena kwikhibhodi.
- Inombolo 10 kufuneka ibonakale kwiseli D4. Lo ngumyinge wamanani amathathu - 4, 20, no-6.
- Xa ucofa kwi-cell A8 umsebenzi opheleleyo = I-AVERAGE (A4: C4) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
Amanqaku:
- Amaseli ngabanye, kunokuba uhla oluqhubekayo lunokudibaniswa njengengxoxo kodwa isalathisi nganye kufuneka ihlukaniswe yi-comma.
- Emva kokungena kumsebenzi, ukuba utshintsho lwenziwa kwidata kwiiseli ezikhethiweyo, umsebenzi, ngokuzenzakalelayo, uhlaziya ngokuzenzekelayo ukubonisa utshintsho.