Uburyo bwo kubaka umurongo wa lorentz muri excel

Gusuzuma urwego rwubusumbane hagati yabaturage batandukanye b'abaturage, umurongo wa Lorentz hamwe n'ikiruhuko cyerekana ibimenyetso bye - ubufatanye bwa Ginny bukoreshwa kenshi. Ufashijwe nabo, birashoboka kumenya uburyo icyuho kinini muri societe hagati yice zikize kandi zikennye cyane zabaturage. Ukoresheje ibikoresho bya porogaramu Excel, urashobora koroshya cyane uburyo bwo kubaka umurongo wa Lorentz. Reka turebe, nkuko mubidukikije bishobora gukorwa mubikorwa.

Gukoresha Umuyoboro wa Lorentz

Umuhanda wa Lorenz nicyo kintu gisanzwe cyo gukwirakwiza cyerekanwe mubishushanyo. Ukurikije x axis yiyi mikorere, umubare wabaturage mubipimo byijanisha byo kwiyongera, kandi kuri Y AXIS numubare rusange winjiza igihugu. Mubyukuri, umurongo wa Lorentz ubwayo ugizwe ningingo, buri kimwe muricyo gihuye nubutaka bwijanisha ryurwego rwinjiza igice runaka cya societe. Umurongo munini wa Lorentz ni, uko muri societe urwego rwubusumbane.

Mubihe byiza bidafite ubusumbane rusange, buri tsinda ryabaturage rifite urwego rwinjiza ruranga umubare wacyo. Umurongo uranga ibintu nkibi byitwa umurongo uringaniye, nubwo ari umurongo ugororotse. Ikinini kinini cyishusho, umurongo ntarengwa wa Lorentz hamwe numurongo ungana, urwego rwo hejuru urwego rwuzuye muri societe.

Umuyoboro wa Lorentz urashobora gukoreshwa kugirango umenye uko ibintu bitandukanya umutungo kwisi, mugihugu runaka cyangwa muri societe, ariko no kugereranya muriyi ngingo.

Umurongo ugororotse, uhuza umurongo wuburinganire hamwe numwanya wa kure cyane wumuhanda wa Lorentz bita isoko rya Hoover cyangwa Robin Hood. Iki gice cyerekana ubunini bwinjiza kugirango ugabanye muri societe kugirango ugere kuburinganire bwuzuye.

Urwego rwubusumbane muri societe rugenwa gukoresha indangagaciro za Ginny, zirashobora gutandukana kuva 0 kugeza 1. kandi zitwa kandi koperatifike yinjiza.

Kubaka umurongo

Noneho reka turebe kurugero rwihariye, uburyo bwo gukora umurongo wuburinganire na Lorentz umurongo muri excel. Kugira ngo ukore ibi, koresha imbonerahamwe yabaturage bamenetse mumatsinda atanu angana (20%), akubiye muri make mumeza yiyongera. Mu nkingi ya kabiri y'iyi mbonerahamwe, umubare w'amafaranga yigihugu mu kigereranyo cy'ijanisha, ihuye n'itsinda ryihariye ry'abaturage ritangwa.

Gutangira, twubaka umurongo wuburinganire. Bizaba bigizwe nududomo tubiri - zeru kandi dufite amafaranga yose yigihugu kubaturage 100%.

1. Jya kuri tab "shyiramo". Ku murongo muri "igishushanyo" ibikoresho, kanda kuri buto "Ikibanza". Ubu bwoko bwibishushanyo bukwiye kubikorwa byacu. Ibikurikira bifungura urutonde rwigitutsi. Hitamo "Kugaragara hamwe n'imirongo myiza n'ibimenyetso."



2. Nyuma yiki gikorwa gikorwa ahantu habuze imbonerahamwe. Byarabaye kubera ko tutahisemo amakuru. Kugirango ukore amakuru no kubaka imbonerahamwe, kanda kuri buto yimbeba iburyo mukarere ka ubusa. Muri menu ikora, hitamo "Hitamo amakuru ..." ikintu.



3. Idirishya ryo gutoranya amakuru rifungura. Ibumoso bwayo, bwitwa "ibintu byimigani (urwego)" bakanda kuri buto "Ongeraho".



4. Idirishya Guhindura Idirishya ryatangijwe. Mumwanya wa "umurongo witwa", wandika izina ryigishushanyo dushaka kugenera. Irashobora kandi kuba ku rupapuro kandi muriki gihe ukeneye kwerekana aderesi ya selire aho yahantu. Ariko mubyukuri biroroshye kwinjiza izina ryintoki. Dutanga igishushanyo izina "umurongo wuburinganire".

   Mumwanya wa X, ugomba kwerekana imirongo yishusho kuri x axis. Iyo twibutse, hazabaho bibiri gusa: 0 na 100. Twanditse iyo ndangagaciro tunyuze kuri koma Muri uyu murima.

   Muri "V indangagaciro", guhuza ingingo kuri Y AXIS bigomba kwandikwa. Hazabaho byombi: 0 na 35.9. Ingingo ya nyuma, nkuko dushobora kubona dukurikije gahunda, twujuje amafaranga yose yigihugu yabaturage 100%. Noneho, andika indangagaciro "0; 35.9" udafite amagambo.

   Nyuma yamakuru yose yerekanwe, kanda kuri buto ya "OK".



5. Nyuma yibyo, dusubira mumadirishya yo guhitamo amakuru. Muri yo, nayo, kanda buto ya "OK".



6. Nkuko dushobora kubibona, nyuma yibi bikorwa byavuzwe haruguru, umurongo uringaniye uzaba wubatswe kandi uzagaragara kurupapuro.

Isomo: Uburyo bwo gukora imbonerahamwe mu buhungiro

Gukora Umuyoboro wa Lorentz

Noneho tugomba kubaka mu buryo butaziguye umurongo wa Lorentz, twishingikirije ku makuru ya tangabururu.

1. Kanda iburyo ku gice cyashushanyije, aho umurongo ungana usanzwe uherereye. Muri menu ikora, guhagarika guhitamo kuri "Hitamo amakuru ...".



2. Idirishya ryo gutoranya amakuru rifungura. Nkuko tubibona, mubintu, izina "umurongo wuburinganire" rimaze gutangwa, ariko dukeneye gukora indi mbonerahamwe. Kubwibyo, twongeyeho buto "Ongeraho".



3. Idirishya ryo Guhindura Idirishya rifungura. "Izina ryumurongo" umurima, nkigihe cyanyuma, uzuzuze intoki. Hano urashobora kwinjiza izina "Lorentz umurongo".

   Muri "x agaciro", amakuru yose yinkingi "% yabaturage" yimeza yacu igomba gukoreshwa. Kugirango ukore ibi, shyira indanga kumurima. Ibikurikira, vuga buto yimbeba yibumoso hanyuma uhitemo inkingi ihuye kurupapuro. Umuhuza uzahita yerekanwa kumurongo uhindura idirishya.

   Muri "V indangagaciro", twinjije ihuriro rya selile yinkingi "amafaranga yigihugu yishyurwa". Ibi turabikora dukurikije tekinike imwe amakuru yakozwe mumurima wabanjirije.

   Nyuma yamakuru yose yavuzwe haruguru akorwa, kanda buto "OK".



4. Nyuma yo gusubira mumadirishya yo gutoranya inkomoko, kanda kuri buto "OK".



5. Nkuko dushobora kubibona, nyuma yo gukora ibikorwa byavuzwe haruguru, umurongo wa Lorentz narwo ruzerekanwa kurupapuro rwa Excel.

Kubaka umurongo wa Lorentz hamwe numurongo uringaniye muri Excel bikorerwa kumahame amwe nkubwubatsi nyabwo bwimboso ubwo aribwo bwose muriyi gahunda. Kubwibyo, kubakoresha bafashe ubushobozi bwo kubaka ibishushanyo n'ibishushanyo muri Excel, iki gikorwa ntigikwiye gutera ibibazo bikomeye.