Maitiro ekuvaka a Lorentz curve muExcel

Kuti uongorore mwero wekusaenzana pakati pezvikamu zvakasiyana zvehuwandu hwevanhu munharaunda, iyo Lorentz curve uye inobviswa kubva kune chiratidzo chake - iyo ginny coeffient inowanzoshandiswa. Nekubatsira kwavo, zvinokwanisika kuona kuti yakakura sei makomba munharaunda pakati pehupfumi uye nzvimbo dzekugara dzevagari. Uchishandisa zvishandiso zvekushandisa Excel: Unogona kufambisa zvakanyanya maitiro ekugadzira iyo Lorentz curve. Ngatione, sezvo munzvimbo yeExcel kuti iitwe mukuita.

Uchishandisa Lorentz curve

Iyo Lorentz curve ndeyekuwanzoita basa rekugovera rakaratidzwa zvakajeka. Maererano neX axis yebasa iri, huwandu hwehuwandu hwevanhu muzana muzana retio rekuwedzera, uye pamwe neY axis ndiyo huwandu hwehuwandu hwemari yenyika. Chaizvoizvo, Lorentz curve pachayo ine mapoinzi, imwe neimwe inoenderana neyepesenti ratio yeiyo mari yemari yeimwe chikamu chenzanga. Iyo yakakura iyo Lorentz mutsara ndeye, iyo yakawanda munharaunda iyo nhanho yekusaenzana.

Mumamiriro ezvinhu akakodzera mairi hapana kusaenzana kweruzhinji, rimwe nerimwe boka revagari rine mwero wemari inoenderana zvakananga kune nhamba yayo. Mutsetse unoratidza mamiriro akadaro anonzi akaenzana curve, kunyangwe iri tambo yakatwasuka. Iyo yakakura nzvimbo yemufananidzo, shoma Lorentz curve uye yakaenzana curve, yakakwira iyo nhanho yekusaenzana munharaunda.

Lorentz curve inogona kushandiswa kwete chete kuti uone mamiriro ekuparadzaniswa nenzvimbo, mune imwe nyika kana munharaunda, asiwo nekuenzanisa muchikamu ichi chemhuri dzeumwe neumwe.

Vertical yakatwasuka mutsara, iyo inobatanidza mutsara wekuenzana uye iyo kure kure pfungwa yeiyo Lorentz curve inonzi iyo Hover Index kana Robin Hood. Ichi chikamu chinoratidza kuti ndeupi kukura kwemari yekuwanikwazve munharaunda kuti uwane kuenzana kwakazara.

Chikamu chekusaenzana munharaunda chakafungidzirwa uchishandisa indekisi yeGinny, iyo inogona kusiyana kubva ku0 kusvika ku 1. Inonzi zvakare iyo coeff fiffation yekuisa mari.

Kuvaka Kuenzanisa Mutsetse

Zvino ngatione pane chaiyo muenzaniso, maitiro ekugadzira mutsara wekuenzana uye Lorentz curve muExcel. Kuti uite izvi, shandisa tafura yehuwandu hwehuwandu hwakaputsika mumapoka mashanu akaenzana (20%), ayo anopfupikiswa patafura nekuwedzera. Muchikamu chechipiri cheiyi tafura iyi, huwandu hwemari yenyika mune muzana retio, iyo inoenderana neboka chairo revagari riripo.

Kutanga, isu tinogadzira mutsara wekuenzana zvachose. Iyo ichave nemapango maviri - zero uye point yemari yenyika yeNyika ye100% yehuwandu.

1. Enda kune "Insert" tab. Pamutsetse mu "Diagram" Tool block, tinya pane "Spot" bhatani. Ndiwo rudzi urwu rwemadhizaina yakakodzera kune yedu basa. Izvi zvinotevera zvinovhura rondedzero yezvinyorwa zvechirati. Sarudza "yakaonekwa neyakaoma curves uye mamaki."



2. Mushure mekuita uku kunoitwa nzvimbo isina chinhu kune chati. Zvakaitika nekuti hatina kusarudza iyo data. Kuti uite data uye kuvaka chati, tinya pane bhatani rebushi re mbeva pane imwe nzvimbo isina chinhu. Mune iyo yakagadziriswa mamiriro menyu, sarudza iyo "Sarudza data ..." chinhu.



3. Iyo data sosi yekusarudza hwindo rinovhura. Mukuruboshwe kwazviri, izvo zvinonzi "zvinhu zvengarava (manhamba)" nekudzvanya pane "Wedzera" bhatani.



4. Iwindo rewindo rinoshandurwa. Mu "Row zita" munda, unonyora zita remuti wedhirowa ratinoda kugovera. Inogona zvakare kuve iri papepa uye mune iyi kesi iwe unofanirwa kutsanangura kero yesero renzvimbo yayo. Asi kwatiri zvatiri zviri nyore kungoisa zita racho. Isu tinopa dhizaini zita rekuti "mutsara wekuenzana".

   MuX X Kukosha Munda, iwe unofanirwa kudoma iwo ematanho eiyo dhizaini padhuze ne x axis Munda iri.

   Mu "v Vanokosha" munda, marongero emakonzo pamwe neY axis anofanirwa kunyorwa. Kuchave neaviri: 0 uye 35.9. Pfungwa yekupedzisira, sezvatinogona kuona zvichienderana nehurongwa, hunosangana nemari yehuwandu hwenyika zana muzana yehuwandu. Saka, nyora izvo zvinokoshesa "0; 35,9" pasina makotesheni.

   Mushure mezvose zvakaratidzwa data yakagadzirwa, tinya pane "OK" bhatani.



5. Mushure meizvozvo, tinodzokera kuDaini Source Section Window. IN it, zvakare, tinya pane "OK" bhatani.



6. Sezvatinogona kuona, mushure mekuita zviri pamusoro, mutsara wakaenzana uchavakwa uye uchaonekwa papepa.

Chidzidzo: Maitiro Ekuita Chati Muhutapwa

Kugadzira murentz curve

Zvino isu tinofanirwa kuvaka zvakananga muLorentz curve, tichivimba neiyo tabular data.

1. Rudyi-tinya pane dhizaini nharaunda, pane iyo iyo mutsara wakaenzana watowanikwa. Mumamita ekumhanya, imbomira kusarudzwa pane "Sarudza data ...".



2. Iyo data yekusarudza data inovhura zvakare. Sezvatinoona, pakati pezvisikwa, zita rekuti "mutsara wekuenzana" hwatove hwatoratidzwa, asi isu tinofanirwa kugadzira imwe chati. Naizvozvo, tinodzvanya pane "Wedzera" bhatani.



3. Iyo Windows Shanduko Window inovhura zvakare. Iyo "Row zita" munda, sekupedzisira, zadza zvakaona. Pano unogona kupinda muzita rekuti "Lorentz curve".

   Mu "X x kukosha" munda, zvese data yekhoramu "% yehuwandu" patafura yedu inofanira kuiswa. Kuti uite izvi, isa iyo isaior kunzvimbo yemunda. Tevere, clamp iyo kuruboshwe bhatani bhatani uye sarudza iyo inoenderana mucheki pane pepa. Iwo maironga anozoratidzwa ipapo mumutsara shanduko hwindo.

   Mu "v vanokoshesa" munda, takapinda marongero emasero ecolumn "mari yenyika". Isu tinoita izvi zvichienderana nehunyanzvi humwechete hwakagadzirwa data mumunda wapfuura.

   Mushure mezvese data iri pamusoro rakagadzirwa, tinya iyo "OK" bhatani.



4. Mushure mekudzokera kuWindows Section Window, tinya pane "OK" bhatani.



5. Sezvatinogona kuona, mushure mekuita zviito zviri pamusoro apa, iyo Lorentz Curve icharatidzwawo pane pepa rekutsva.

Kuvakwa kweiyo Lorentz curve uye mutsara wakaenzana muExcel inogadzirwa pane iwo maitiro akafanana nekuvakwa kwemamwe marudzi ezvipuro muchirongwa ichi. Naizvozvo, kune vashandisi vakabata kugona kuvaka madhaagiramu uye graphs muExpressi, iri basa harifanirwe kukonzera matambudziko makuru.