Enye yezinkomba eziphambili zezibalo zokulandelana kwezinombolo kungukukhuthala kokwehluka. Ukuze uyithole, kwenziwa izibalo eziyinkimbinkimbi kakhulu. Amathuluzi e-Microsoft Excel enza kube lula kakhulu kumsebenzisi.
Ukubalwa kokuqina kokwahluka
Le nkomba imelela inani lokuphambuka okujwayelekile kunencazelo ye-arithmetic. Umphumela uvezwa njengephesenti.
Ku-Excel awukho umsebenzi ohlukile wokubala le nkomba, kepha kunezindlela zokubala ukuphambuka okujwayelekile nencazelo ye-arithmetic yochungechunge lwezinombolo, okungukuthi zisetshenziselwa ukuthola ukubambisana kokuhluka.
Isinyathelo 1: ukubuka ukuphambuka okujwayelekile
Ukuphambuka okujwayelekile, noma, njengoba kubizwa ngamanye amagama, ukuphambuka okujwayelekile, kuyimpande yesikwele yokuhluka. Ukubala ukuphambuka okujwayelekile, sebenzisa umsebenzi STD. Kusukela ngenguqulo ye-Excel 2010, ihlukaniswe, kuya ngokuthi inani labantu libaliwe noma likhethiwe, kuzindlela ezimbili ezihlukene: STANDOTLON.G futhi STANDOTLON.V.
I-syntax yale misebenzi imi ngalendlela elandelayo:
= STD (Inombolo1; Inombolo2; ...)
= STD.G (Inombolo1; inombolo2; ...)
= STD. B (Inombolo1; inombolo2; ...)
- Ukuze ukubala ukuphambuka okujwayelekile, khetha noma isiphi iseli lamahhala eshidini elilungele wena ukuze ubonise imiphumela yokubala kuyo. Chofoza inkinobho "Faka umsebenzi". Inokubonakala kwesithonjana futhi itholakala kwesokunxele komugqa wamafomula.
- Ukuqalisa kuyaqhubeka Umsebenzi Wizards, okuqala njengewindi elihlukile ngohlu lwezimpikiswano. Iya esigabeni "Izibalo" noma "Uhlu oluphelele lwe-alfabhethi". Khetha igama STANDOTKLON.G noma STANDOTKLON.V, kuya ngokuthi inani eliphelele noma isampuli kufanele libalwe. Chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana lalomsebenzi liyavula. Ungaba nezinsimu ezisuka ku-1 kuye kwezingu-255, ezingaba nezinombolo ezikhethekile nezinkomba kumaseli noma amabanga. Faka ikhesa endle "Inombolo1". Usebenzisa igundane, khetha amabanga wamanani azocutshungulwa ephepheni. Uma kunezindawo ezimbalwa ezinjalo futhi zingahlangani, khona-ke izixhumanisi ezilandelayo zikhonjisiwe endle "Inombolo2" njll. Lapho yonke imininingwane edingekayo ifakiwe, chofoza inkinobho "Kulungile"
- Iseli elikhethwe ngaphambilini libonisa umphumela wokubala kohlobo olukhethiwe lokuphambuka okujwayelekile.
Isifundo: Ifomula yokuphambuka ejwayelekile ye-Excel
Isinyathelo 2: abale okushiwo izibalo
I-Arithmetic mean yisilinganiso senani eliphelele lawo wonke amanani ochungechunge lwamanani kwinombolo yabo. Kunomsebenzi ohlukile wokubala le nkomba - INDAWO. Sibala inani laso sisebenzisa isibonelo esithile.
- Khetha iseli ekhasini lokusebenzela ukubonisa umphumela. Chofoza inkinobho esivele siyazi "Faka umsebenzi".
- Esigabeni sezibalo se-Function Wizard, sifuna igama I-SRZNACH. Ngemuva kokuyikhetha, chofoza inkinobho "Kulungile".
- Ukuqalisa Kwewindows INDAWO. Izimpikiswano zifana ngokuphelele nalezo ezisebenzela iqembu. STD. Okusho ukuthi, ngekhwalithi yabo ingasebenza njengamanani amanani ezinombolo, nezixhumanisi. Setha isikhombisi esigangeni "Inombolo1". Njengasesimweni esedlule, sikhetha isethi edingekayo yamaseli eshidini. Ngemuva kokuthi izixhumanisi zabo zifakiwe emkhakheni wewindi lokuphikisana, chofoza inkinobho "Kulungile".
- Umphumela wokubala okushiwo kwe-arithmetic uboniswa kuseli elalikhethwe ngaphambi kokuvula Umsebenzi Wizards.
Isifundo: Ungalwa kanjani inani eliphakathi ku-Excel
Isinyathelo 3: ukuthola ukwanela kokwehluka
Manje sinemininingwane yonke edingekayo ukuze kubalwe ngokuqondile i-coeffanele yokuhlukahluka.
- Khetha iseli ozokhonjiswa kulo umphumela. Okokuqala, udinga ukubheka ukuthi i-coeffanele of variation iyipesenti. Kulokhu, kufanele uguqule ifomethi yeseli ibe yiyona efanelekile. Lokhu kungenziwa ngemuva kokukhetha, ekubeni kuthebhu "Ikhaya". Qhafaza kunkambu yefomethi kub iribhi ebhulokhi lamathuluzi "Inombolo". Ukusuka ohlwini olwehliswayo lwezinketho, khetha "Intshisekelo". Ngemuva kwalezi zenzo, ifomethi yento ezoba efanele.
- Futhi, buyisela esitokisini ukukhombisa umphumela. Siyayisebenzisa ngokuchofoza kabili inkinobho yegundane kwesobunxele. Sibeka uphawu kuyo "=". Khetha into lapho umphumela wokubala ukuphambuka okujwayelekile utholakala khona. Chofoza inkinobho "yokuhlukanisa" (/) kwikhibhodi. Okulandelayo, khetha iseli lapho kutholakala khona isilinganiso samanani ochungechunge lwamanani olunikeziwe. Ukuze ubale futhi ubonise inani, chofoza inkinobho Ngena kwikhibhodi.
- Njengoba ukwazi ukubona, umphumela wokubala uboniswa esikrinini.
Ngakho-ke, sibalile ukuqina kokuhlukahluka, sibhekisele kumaseli lapho kwasetshenziswa ukubalwa okujwayelekile kokuphambuka nezincazelo zokubala. Kepha umuntu angaqhubeka ngendlela ehluke kakhulu, ngaphandle kokubala ngokwalezi zinani.
- Sikhetha iseli elakhelwe ngaphambilini ifomethi yamaphesenti, lapho umphumela uzokhonjiswa khona. Sibhala kulo ifomula ngohlobo:
= STDB.V (value_range) / AVERAGE (inani_range)Esikhundleni segama Ububanzi bevelu sifaka izixhumanisi zangempela zesifunda lapho kutholakala khona uchungechunge lwamanani aphenywayo. Lokhu kungenziwa ngokugqamisa nje ibanga elinikeziwe. Esikhundleni se-opharetha STANDOTLON.Vuma umsebenzisi ekubona kudingekile, ungasebenzisa lowo msebenzi STANDOTLON.G.
- Ngemuva kwalokho, ukubala inani bese ukhombisa umphumela esikrinini sokuqapha, chofoza inkinobho Ngena.
Kukhona ukubekwa kwemibandela okunemibandela. Kukholakala ukuthi uma i-coeffanele of variation eguqukayo ingaphansi kwama-33%, khona-ke isethi yezinombolo ayinangqondo. Ngokwesimo esiphikisayo, kuyisiko ukuyichaza njengento engenakuphikiswa.
Njengoba ukwazi ukubona, uhlelo lwe-Excel likuvumela ukuthi wenze lula ukubalwa kwesibalo esiyinkimbinkimbi kanjena njengokucinga komklamo wokwehluka. Ngeshwa, uhlelo lokusebenza alunawo umsebenzi ongabala le nkomba esenzweni esisodwa, kepha usebenzisa opharetha STD futhi INDAWO Lo msebenzi wenziwe lula. Ngakho-ke, e-Excel, ingenziwa ngisho nomuntu ongenalo ulwazi oluphakeme oluphathelene nemithetho yezibalo.
