Momwe mungapangire okhotakhotakhota

Kuti muwone kuchuluka kwa kusalingana pakati pa zigawo zingapo za kuchuluka kwa anthu, kupindika kwa Lorentz ndi kuchotsedwa kwa chizindikiro chake - cholumikizira cha ginny nthawi zambiri chimagwiritsidwa ntchito. Mothandizidwa ndi iwo, ndizotheka kudziwa kuti pali kusiyana kwakukulu pakati pa zigawo zolemera kwambiri komanso zosautsa. Kugwiritsa ntchito Zida Zogwiritsa Ntchito Excel, mutha kuthandizira kwambiri njira yopangira wokhotakhota. Tiyeni tiwone, monga momwe zimakhalira bwino malo.

Kugwiritsa ntchito lorentz

Wopindika wa Lorentz ndi ntchito yogawika yomwe imawonetsedwa modabwitsa. Malinga ndi axis a ntchitoyi, chiwerengero cha anthu omwe ali mu gawo lomwe likuwonjezereka, ndipo motsatira y axis ndiye chiwerengero chonse cha ndalama zapadziko lonse. Kwenikweni, wowonera yekhayo ali ndi mfundo, iliyonse yomwe imafanana ndi kuchuluka kwa ndalama zomwe zimapezeka mgawo lina. Chingwe chokulirapo cha Lorentz ndi, makamaka pagulu momwe mulibe mawonekedwe.

M'zochitika zoyenera zomwe palibe kusalingana pagulu, gulu lililonse la anthu lili ndi ndalama zopeza mwachindunji ndi nambala yake. Mzere wonena izi umatchedwa kufanana, ngakhale ndi mzere wowongoka. Kukulirapo gawo la chiwerengerochi, lorentz curve ndi chofanana ndi kupindika, kuchuluka kwa mawonekedwe adziko.

Lorentz Curve sangagwiritsidwe ntchito osati kungodziwa momwe zinthu zalekanitsira padziko lapansi, m'dziko linalake kapena pagulu, komanso kuyerekezera mbali iyi ya mabanja amodzi.

Mzere wolunjika wowongoka, womwe umalumikiza mzere wa kufanana ndi malo akutali kwambiri a lorentz amatchedwa index kapena robin hood. Gawo ili likuwonetsa kukula kwa ndalama zoguliranso pagulu kuti mukwaniritse kufanana.

Mulingo wa kusalingana pagulu ndikutsimikizika pogwiritsa ntchito mlozera wa ginny, womwe umatha kusiyanasiyana kuchokera ku 0 mpaka 1. umatchedwanso zolimba za Chuma.

Mzere Womanga

Tsopano tiyeni tiwone mwachitsanzo, momwe mungapangire mzere wa kufanana ndi Lorentz Convel mu Excel. Kuti muchite izi, gwiritsani ntchito tebulo la kuchuluka kwa anthu omwe adasokonekera m'magulu asanu ofanana (20%), omwe amafotokozedwa mwachidule patebulo pakukula. Mu mzere wachiwiri wa tebulo ili, kuchuluka kwa ndalama zapadziko lonse mu gawo lomwe likugwirizana, zomwe zikufanana ndi gulu linalake la anthu.

Poyamba, timapanga mzere wa kufanana. Imakhala ndi madontho awiri - zero ndi mfundo za ndalama zonse zapadziko lonse lapansi.

1. Pitani ku "kuyika" tabu. Pa mzere mu "chithunzi" chotchinga, dinani batani la "malo". Ndi mawonekedwe amtunduwu omwe ali oyenera ntchito yathu. Izi zimayambitsa mndandanda wa subpeccies ya ma chart. Sankhani "Wowombera ndi ma curves osalala ndi zikwangwani."



2. Pambuyo pa izi zimachitidwa malo opanda kanthu pa tchati. Zinachitika chifukwa sitinasankhe data. Pofuna kupanga deta ndikupanga tchati, dinani batani la mbewa kumanja padera. Mu menyu oyambitsidwa, sankhani "Sankhani deta ya" chinthu ".



3. Zenera losankha deta lotseguka. Kumanzere kwa iyo, komwe kumatchedwa "zinthu za nthano (zigawo)" podina batani la "Onjezani".



4. Zenera losintha zenera limayambitsidwa. Mu "mzere dzina" m'munda, mumalemba dzina la chithunzi chomwe tikufuna kupatsa. Itha kukhala pa pepalalo ndipo munkhaniyi muyenera kufotokozera adilesi ya cell yomwe ikupezeka. Koma kwa ife ndizosavuta kungolowetsa dzinalo. Timapereka dzina "mzere wofanana".

   Mu gawo la X Mtengo, muyenera kutchula malo ogwirizira a chithunzi cha X AXIS. Pamene tikukumbukira, padzakhala awiri okha: 0 ndi 100. Timalemba zomwe zili ndi comma. Mu gawo ili.

   Mu "Muyezo" m'munda, magwiridwe antchito a y axis ayenera kulembedwa. Padzakhalanso awiri: 0 mpaka 35.9. Mfundo yomaliza, monga titha kuwona molingana ndi ndandandayi, imakwaniritsa ndalama zonse za anthu 100%. Chifukwa chake, lembani zomwe zili "0; 35.9" popanda mawu.

   Pambuyo pa zomwe zidawonetsedwa zonse zimapangidwa, dinani batani la "OK".



5. Pambuyo pake, timabwereranso ku zenera la Data. Mmenemo, inunso, dinani batani la "OK".



6. Monga tikuonera, pambuyo pa zomwe zili pamwambazi, mzere wofanana udzamangidwa ndipo udzawonekera papepala.

Phunziro: Momwe Mungapangire tchati

Kupanga chopitira

Tsopano tiyenera kupanga molunjika mwachindunji kuzungulira, ndikudalira deta yaulemu.

1. Dinani kumanja pa zojambulajambula, zomwe mzere wofanana uli kale. Mu menyu oyendetsa, siyani kusankha pa "DEXT Data ...".



2. Windo la data losankha limatseguka. Monga tikuwona, pakati pa zinthu, dzina "lofanana" lafotokozedwa kale, koma tiyenera kupanga tchati china. Chifukwa chake, timadina batani la "Onjezani".



3. Zenera losintha zenera limatseguka. Munda wa "mzere", ngati nthawi yomaliza, nudzazeni pamanja. Apa mutha kulowa dzina "Lorentz Curve".

   M'munda wa "x mtengo", deta yonse ya mzati "% ya anthu" patebulo lathu iyenera kugwiritsidwa ntchito. Kuti muchite izi, ikani cholozera kumtunda. Kenako, kwezani batani lamanzere la mbewa ndikusankha mzati wolingana papepala. Zogwirizana ziwonetsedwa nthawi yomweyo mu mzere zimasintha zenera.

   Mu "MPHAMI" YAO, tinalowa m'maselo a maselo a "Chuma Chachilengedwe". Timachita izi molingana ndi njira yomweyo momwe data yomwe idapangidwira m'munda wapitawa.

   Pambuyo pazomwe zili pamwambapa zimapangidwa, kanikizani batani la "OK".



4. Pambuyo pobwerera ku zenera losankha, dinani batani la "Ok".



5. Monga tikuwonera, mutatha kuchita zomwe zili pamwambapa, zopindika za Lorentz zidzawonetsedwanso papepala la Excel.

Ntchito yomanga yopindika ya Lorentz ndi mzere wofanana mu Excel imapangidwa pamkhalidwe womwewo pomanga ma chart ena onse mu pulogalamuyi. Chifukwa chake, kwa ogwiritsa ntchito omwe adagwira mphamvu yomanga zojambula ndi zitsulo zomwe zikuchulukirachulukira, ntchitoyi siyenera kuyambitsa mavuto akulu.