I-histogram iyithuluzi elihle lokuboniswa kwedatha. Lo mdwebo ongokomfanekiso ongakwazi ukuwahlola ngokushesha isimo sonke, ngokubheka, ngaphandle kokufunda idatha yenombolo etafuleni. Ku-Microsoft Excel kunamathuluzi amaningana aklanyelwe ukwakha i-histograms yezinhlobo ezihlukahlukene. Ake sibheke izindlela ezahlukene zokwakha.
Isifundo: Indlela yokudala i-histogram ku-Microsoft Word
Ukwakhiwa kwe-Histogram
I-histogram ye-Excel ingadalwa ngezindlela ezintathu:
- Ukusebenzisa ithuluzi elifakwe eqenjini "Amashadi";
- Ukusebenzisa ukufometha okunemibandela;
- Ukusebenzisa ukuhlaziywa kwephakheji engeza.
Kungenziwa ifakwe njengezinto ezihlukile, noma uma usebenzisa ukufometha okunemibandela, ukuba yingxenye yeseli.
Indlela 1: Dala i-histogram elula emdwebeni we block
I-histogram elula ilula ukuyenza isebenzise umsebenzi ebhokisini lamathuluzi. "Amashadi".
- Yakha itafula equkethe idatha eboniswe eshadini esizayo. Khetha amakholomu etafuleni azoboniswa kwizinhlamvu ze-histogram negundane.
- Ukuba ngaphakathi kuthebhu "Faka" chofoza inkinobho "I-Histogram"okuyinto itholakala ku-tape ebhodini lamathuluzi "Amashadi".
- Kulolu hlu oluvula, khetha eyodwa yezinhlobo ezinhlanu zemidwebo elula:
- i-histogram;
- i-volumetric;
- i-cylindrical;
- i-conical;
- ipiramidi
Wonke amashadi alula atholakala ngakwesokunxele ohlwini.
Ngemuva kokukhethwa, i-histogram yakhelwe kwi-Excel sheet.
- Shintsha izitayela zekholomu;
- Bhalisela igama lomdwebo njengento yonke, kanye nezinkomba zalo ngabanye;
- Shintsha igama bese ususa iphutha, njll.
Ukusebenzisa amathuluzi akhiwe eqenjini lethebhu "Ukusebenza ngamashadi" Ungahlela into eholele:
Isifundo: Indlela yokwenza ishadi ku-Excel
Indlela 2: ukwakha i-histogram ngokuqoqa
I-histogram eqoqiwe iqukethe amakholomu afaka amanani amaningana ngesikhathi esisodwa.
- Ngaphambi kokuba uqhubekele ekudaleni umdwebo ngokuqoqa, kudingeka uqiniseke ukuthi ayikho igama engxenyeni engakwesokunxele ku-header. Uma igama liwukuthi, kufanele lisuswe, kungenjalo ukwakhiwa komdwebo ngeke kusebenze.
- Khetha ithebula ngesisekelo lapho i-histogram izokwakhiwa khona. Kuthebhu "Faka" chofoza inkinobho "I-Histogram". Kuhlu lwamashadi avela, khetha uhlobo lwe-histogram ngokuqoqa esikudingayo. Zonke zikhona ngakwesokudla ohlwini.
- Ngemva kwalezi zenzo, i-histogram ivela ekhasini. Kungalungiswa ngokusebenzisa amathuluzi afanayo axoxwa ngawo lapho echaza indlela yokuqala yokwakha.
Indlela 3: ukwakha usebenzisa i-"Analysis Package"
Ukuze usebenzise indlela yokwakha i-histogram usebenzisa iphakheji lokuhlaziywa, udinga ukucupha le phakheji.
- Iya kuthebhu "Ifayela".
- Chofoza egameni lesigaba "Izinketho".
- Yiya esigatshaneni Engeza-ons.
- Ku-block "Ukuphathwa" shintshela inkinobho ukuma Faka i-Excel.
- Ewindini evuliwe eduze kwento "I-Package Analysis" setha uphawu bese uchofoza inkinobho "Kulungile".
- Hambisa kuthebhu "Idatha". Chofoza inkinobho ekhonjeni "Ukuhlaziywa kwedatha".
- Ewindini elincane elivuliwe, khetha into "I-Histograms". Sicindezela inkinobho "Kulungile".
- Iwindi lesethingi ye-histogram ivuleka. Ensimini "Isikhathi sokufaka" faka ikheli lebanga lamaseli, i-histogram esifuna ukuyibonisa. Qiniseka ukuphawula ibhokisi elingezansi kwento "Ukupaka". Emiphaketheni yokungena ungacacisa lapho i-histogram izoboniswa khona. Okuzenzakalelayo kusekhasini elisha. Ungacacisa ukuthi okukhiphayo kuzokwenziwa kuleli shidi ngamaseli athile noma encwadini entsha. Ngemuva kokuthi zonke izilungiselelo zifakiwe, chofoza inkinobho "Kulungile".
Njengoba ungabona, i-histogram yakhelwe endaweni oye yacacisa ngayo.
Indlela 4: i-Histograms enefomathi enemibandela
I-Histograms nayo ingaboniswa uma amaseli afometha ngokomzimba.
- Khetha amaseli nedatha esifuna ukuyifometha ngendlela ye-histogram.
- Kuthebhu "Ikhaya" kwi-tape chofoza inkinobho "Ukufometha okunemibandela". Emenyu yokudonsa, chofoza entweni "I-Histogram". Kuloluhlu lwe-histograms olugcwele nolwazi oluhle olubonakalayo, khetha lowo esicabanga ukuthi kufanelekile kakhulu esimweni ngasinye.
Manje, njengoba sibona, esitokisini ngasinye esimisiwe sinombonakaliso wokuthi, ngesimo se-histogram, ulinganisa ubunani bokulinganisela kwedatha equkethwe kuwo.
Isifundo: Ukufometha okunemibandela ku-Excel
Sakwazi ukuqinisekisa ukuthi i-procel yokusakaza ispredishithi inikeza amandla okusebenzisa ithuluzi elinjalo elilula, njenge-histograms, ngendlela ehlukile ngokuphelele. Ukusetshenziswa kwalokhu msebenzi othakazelisayo kwenza ukuhlaziywa kwedatha kucace nakakhulu.
