Lub hauv paus ntsiab lus Pareto, muaj npe tom qab tus kws tshawb fawb Italian Vilfredo Pareto, hais tias 80% ntawm cov teeb meem tuaj yeem tshwm sim los ntawm 20% ntawm qhov ua rau. Lub hauv paus ntsiab lus tuaj yeem muaj txiaj ntsig zoo lossis txawm tias cov ntaub ntawv cawm txoj sia thaum koj yuav tsum xaiv qhov twg ntawm ntau qhov teeb meem los daws ua ntej, lossis yog tias kev tshem tawm cov teeb meem nyuaj los ntawm cov xwm txheej sab nraud.
Piv txwv li, koj nyuam qhuav raug hais kom coj ib pab neeg uas muaj teeb meem ua haujlwm ntawm ib qhov project los taw tes rau lawv txoj hauv kev. Koj nug cov tswv cuab ntawm pab pawg dab tsi yog lawv cov teeb meem tseem ceeb hauv kev ua tiav lawv cov hom phiaj thiab lub hom phiaj. Lawv ua ib daim ntawv teev npe uas koj txheeb xyuas thiab nrhiav seb qhov twg yog qhov laj thawj tseem ceeb ntawm txhua qhov teeb meem uas pab pawg tau ntsib, sim ua kom pom qhov sib xws.
Txhua qhov kev kuaj pom ua rau muaj teeb meem yog npaj raws li qhov zaus ntawm lawv qhov tshwm sim. Saib ntawm cov lej, koj pom tias qhov tsis muaj kev sib txuas lus ntawm cov neeg siv qhov project thiab cov neeg muaj feem cuam tshuam txog qhov project yog lub hauv paus ua rau cov teeb meem sab saum toj 23 uas pab pawg ntsib, thaum qhov teeb meem loj thib ob yog nkag mus rau cov peev txheej tsim nyog (lub tshuab computer, khoom siv, thiab lwm yam. .). .) ua rau tsuas yog 11 qhov teeb meem cuam tshuam. Lwm yam teeb meem raug cais tawm. Nws yog qhov tseeb tias los ntawm kev daws teeb meem kev sib txuas lus, feem pua ntawm cov teeb meem loj tuaj yeem raug tshem tawm, thiab los ntawm kev daws qhov teeb meem ntawm kev nkag mus rau cov peev txheej, yuav luag 90% ntawm cov teeb meem hauv pab pawg txoj kev tuaj yeem daws tau. Tsis tsuas yog koj xav paub yuav ua li cas pab pawg, koj nyuam qhuav ua Pareto tsom xam.
Ua tag nrho cov hauj lwm no rau ntawm daim ntawv yuav siv sij hawm ntau npaum li cas. Cov txheej txheem tuaj yeem ua kom nrawm heev siv Pareto daim ntawv hauv Microsoft Excel.
Pareto kab kos yog ib qho kev sib txuas ntawm kab ntawv thiab histogram. Lawv txawv nyob rau hauv uas lawv feem ntau muaj ib kab rov tav axis (qeb axis) thiab ob ntsug axes. Daim ntawv qhia muaj txiaj ntsig zoo rau kev ua ntej thiab txheeb xyuas cov ntaub ntawv.
Kuv txoj haujlwm yog los pab koj npaj cov ntaub ntawv rau Pareto daim ntawv qhia thiab tom qab ntawd tsim daim ntawv nws tus kheej. Yog tias koj cov ntaub ntawv twb tau npaj rau daim ntawv Pareto, ces koj tuaj yeem mus rau ntu thib ob.
Niaj hnub no peb yuav txheeb xyuas qhov teeb meem teeb meem hauv lub tuam txhab uas niaj hnub them nyiaj rov qab rau cov neeg ua haujlwm rau cov nuj nqis. Peb txoj haujlwm yog txhawm rau txheeb xyuas qhov peb siv nyiaj ntau tshaj plaws thiab nkag siab tias peb tuaj yeem txo cov nqi no li cas los ntawm 80% siv qhov kev ntsuam xyuas Pareto ceev. Peb tuaj yeem tshawb xyuas seb tus nqi them li cas rau 80% ntawm cov nyiaj rov qab thiab tiv thaiv tus nqi siab yav tom ntej los ntawm kev hloov txoj cai los siv cov nqi lag luam wholesale thiab sib tham txog cov neeg ua haujlwm cov nqi.
Ntu Ib: Npaj cov ntaub ntawv rau daim ntawv Pareto
- Npaj koj cov ntaub ntawv. Hauv peb lub rooj, muaj 6 pawg ntawm cov nyiaj them poob haujlwm thiab cov nyiaj tau thov los ntawm cov neeg ua haujlwm.
- Cais cov ntaub ntawv nyob rau hauv qis qis. Xyuas tias cov kab ntawv raug xaiv А и Вtxheeb kom raug.
- Kum Sum nyiaj (tus naj npawb ntawm cov nuj nqis) suav nrog kev ua haujlwm sum (SUM). Hauv peb qhov piv txwv, txhawm rau kom tau txais tag nrho cov nyiaj, koj yuav tsum tau ntxiv cov hlwb los ntawm V3 rau V8.
Hotkey: Txhawm rau suav cov nqi ntau, xaiv ib lub xovtooj B9 thiab nias Alt + =. Tus nqi tag nrho yuav yog $12250.
- Tsim ib kab Cov Nyiaj Tau Los (ntau npaum li cas). Cia peb pib nrog thawj tus nqi $ 3750 hauv cell B3. Txhua tus nqi yog nyob ntawm tus nqi ntawm lub xov tooj yav dhau los. Hauv ib lub cell C4 hom = C3+B4 thiab nias Sau.
- Txhawm rau ua kom tau txais cov cell seem nyob rau hauv ib kem, nyem ob npaug rau autofill kov.
- Tom ntej no, tsim ib kab Nce % (ntau feem pua). Txhawm rau sau cov kab no, koj tuaj yeem siv cov lej ntawm qhov ntau nyiaj thiab qhov tseem ceeb ntawm kab Cov Nyiaj Tau Los. Nyob rau hauv lub formula bar rau ib tug cell D3 nkag mus =C3/$B$9 thiab nias Sau. Cim $ tsim ib qho kev siv kiag li hais tias tus nqi (xov tooj siv B9) tsis hloov thaum koj luam cov qauv.
- Muab ob npaug rau-nias lub autofill marker los sau cov kab ke nrog cov qauv, lossis nyem rau ntawm lub cim thiab luag nws hla cov kab ntawv.
- Tam sim no txhua yam yog npaj los pib tsim daim ntawv Pareto!
Ntu XNUMX: Tsim Pareto Chart hauv Excel
- Xaiv cov ntaub ntawv (hauv peb qhov piv txwv, cell los ntawm A2 by D8).
- Xovxwm Alt + F1 ntawm cov keyboard kom cia li tsim ib daim duab los ntawm cov ntaub ntawv xaiv.
- Right-click nyob rau hauv daim ntawv qhia cheeb tsam thiab los ntawm cov ntawv qhia zaub mov uas tshwm, nyem Xaiv cov ntaub ntawv (Xaiv cov ntaub ntawv). Ib lub dialog box yuav tshwm sim Xaiv cov ntaub ntawv qhov chaw (Xaiv Data Source). Xaiv kab Cov Nyiaj Tau Los thiab nias tshem tawm (Tshem tawm). Ces OK.
- Nyem rau ntawm daim duab thiab siv tus xub yuam sij ntawm koj cov keyboard kom txav ntawm nws cov ntsiab lus. Thaum ib kab ntawm cov ntaub ntawv raug xaiv Nce %, uas tam sim no coincides nrog qeb axis ( kab rov tav axis), right-click rau nws thiab xaiv Hloov hom kab kos rau ib series (Hloov kab ntawv Series hom). Tam sim no cov ntaub ntawv no nyuaj rau pom, tab sis ua tau.
- Ib lub dialog box yuav tshwm sim Hloov hom kab kos (Hloov hom kab ntawv), xaiv kab kab kos.
- Yog li, peb tau txais ib qho histogram thiab ib kab kab ncaj nraim raws kab kab rov tav. Txhawm rau kom pom qhov nyem ntawm kab teeb, peb xav tau lwm txoj kab ntsug.
- Txoj nyem rau ntawm kab Nce % thiab hauv cov ntawv qhia zaub mov uas tshwm, nyem Cov ntaub ntawv series (Format Data Series). Lub dialog box ntawm tib lub npe yuav tshwm sim.
- Hauv seem Kab Options (Series Options) xaiv Minor Axis (Secondary Axis) thiab nias lub pob Close (Kaw).
- Qhov feem pua axis yuav tshwm sim, thiab daim ntawv qhia yuav tig mus rau hauv daim ntawv qhia Pareto tag nrho! Tam sim no peb tuaj yeem kos cov lus xaus: feem ntau ntawm cov nqi yog cov nqi kawm ntawv (Cov Nqi Kawm Ntawv), cov khoom siv (Iron) thiab cov ntawv sau (cov khoom siv hauv chaw ua haujlwm).
Nrog cov lus qhia ua ntu zus rau kev teeb tsa thiab tsim daim ntawv Pareto hauv Excel ntawm tes, sim ua nws hauv kev xyaum. Los ntawm kev siv Pareto tsom xam, koj tuaj yeem txheeb xyuas cov teeb meem tseem ceeb tshaj plaws thiab ua ib kauj ruam tseem ceeb los daws lawv.