Kupanga Tchati cha Pareto mu Excel

Mfundo ya Pareto, yomwe idatchulidwa ndi katswiri wazachuma waku Italy Vilfredo Pareto, ikuti 80% yamavuto amatha kuyambitsidwa ndi 20% yazifukwa. Mfundoyi ingakhale yothandiza kwambiri kapena ngakhale chidziwitso chopulumutsa moyo pamene muyenera kusankha kuti ndi mavuto ati omwe muyenera kuthetsa poyamba, kapena ngati kuthetsa mavuto kumakhala kovuta ndi zochitika zakunja.

Mwachitsanzo, mwapemphedwa kuti mutsogolere gulu lomwe likuvutika kugwira ntchito inayake kuti liwalondole njira yoyenera. Mumafunsa mamembala agulu zomwe zinali zowalepheretsa kukwaniritsa zolinga zawo. Amapanga mndandanda womwe mumausanthula ndikupeza zomwe zidayambitsa vuto lililonse lomwe gululo lidakumana nalo, kuyesera kuwona zofanana.

Zonse zomwe zapezeka zomwe zimayambitsa mavuto zimakonzedwa molingana ndi kuchuluka kwa zomwe zimachitika. Kuyang'ana manambala, mukuwona kuti kusowa kwa kulumikizana pakati pa oyambitsa polojekiti ndi omwe akukhudzidwa ndi polojekiti ndiye gwero lamavuto apamwamba a 23 omwe gulu likukumana nawo, pomwe vuto lachiwiri lalikulu ndikupeza zinthu zofunika (makompyuta, zida, ndi zina zambiri). .). ) zinangobweretsa zovuta 11 zokha. Mavuto ena ali okha. Zikuwonekeratu kuti pothetsa vuto la kulankhulana, chiwerengero chachikulu cha mavuto chikhoza kuthetsedwa, ndipo pothetsa vuto la kupeza chuma, pafupifupi 90% ya zopinga zomwe zili mu njira ya gulu zingathetsedwe. Sikuti mwangoganizira momwe mungathandizire gulu, mwangochita kafukufuku wa Pareto.

Kuchita ntchito yonseyi pamapepala mwina kumatenga nthawi. Njirayi imatha kufulumizitsidwa kwambiri pogwiritsa ntchito tchati cha Pareto mu Microsoft Excel.

Ma chart a Pareto ndi kuphatikiza kwa tchati chamzere ndi histogram. Iwo ndi apadera chifukwa nthawi zambiri amakhala ndi nkhwangwa imodzi yopingasa (gulu la axis) ndi nkhwangwa ziwiri zoyimirira. Tchatichi ndi chothandiza pakuyika patsogolo ndi kusanja deta.

Ntchito yanga ndikukuthandizani kukonzekera tchati cha Pareto ndikupanga tchati chokha. Ngati deta yanu yakonzekera kale tchati cha Pareto, mukhoza kupita ku gawo lachiwiri.

Lero tiwunika zovuta pakampani yomwe imabweza ndalama zolipirira antchito. Ntchito yathu ndikupeza zomwe timawononga kwambiri ndikumvetsetsa momwe tingachepetsere ndalamazi ndi 80% pogwiritsa ntchito kusanthula kwachangu kwa Pareto. Titha kudziwa zomwe zimawononga 80% ya kubwezeredwa ndikupewa mtengo wokwera m'tsogolo mwa kusintha ndondomeko yogwiritsira ntchito mitengo yamtengo wapatali ndikukambirana za ndalama za ogwira ntchito.

Gawo Loyamba: Konzani Zambiri za Tchati cha Pareto

1. Konzani deta yanu. Pagome lathu, pali magawo 6 a chipukuta misozi ndi ndalama zomwe antchito amafuna.
2. Sanjani deta motsika. Onetsetsani kuti mizati yasankhidwa А и Вkusankha bwino.
3. Column Sum kuchuluka (chiwerengero cha ndalama) chimawerengedwa pogwiritsa ntchito ntchitoyi SUM (SUM). Mu chitsanzo chathu, kuti mupeze ndalama zonse, muyenera kuwonjezera ma cell kuchokera V3 ku V8.

Zogulitsa: Kuti muwerenge kuchuluka kwamitengo, sankhani selo B9 Ndi kukanikiza Alt+=. Ndalama zonse zidzakhala $12250.

3. 
4. Pangani ndime Ndalama Zowonjezera (kuchuluka kwa ndalama). Tiyeni tiyambe ndi mtengo woyamba $ 3750 mu cell B3. Mtengo uliwonse umatengera mtengo wa cell yam'mbuyo. Mu cell C4 mtundu =C3+B4 Ndi kukanikiza Lowani.
5. Kuti mudzaze ma cell otsalawo muzambiri, dinani kawiri chogwirira cha autofill.
6. Kenako, pangani mzati Zowonjezera % (kuchuluka peresenti). Kuti mudzaze gawoli, mutha kugwiritsa ntchito kuchuluka kwake kuchuluka ndi ma values ​​kuchokera pa column Ndalama Zowonjezera. Mu formula bar ya cell D3 Lowani =C3/$B$9 Ndi kukanikiza Lowani. Chizindikiro $ imapanga chitsimikiziro chamtheradi kotero kuti mtengo wake (cell reference B9) sichisintha mukakopera fomula pansi.
7. Dinani kawiri chokhomera chodzaza zokha kuti mudzaze gawoli ndi fomula, kapena dinani chikhomo ndikuchikoka kudutsa pamndandanda wa data.
8. Tsopano zonse zakonzeka kuyamba kupanga tchati cha Pareto!

Gawo Lachiwiri: Kupanga Tchati cha Pareto mu Excel

1. Sankhani deta (mwachitsanzo, ma cell kuchokera A2 by D8).
2. Press Alt + F1 pa kiyibodi kuti mupange zokha tchati kuchokera pa data yosankhidwa.
3. Dinani kumanja m'dera la tchati ndipo kuchokera pamenyu yomwe ikuwonekera, dinani Sankhani deta (Sankhani Data). A dialog box adzaoneka Kusankha gwero la data (Sankhani Gwero la Data). Sankhani mzere Ndalama Zowonjezera Ndi kukanikiza Chotsani (Chotsani). Ndiye OK.
4. Dinani pa graph ndikugwiritsa ntchito mivi pa kiyibodi yanu kuti musunthe pakati pa zinthu zake. Pamene mzere wa deta wasankhidwa Zowonjezera %, yomwe tsopano ikugwirizana ndi gulu la axis (yopingasa), dinani pomwepa ndikusankha Sinthani mtundu wa tchati kukhala mndandanda (Sinthani Mtundu wa Ma chart Chart). Tsopano mndandanda wazinthuzi ndizovuta kuwona, koma zotheka.
5. A dialog box adzaoneka Sinthani mtundu wa tchati (Sintha Mtundu wa Tchati), sankhani tchati cha mzere.
6. Chifukwa chake, tili ndi histogram ndi graph ya mzere wathyathyathya motsatira njira yopingasa. Kuti tiwonetse mpumulo wa graph ya mzere, tifunika mzere wina woyimirira.
7. Dinani kumanja pamzere Zowonjezera % ndi menyu yomwe ikuwoneka, dinani Mawonekedwe a mndandanda wa data (Format Data Series). Bokosi lazokambirana la dzina lomweli lidzawonekera.
8. Mu gawo Zosankha za Mzere (Series Options) sankhani Axis yaying'ono (Secondary Axis) ndikudina batani Close (Tsekani).
9. Maperesenti axis adzawonekera, ndipo tchaticho chidzasanduka tchati cha Pareto chokwanira! Tsopano titha kunena kuti: kuchuluka kwa ndalama zake ndi ndalama zolipirira maphunziro (Ndalama Zophunzitsira), zida (Iron) ndi zolemba (zothandizira kuofesi).

Ndi malangizo a pang'onopang'ono pakukhazikitsa ndikupanga tchati cha Pareto ku Excel chomwe chili pafupi, yesani kuchita. Pogwiritsa ntchito kusanthula kwa Pareto, mutha kuzindikira zovuta zazikulu ndikuchitapo kanthu kuti muwathetse.