Abasebenzisi be-Excel bayazi ukuthi lolu hlelo lunomsebenzi obanzi kakhulu wemisebenzi yezibalo, ngokwendlela ezingakwazi ukuncintisana kalula nezinhlelo ezikhethekile. Kodwa ngaphezu kwalokho, i-Excel inethuluzi lapho idatha isetshenziselwa izinkomba eziningana zezibalo ngokuchofoza okukodwa.
Leli thuluzi libizwa "Izibalo ezichazayo". Ngalokhu ungakwazi ngesikhathi esifushane kakhulu, usebenzisa izinsiza zesimiso, uhlele ulwazi olubanzi futhi uthole ulwazi mayelana nalo ngezimo ezihlukahlukene zezibalo. Ake sibuke ukuthi leli thuluzi lisebenza kanjani, futhi ubuke ezinye zezinhlamvu zokusebenza nazo.
Ukusebenzisa izibalo ezichazayo
Ngaphansi kwezibalo ezichazayo ziqonda ukuhlelwa kwemininingwane yedatha yezinombolo eziningana zezibalo eziyisisekelo. Ngaphezu kwalokho, ngesisekelo somphumela otholakala kulezi zinkomba zokugcina, kungenzeka ukuthi wenze iziphetho ezijwayelekile mayelana nesethi yedatha ngaphansi kwesifundo.
Ku-Excel kukhona ithuluzi elihlukile elifakiwe "I-Package Analysis"ongenza ngalo lolu hlobo lokucubungula idatha. Ubizwa "Izibalo ezichazayo". Phakathi kwezinqubo ukuthi leli thuluzi libala ziyizinkomba ezilandelayo:
- I-Median;
- Imfashini;
- Ukuhlakazeka;
- Isilinganiso;
- Ukuphambuka okujwayelekile;
- Iphutha elijwayelekile;
- I-Asymmetry, njll.
Cabanga ukuthi leli thuluzi lisebenza kanjani esibonelweni se-Excel 2010, nakuba le algorithm nayo isebenza ku-Excel 2007 nakuzinguqulo zamuva zalolu hlelo.
Ukuxhumeka kwe-"Analysis Package"
Njengoba kushiwo ngenhla, ithuluzi "Izibalo ezichazayo" Kufakwe kuhlu olubanzi lwemisebenzi, ebizwa ngokuthi Iphakethe lokuhlaziya. Kodwa iqiniso ukuthi ngokuzenzakalelayo lokhu okungeziwe ku-Excel kukhutshaziwe. Ngakho-ke, uma ungakabandakanyi, bese usebenzisa amandla okubalwa kwezibalo, kuzodingeka ukwenze.
- Iya kuthebhu "Ifayela". Okulandelayo, sithuthela iphuzu "Izinketho".
- Ewindini lemingcele esebenziwe, hambisa esigatshaneni Engeza-ons. Ngaphansi phansi kwefasitela yinkambu "Ukuphathwa". Kubalulekile ukuhlela kabusha ushintsho endaweni Faka i-Exceluma kusendaweni ehlukile. Ukulandela lokhu, chofoza inkinobho "Hamba ...".
- Iwindi le-Excel lokungenayo liqala. Ngegama "I-Package Analysis" ufake ifulege. Bese uchofoza inkinobho "Kulungile".
Ngemuva kwezinyathelo ezingenhla zengeze Iphakethe lokuhlaziya izosetshenzwa futhi izotholakala kuthebhu "Idatha" I-Excel. Manje singasebenzisa ngokwenza amathuluzi wezibalo ezichazayo.
Ukusebenzisa ithuluzi elichazayo lezibalo
Manje ake sibone ukuthi lezibalo zezibalo ezichazayo zingasetshenziswa kanjani ekusebenzeni. Kule njongo, sisebenzisa itafula elenziwe ngomumo.
- Iya kuthebhu "Idatha" bese uchofoza inkinobho "Ukuhlaziywa kwedatha"okubekiwe kwi-tape ku-block yamathuluzi "Ukuhlaziywa".
- Uhlu lwamathuluzi akwethulwe Iphakethe lokuhlaziya. Sibheka igama "Izibalo ezichazayo"ukhethe bese uchofoza inkinobho "Kulungile".
- Ngemva kokwenza lezi zenzo, iwindi lizoqala ngokuqondile. "Izibalo ezichazayo".
Ensimini "Isikhathi sokufaka" ucacise ikheli lobubanzi obuzocutshungulwa yili thuluzi. Futhi siyicacisa ngokuhambisana netafula. Ukuze ufake izixhumanisi esizidingayo, setha isikhangiso kunsimu ecacisiwe. Khona-ke, ubambe inkinobho yegundane lesokunxele, khetha indawo ehambisana netafula eshidi. Njengoba ungabona, izixhumanisi zayo zizovela ngokushesha ensimini. Njengoba sithatha idatha kanye nekhanda, ke mayelana nepharamitha "Amathegi eyokuqala" kufanele uhlole ibhokisi. Ngokushesha ukhethe uhlobo lokuqoqa, ukuhambisa inkinobho endaweni "Ngamakholomu" noma "Emigqa". Esikhathini sethu, ukhetho "Ngamakholomu", kodwa kwezinye izimo, kungadingeka ukuthi usethe inkinobho ngenye indlela.
Ngaphezulu saxoxa kuphela ngemininingwane yokufaka. Manje siqhubeka nokuhlaziywa kwezilungiselelo zemingcele yokukhipha, ekhona efasiteleni elifanayo ekwakheni izibalo ezichazayo. Okokuqala, sidinga ukunquma ukuthi impela idatha ekhonjiwe izokhipha:
- Isikhathi sokuphuma;
- Iphepha lokusebenzela elisha;
- Ibhuku lokusebenzela elisha.
Esikhathini sokuqala, udinga ukucacisa uhla oluthile eshadini lamanje noma esitokisini sangakwesokunxele esiphezulu, lapho ulwazi olucutshungulwa luzokhipha khona. Esikhathini sesibili, kufanele ucacise igama leshidi elithile leli bhuku, elizobonisa umphumela wokucubungula. Uma kungekho ishidi elinalo leli gama okwamanje, lizokwenziwa ngokuzenzekelayo ngemuva kokuchofoza inkinobho. "Kulungile". Kwesithathu, akukho mingcele eyengeziwe edingekayo, ngoba idatha izoboniswa efayeleni ehlukile ye-Excel (ibhuku lokusebenzela). Sikhetha ukubonisa imiphumela kushidi lokusebenzela elibizwa ngokuthi "Imiphumela".
Ngaphezu kwalokho, uma ufuna ukuthi izibalo zokugcina nazo zikhishwe, kuzomele uhlole ibhokisi eceleni kwento ehambelanayo. Ungase futhi usethe izinga lokuthembeka ngokufaka uphawu lokubaluleka okufanele. Ngokuzenzakalelayo, izolingana nama-95%, kodwa ingashintshwa ngokungeza ezinye izinombolo ensimini ngakwesokudla.
Ngaphezu kwalokho, ungabeka amabhokisi wokuhlola kumaphoyinti. "Kth okungenani" futhi "K-th ngobukhulu"ngokubeka amanani emasimini afanele. Kodwa kithi, leli pharamitha lifana nelinye elidlule, akulona igunya, ngakho asihloli amabhokisi.
Ngemuva kokuthi yonke imininingwane ecacisiwe ifakiwe, chofoza inkinobho "Kulungile".
- Ngemva kokwenza lezi zenzo, itafula ngezibalo ezichazayo kuboniswa ephepheni elihlukile, esiyiqambe "Imiphumela". Njengoba ungabona, idatha idabukisayo, ngakho kufanele ihlelwe ngokukhulisa amakholomu ahambelana nokubuka okulula.
- Uma idatha "ifakwe" ungaqhubeka nokuhlaziya okuqondile. Njengoba ubona, lezi zinkomba ezilandelayo zibalwe ngokusebenzisa ithuluzi elichaza izibalo:
- I-Asymmetry;
- Isikhathi;
- Okuncane;
- Ukuphambuka okujwayelekile;
- Ukuhluka kwesampula;
- Isikhulu;
- Inani;
- Ukunciphisa;
- Isilinganiso;
- Iphutha elijwayelekile;
- I-Median;
- Imfashini;
- I-Akhawunti
Uma enye idatha engenhla ingadingeki uhlobo oluthile lokuhlaziywa, khona-ke ingasuswa ukuze ingaphazamisi. Ukuhlaziywa okuqhubekayo kwenziwa ngokubheka imithetho yezibalo.
Isifundo: Imisebenzi yezibalo ze-Excel
Njengoba ungabona, usebenzisa ithuluzi "Izibalo ezichazayo" Ungathola ngokushesha imiphumela yezinqubo eziningi, okungeke kubalwe ngenye indlela usebenzisa umsebenzi ohlukaniswe ngokuhlukana ngamunye, okungathatha isikhathi esiningi kumsebenzisi. Futhi-ke, zonke lezi zibalo zingatholakala ngokuchofoza okukodwa, usebenzisa ithuluzi elifanele - Iphakethe lokuhlaziya.
