Kuti muwunike kusiyana pakati pa magawo osiyanasiyana a anthu, gulu limagwiritsa ntchito Lorentz pamapindikira ndi chizindikiro chake - Ginny coeffanele. Kugwiritsa ntchito izi, mutha kudziwa kuti kusiyana kwakukulu pakati pa anthu ndi magawo olemera kwambiri komanso osauka kwambiri. Pogwiritsa ntchito zida za Excel application, muthanso kusintha njira yopangira Lorentz pamapindikira. Tiyeni tiwone momwe m'malo a Excel izi zingachitikira.
Kugwiritsa ntchito Lorentz Curve
Lorentz pamapindikira ndi gawo logawidwa logawidwa bwino. Pamodzi ndi axis X ntchitoyi ndi kuchuluka kwa chiwerengero cha anthu monga peresenti yowonjezereka, komanso m'mbali Y - kuchuluka kwazopeza dziko. Kwenikweni ,jika la Lorentz limakhala ndi mfundo, zomwe zimafanana ndi gawo limodzi la gawo la gawo la gawo la anthu. Mzere wa Lorentz utapindika, ndi pomwe pali kusiyana pakati pa anthu.
Munthawi yabwino momwe mulibe kusagwirizana pakati pa anthu, gulu lirilonse limapeza gawo lolingana molingana ndi kukula kwake. Mzere wokhala ndi zoterezi umatchedwa kuti equity curve, ngakhale ndi mzere wowongoka. Kukula kwakukulu kwa malo omwe kuli chifanizirocho ndi Lorentz pamapindikira ndi kukondana kofanana, ndikokulitsa kwa kusiyana pakati pa anthu.
Mphepo ya Lorenz ingagwiritsidwe ntchito osati kungodziwa momwe zinthu ziliri mdziko lapansi, m'dziko linalake kapena pagulu, komanso poyerekeza gawo ili la mabanja.
Mzere wokhazikika womwe umalumikiza mzere wofanana komanso mbali yakutali kwambiri yajika la Lorentz umatchedwa index wa Hoover kapena Robin Hood. Gawoli likuwonetsa kuchuluka kwa ndalama zomwe zimayenera kugawidwa m'magulu kuti zitheke kufanana.
Mlingo wa kusalingana pagulu watsimikiza kugwiritsa ntchito index ya Ginny, yomwe imatha kusiyanasiyana 0 kale 1. Amatchulidwanso kuti kuchuluka kwa ndende.
Kupanga mzere wofanana
Tsopano tiyeni tiwone chitsanzo cha konkire cha momwe mungapangire mzere wofanana ndi kanjira ka Lorentz ku Excel. Kuti tichite izi, timagwiritsa ntchito tebulo la anthu omwe agawika m'magulu asanu ofanana (ndi 20%), zomwe zimafotokozedwa mwachidule patebulo. Gawo lachiwiri la tebulo ili limapereka phindu la chuma cha dziko monga peresenti, yomwe ikufanana ndi gulu linalake la anthu.
Poyamba, timanga mzere wofanana kwambiri. Idzakhala ndi mfundo ziwiri - ziro ndi gawo la chuma chonse cha 100% yaanthu.
- Pitani ku tabu Ikani. Mzere pabokosi yazida Ma chart dinani batani "Spot". Ndi mtundu uwu wajambula womwe uli woyenera ntchito yathu. Zotsatirazi zikutsegulira mndandanda wazithunzi zamitundu ina. Sankhani "Spot yokhala ndi ma curve osalala ndi zimpawu".
- Mukamaliza kuchita izi, malo opanda chithunzithunzi amatsegulidwa. Izi zidachitika chifukwa sitinasankhe zomwe tasankhazo. Kuti mulowetse data ndikupanga graph, dinani kumanja pamalo opanda kanthu. Pazosankha zomwe zakhazikitsidwa, sankhani "Sankhani zambiri ...".
- Tsamba losankha deta limatsegulidwa. Gawo lakumanzere, lomwe limatchedwa "Zambiri za nthano (mizere)" dinani batani Onjezani.
- Zenera losintha mzere liyambira. M'munda "Dzina la mzere" lembani dzina la tchati chomwe tikufuna kutiigawire. Itha kupezekanso pa pepala ndipo pamenepa muyenera kufotokoza adilesi ya foni yamalo ake. Koma ife, ndizosavuta kungolowetsa dzinalo. Patsani tchati dzina "Mzere wa Zofanana".
M'munda "Ma X X" muyenera kutchulira zogwirizanitsa za mfundo zomwe zili pamwambo wa tchati X. Monga tikumbukirira, padzakhala awiri okha: 0 ndi 100. Timalemba izi kudzera mu semicolon pamunda uno.
M'munda "Zofunika" lembani zolumikizira za mfundozo kumapeto kwa axiz Y. Padzakhalanso awiri a iwo: 0 ndi 35,9. Mfundo yomaliza, monga tikuwonera pachithunzichi, ikufanana ndi ndalama zonse za dziko 100% kuchuluka. Chifukwa chake, lembani zofunikira "0;35,9" opanda mawu.
Pambuyo polemba zonse zomwe zatchulidwa, dinani batani "Zabwino".
- Pambuyo pake, timabwerera pazenera losankha deta. Mmenemo, muyenera dinani batani "Zabwino".
- Monga mukuwonera, zitachitika izi pamwambapa, mzere wazofanana udzamangidwa ndikuwonetsedwa papepala.
Phunziro: Momwe mungapangire chithunzi mu Excel
Pangani Lorentz Curve
Tsopano tiyenera kupanga mwachindunji kupindika kwa Lorentz, kutengera idatha ya tabular.
- Timadina pomwe pamalopo pazithunzi zomwe mzere wa equation wapezeka kale. Pazosankha zomwe zimayambira, siyimitsanso kusankha pazomwezo "Sankhani zambiri ...".
- Zenera losankha deta limatsegulanso. Monga mukuwonera, pakati pazinthu dzinalo limaperekedwa kale "Mzere wa Zofanana"koma tifunika kupanga chojambula china. Chifukwa chake dinani batani Onjezani.
- Zenera losintha mzere limatsegulanso. Mundawo "Dzina la mzere"monga nthawi yomaliza, lembani pamanja. Dzinali lingathe kulembedwa apa. "Lorentz.
M'munda "Ma X X" lembani zonse zosankha "% ya anthu" tebulo lathu. Kuti muchite izi, ikani cholozera chapafupi ndi gawo lanu. Kenako, gwiritsani batani lakumanzere ndikusankha lingaliro lolingana nalo. Ogwirizanawo awonetsedwa pomwepo pawindo losintha.
M'munda "Zofunika" lowetsani zolumikizana zama cell "Kuchuluka kwa chuma cha dziko". Timachita izi molingana ndi njira yomweyo yomwe idatha idalowetsedwa m'munda wam'mbuyo.
Pambuyo polemba deta yonse pamwambapa, dinani batani "Zabwino".
- Mukabwereranso pazenera lasankhidwe lankhani, batani batani kachiwiri "Zabwino".
- Monga mukuwonera, mutatha kuchita izi pamwambapa ,jika la Lorentz liziwonetsedwanso patsamba lantchito la Excel.
Kupanga kwa lorentz curve ndi mzere wofanana ku Excel kumachitika pa mfundo zofananazo ndi kupanga mtundu wina uliwonse wa pulogalamuyi. Chifukwa chake, kwa ogwiritsa ntchito omwe amadziwa bwino kupanga ma chart ndi ma graph ku Excel, ntchitoyi siyiyenera kuyambitsa mavuto akulu.
