{"id":3143,"date":"2023-07-19T00:25:25","date_gmt":"2023-07-19T00:25:25","guid":{"rendered":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/"},"modified":"2023-07-19T00:25:25","modified_gmt":"2023-07-19T00:25:25","slug":"kurva-lorenz-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/","title":{"rendered":"Cara membuat kurva lorenz di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dinamakan berdasarkan nama ekonom Amerika <a href=\"https:\/\/en.wikipedia.org\/wiki\/Max_O._Lorenz\" target=\"_blank\" rel=\"noopener\">Max Lorenz<\/a> , <strong>kurva Lorenz<\/strong> adalah cara untuk memvisualisasikan distribusi pendapatan suatu populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara membuat kurva Lorenz berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26743\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz8.jpg\" alt=\"Kurva Lorenz di Excel\" width=\"573\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kita perlu memasukkan nilai untuk dua kolom: populasi kumulatif dan pendapatan kumulatif individu di negara tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26726 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/giniexcel1.jpg\" alt=\"\" width=\"470\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan nilai:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">20% orang termiskin di negara ini mewakili <strong>10%<\/strong> total pendapatan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">50% penduduk termiskin di negara ini mewakili <strong>31%<\/strong> total pendapatan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">60% masyarakat termiskin di negara ini mewakili <strong>40%<\/strong> total pendapatan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">100% individu di negara ini menyumbang <strong>100%<\/strong> total pendapatan.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan memasukkan nilai (x, y) untuk garis persamaan yang nantinya akan kita tambahkan ke grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26736 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenze1.jpg\" alt=\"\" width=\"506\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Kurva Lorenz Dasar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai di sel <strong>A2:B6<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik opsi <strong>Sebar dengan Garis Halus<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26737 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz2.jpg\" alt=\"\" width=\"498\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan berikut akan dibuat secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26738 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz3.jpg\" alt=\"\" width=\"508\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada grafik dan klik opsi yang bertuliskan <strong>Select Data<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, klik <strong>Tambah<\/strong> di bawah <strong>Entri Legenda<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26739 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz4.jpg\" alt=\"\" width=\"579\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik tombol <strong>Tambah<\/strong> , lalu masukkan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26740 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz5.jpg\" alt=\"\" width=\"365\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , garis persamaan diagonal secara otomatis akan ditambahkan ke plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26741 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz6.jpg\" alt=\"\" width=\"477\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kurva Lorenz dasar telah selesai. Garis biru melambangkan kurva Lorenz dan garis oranye melambangkan garis persamaan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan Kurva Lorenz<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menyesuaikan tampilan grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik tanda tambah hijau ( <strong>+<\/strong> ) di pojok kanan atas grafik, lalu klik <strong>Legenda<\/strong> , lalu klik <strong>Bawah<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26742 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz7.jpg\" alt=\"\" width=\"454\" height=\"420\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Legenda akan ditambahkan di bagian bawah grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian, klik pada garis kisi grafik dan hapus garis tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik pada setiap baris dan ubah warnanya sesuai keinginan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, tambahkan judul sumbu pada sumbu X dan Y.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasil akhirnya akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26743\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz8.jpg\" alt=\"Kurva Lorenz di Excel\" width=\"573\" height=\"441\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Koefisien Gini di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dinamakan berdasarkan nama ekonom Amerika Max Lorenz , kurva Lorenz adalah cara untuk memvisualisasikan distribusi pendapatan suatu populasi. Tutorial ini memberikan contoh langkah demi langkah cara membuat kurva Lorenz berikut di Excel: Ayo pergi! Langkah 1: Masukkan datanya Pertama, kita perlu memasukkan nilai untuk dua kolom: populasi kumulatif dan pendapatan kumulatif individu di negara tertentu: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Membuat Kurva Lorenz di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat kurva Lorenz di Excel, beserta contoh lengkapnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Kurva Lorenz di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat kurva Lorenz di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T00:25:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz8.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/\",\"name\":\"Cara Membuat Kurva Lorenz di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T00:25:25+00:00\",\"dateModified\":\"2023-07-19T00:25:25+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat kurva Lorenz di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat kurva lorenz di excel (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Membuat Kurva Lorenz di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara membuat kurva Lorenz di Excel, beserta contoh lengkapnya.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Kurva Lorenz di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat kurva Lorenz di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-19T00:25:25+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lorenz8.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/","url":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/","name":"Cara Membuat Kurva Lorenz di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T00:25:25+00:00","dateModified":"2023-07-19T00:25:25+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat kurva Lorenz di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kurva-lorenz-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat kurva lorenz di excel (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3143"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3143"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3143\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}