Ungawenza kanjani ukwehla komugqa ku-Excel? Okokufundisa ukwenza ukuhlaziya kanye nezibalo ku-Excel.
Uma unohlelo lwedeskithophu ye-Excel unethuba lokusebenzisa ithuluzi lokuhlehla elifakiwe, elifakwe kumathuluzi okuhlaziya noma imisebenzi yezibalo.
Uma ungazi ukuthi ukuhlehla komugqa kuyini, akuyona into engaphezu kwesakhiwo sedatha esimele ubudlelwano bomugqa phakathi kokuhluka okuzimele nokuncikile. Ngokuvamile, isetshenziselwa ukukhombisa amandla obudlelwano kanye nezinga lemiphumela, ngaleyo ndlela ichaze ukuziphatha kokuhlukahluka okuncikile.
Ukwenza kube lula ukuqonda ukuhlehla komugqa, ake sithathe njengesibonelo ukuthi sifuna ukuhlola amandla obudlelwano phakathi kwenani lika-ayisikhilimu owudlayo kanye nokukhuluphala. Ukuhluka okuzimele kungaba inani le-ayisikhilimu futhi sizoyixhuma nokuguquguquka okuncikile, okuyinto kuleli cala ukukhuluphala, ukubona ukuthi kukhona ubuhlobo obunjalo.
Uma ubonisa ukuhlehla, lobu budlelwano buyahlelwa, uma ukuhlukahluka kwedatha kuncane, ubudlelwano buqinile, futhi ukulingana komugqa wokuhlehla kunamandla.
Ukuhlaziywa kokuhlehla kungafinyelelwa uma okuguquguqukayo kuzimele, nge-Excel kulula ukwenza imodeli, uma sisebenzisa ikhithi yamathuluzi yokuhlaziya idatha. Kubalulekile ukuqaphela ukuthi isethi yedatha yakho kufanele ibe yiqiniso ukuze uqhubeke nokuhlaziywa kokuhlehla.
Kukhona ukuqagela okumbalwa okubalulekile mayelana nesethi yedatha yakho okufanele kube yiqiniso ukuze uqhubeke nokuhlaziya ukwehla:
Okuguquguqukayo kufanele kuzimele ngempela (kusetshenziswa ukuhlolwa kwe-Chi-square). Idatha akumele ibe nezilinganiso zamaphutha ezihlukile, amagama amaphutha anjalo akufanele ahlotshaniswe.
Ake sibone ukuthi yini okudingeka ukwazi ungakwenza kanjani ukuhlehla komugqa ku-Excel
Ukwehla komphumela ku-Excel
Into yokuqala oyidingayo ukwenza ukuhlaziya kokuhlehla ku-Excel ukuqinisekisa ukuthi unekhithi yamathuluzi yokuhlaziya idatha yamahhala efakiwe.
Lokhu kuzokwenza kube lula kuwe ukubala uchungechunge lwezibalo, kuzodingeka futhi ukudweba umugqa wokuhlehlisa umugqa, nakuba kuzokwenza kube lula ukudalwa kwamathebula ezibalo.
Uma ufuna ukubona ukuthi ifakiwe ku-Excel yakho, kufanele uye emininingwaneni kubha yamathuluzi, uma unokuhlaziywa kwedatha, yebo uyifakile. Ezinguqulweni ezintsha uthola leli thuluzi kuthebhu Yedatha.
Uma ungenayo le nketho etholakalayo, ungayilanda ngokuchofoza inkinobho ye-Office bese ukhetha Izinketho ze-Excel. Ezinguqulweni zayo zakamuva, ungaya kokuthi Ifayela bese udlulela kokukhethwa kukho, futhi uthole izinketho ze-Excel, bese siya esigabeni sezengezo.
Ngamathuluzi okuhlaziya idatha, ngokuchofoza okumbalwa ungakha okukhiphayo kokuhlehla.
Okuhluka okuzimele kuya ebangeni elithi X.
Ekudaleni ukwehla kwethu, sizosebenzisa isibonelo sokuhlola amandla obudlelwano bokubuya kwesitoko se-Visa. Ikholomu 1 izoba ukuguquguquka kwethu okuncike kudatha ye-Visa yokubuyisela ukwabelana. Okuhlukile kwethu okuzimele kuzoba yikholomu 2 nedatha yokubuyisela
Buyela emuva ethuluzini lokuhlaziya idatha njengenhla, bese usebenzisa imenyu ukuze ukhethe ukuhlehla, bese uchofoza kulungile. Lokhu kuzokukhombisa ibhokisi elisha elibizwa ngokuthi Ukuhlehla.
Kufanele uchofoze ku-"input and Range" kufanele ukhethe ukubuyiselwa kwamanani nedatha yokuhluka okuncikile. Ebhokisini elithi "X Input Range" sizofaka idatha yokuhluka okuzimele. Siyakwamukela ukwenza ukuhlaziya bese sibuyisela umphumela.
Humusha imiphumela
Inqubo ngeke ithathe isikhathi eside, kuzoba umsebenzi wakho ukuhumusha idatha emelelwe kuthebula. Ukuze kuqinisekiswe ukuthi kukhona ukuhlobana phakathi kokuhluka okuncikile nezizimele.
Ukwehla komugqa ku-Excel
Uma ufuna ungarekhoda ukuhlehla ku-Excel, ngaleyo ndlela ugqamise imiphumela futhi uyihlele njengegrafu. Kuzomele uye kokuthi Idizayini, bese usebenzisa ithuluzi lezithombe, ukhethe umugqa wethrendi, bese ekugcineni umugqa wethrendi oqondile.
Nansi indlela yenza ukwehla komugqa ku-excel
Ingabe ukwehla kungenziwa uma sisebenzisa i-Excel ku-inthanethi?
Iqiniso liyinkimbinkimbi kakhulu, ngenxa yezizathu eziningana. Nge-Excel yohlelo lokusebenza lwewebhu, unekhono lokubuka imiphumela yokuhlaziywa kokuhlehla. Kodwa awukwazi ukuyidala, ngoba ithuluzi alitholakali.
Ngeke futhi ube nomsebenzi wespredishithi wezibalo owaziwa ngokuthi ukulinganisa komugqa otholakalayo. Ukuze wenze lolu hlobo lokuhlaziya, udinga ukulifaka njengefomula yamalungu afanayo, engasekelwe yi-Excel yeWebhu.
Ongakwenza ukusebenzisa inkinobho ethi Vula ku-Excel kuhlelo lokusebenza lwedeskithophu bese uvule incwadi yakho yokusebenza, bese usebenzisa ithuluzi lokuhlehla kumathuluzi okuhlaziya noma imisebenzi yezibalo ukuze ukwenze ulapho.
Esinye isizathu sokuthi kungani ingatholakali ukuthi ithuluzi lewebhu lidinga ukukhanya ngangokunokwenzeka futhi lihlangabezane nezidingo ezibaluleke kakhulu zabasebenzisi. Ithuluzi lokuhlaziya elenguqulo yedeskithophu ye-Excel kuphela.
Isiphetho
Ukuqeda lesi sihloko, singasho ukuthi ithuluzi lokuhlaziya le-Excel liyithuluzi elihle lokuhlobanisa idatha. Kubalulekile ukuqaphela ukuthi inqubo kuye ngokuthi inguqulo ye-Excel iyahlukahluka kuphela endaweni yamathuluzi; ukusebenza kufanele kufane ngokuphelele.
Ngaphakathi kwe-Excel ngokwayo kunamathuluzi amaningi okufanele uwacabangele ukuthi asebenza kanjani nokuthi asebenzelani. Uma kuqhathaniswa nenguqulo yayo yewebhu, lesi sakamuva siyafinyela ngokwemisebenzi yayo, ngakho-ke kunconywa ukuthi siyisebenzisele imisebenzi ethile nelula kuphela. Imisebenzi yobungcweti kakhulu kanye nokusetshenziswa okwengeziwe kwamathuluzi kungcono ukusebenzisa inguqulo ephelele.
Lokho kungaba kuphela, sithemba ukuthi usithandile isihloko esilandelayo futhi uyazi ungakwenza kanjani ukuhlehla komugqa ku-Excel, futhi zincike kuziphi izici.