Ukudala Ishadi le-Pareto ku-Excel

Umgomo wePareto, oqanjwe ngosomnotho wase-Italy uVilfredo Pareto, uthi U-80% wezinkinga ungadalwa yizimbangela ezingamaphesenti angama-20. Isimiso singaba usizo kakhulu noma ulwazi olusindisa ukuphila lapho kufanele ukhethe ukuthi yiziphi izinkinga eziningi okufanele uzixazulule kuqala, noma uma ukuqedwa kwezinkinga kuyinkimbinkimbi yizimo zangaphandle.

Isibonelo, usanda kucelwa ukuthi uhole ithimba elinobunzima bokusebenza kuphrojekthi ukuze ulikhombe endleleni efanele. Ubuza amalungu eqembu ukuthi yiziphi izithiyo zabo eziyinhloko ekufinyeleleni izinhloso zabo kanye nezinhloso zabo. Benza uhlu oluhlaziyayo futhi uthole ukuthi yiziphi izimbangela eziyinhloko zenkinga ngayinye iqembu elihlangabezane nayo, lizama ukubona izinto ezifanayo.

Zonke izimbangela zezinkinga ezitholiwe zihlelwa ngokuya ngokuvama kokuvela kwazo. Uma ubheka izinombolo, uthola ukuthi ukuntuleka kokuxhumana phakathi kwabaqalisi bephrojekthi kanye nabathintekayo bephrojekthi kuyimbangela yezinkinga eziphezulu ezingu-23 iqembu elibhekene nazo, kuyilapho inkinga yesibili enkulu iwukuthola izinsiza ezidingekayo (izinhlelo zekhompyutha, imishini, njll. .). .) kubangele izinkinga ezihambisanayo ezingu-11 kuphela. Ezinye izinkinga zizodwa. Kuyacaca ukuthi ngokuxazulula inkinga yokuxhumana, amaphesenti amakhulu ezinkinga angaqedwa, futhi ngokuxazulula inkinga yokufinyelela izinsiza, cishe i-90% yezithiyo endleleni yeqembu ingaxazululwa. Awutholanga nje kuphela ukuthi ungasiza kanjani iqembu, usanda kwenza ukuhlaziya kwePareto.

Ukwenza wonke lo msebenzi ephepheni cishe kuzothatha isikhathi esithile. Inqubo ingasheshiswa kakhulu kusetshenziswa ishadi le-Pareto ku-Microsoft Excel.

Amashadi e-Pareto ayinhlanganisela yeshadi lomugqa kanye ne-histogram. Ahlukile ngoba ngokuvamile aneeksisi eyodwa evundlile (i-axis yesigaba) kanye nezimbazo ezimbili eziqondile. Ishadi liwusizo ekubekeni phambili nasekuhleleni idatha.

Umsebenzi wami ukukusiza ukuthi ulungiselele idatha yeshadi le-Pareto bese udala ishadi ngokwalo. Uma idatha yakho isivele ilungiselelwe ishadi le-Pareto, ungadlulela engxenyeni yesibili.

Namuhla sizohlaziya isimo esiyinkinga enkampanini ehlale ibuyisela abasebenzi izindleko. Umsebenzi wethu ukuthola ukuthi yini esichitha kakhulu kukho futhi siqonde ukuthi singanciphisa kanjani lezi zindleko ngo-80% sisebenzisa ukuhlaziya okusheshayo kwePareto. Singathola ukuthi yiziphi izindleko ezibalelwa ku-80% wezimbuyiselo futhi sinqande izindleko eziphakeme ngokuzayo ngokushintsha inqubomgomo ukuze sisebenzise amanani entengo yezitolo ezinkulu futhi sixoxe ngezindleko zezisebenzi.

Ingxenye Yokuqala: Lungiselela Idatha Yeshadi Le-Pareto

1. Hlela idatha yakho. Ethebulani lethu, kunezigaba eziyisi-6 zesinxephezelo semali namanani afunwa ngabasebenzi.
2. Hlunga idatha ngohlelo olwehlayo. Hlola ukuthi amakholomu akhethiwe А и Вukuhlunga ngendlela efanele.
3. Ingqikithi Yekholomu Inani le (inani lezindleko) libalwa kusetshenziswa umsebenzi ISUM (SUM). Esibonelweni sethu, ukuze uthole inani eliphelele, udinga ukwengeza amaseli kusuka V3 kuya V8.

Ama-Hotkeys: Ukuhlanganisa ububanzi bamanani, khetha iseli B9 bese ucindezela Alt+=. Isamba semali sizoba ngu-$12250.

3. 
4. Dala ikholomu Inani Eliqoqiwe (inani elihlanganisiwe). Ake siqale ngevelu yokuqala $ 3750 esitokisini B3. Inani ngalinye lisekelwe enanini leseli langaphambilini. Esitokisini C4 uhlobo =C3+B4 bese ucindezela Faka.
5. Ukuze ugcwalise ngokuzenzakalelayo amaseli asele kukholamu, chofoza kabili isibambo sokugcwalisa ngokuzenzakalelayo.
6. Okulandelayo, dala ikholomu Iqoqo % (iphesenti elikhulayo). Ukuze ugcwalise le kholomu, ungasebenzisa isamba sobubanzi Inani le kanye namanani asuka kukholomu Inani Eliqoqiwe. Kubha yefomula yeseli D3 faka =C3/$B$9 bese ucindezela Faka. Uphawu $ idala ireferensi ephelele ukuze inani lesamba (inkomba yeseli B9) akushintshi uma ukopisha ifomula phansi.
7. Chofoza kabili umaka wokugcwalisa okuzenzakalelayo ukuze ugcwalise ikholomu ngefomula, noma uchofoze umaka bese uwuhudula kukholomu yedatha.
8. Manje konke sekumi ngomumo ukuqala ukwakha ishadi lePareto!

Ingxenye Yesibili: Ukwakha Ishadi Le-Pareto ku-Excel

1. Khetha idatha (esibonelweni sethu, amaseli asuka A2 by D8).
2. Cindezela I-Alt + F1 kukhibhodi ukuze udale ngokuzenzakalela ishadi kusuka kudatha ekhethiwe.
3. Chofoza kwesokudla endaweni yeshadi nakumenyu evelayo, chofoza Khetha idatha (Khetha Idatha). Ibhokisi lengxoxo lizovela Ukukhetha umthombo wedatha (Khetha Umthombo Wedatha). Khetha umugqa Inani Eliqoqiwe bese ucindezela Susa (Susa). Khona-ke OK.
4. Chofoza kugrafu bese usebenzisa okhiye bemicibisholo kukhibhodi yakho ukuze uhambe phakathi kwezinto zayo. Uma umugqa wedatha ukhethiwe Iqoqo %, manje esiqondana ne-axis yesigaba (i-eksisi evundlile), chofoza kwesokudla kuyo bese ukhetha Shintsha uhlobo lweshadi lochungechunge (Shintsha Uhlobo Lochungechunge Lweshadi). Manje lolu chungechunge lwedatha kunzima ukubona, kodwa kungenzeka.
5. Ibhokisi lengxoxo lizovela Shintsha uhlobo lweshadi (Shintsha Uhlobo Lweshadi), khetha ishadi lomugqa.
6. Ngakho-ke, sithole i-histogram kanye negrafu yomugqa oyisicaba eduze kwe-eksisi evundlile. Ukuze sibonise ukukhululeka kwegrafu yomugqa, sidinga enye i-eksisi eqondile.
7. Chofoza kwesokudla kumugqa Iqoqo % futhi kumenyu evelayo, chofoza Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi). Ibhokisi lengxoxo legama elifanayo lizovela.
8. Esigabeni Izinketho Zomugqa (Izinketho zochungechunge) khetha I-eksisi Encane (I-eksisi Yesibili) bese ucindezela inkinobho Close (Vala).
9. I-eksisi yephesenti izovela, futhi ishadi lizophenduka libe yishadi lePareto eligcwele ngokugcwele! Manje sesingafinyelela esiphethweni: isamba sezindleko yimali yokufunda (Izimali Zokuqeqesha), izinto zokusebenza (Izingxenyekazi zekhompyutha) nezinto zokubhala (Izimpahla zasehhovisi).

Ngemiyalelo yesinyathelo ngesinyathelo yokusetha nokudala ishadi le-Pareto ku-Excel eduze, lizame ngokwenza. Ngokusebenzisa ukuhlaziya kwe-Pareto, ungabona izinkinga ezibaluleke kakhulu futhi uthathe isinyathelo esibalulekile sokuzixazulula.