{"id":3142,"date":"2023-07-19T00:30:07","date_gmt":"2023-07-19T00:30:07","guid":{"rendered":"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/"},"modified":"2023-07-19T00:30:07","modified_gmt":"2023-07-19T00:30:07","slug":"koefisien-gini-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/","title":{"rendered":"Cara menghitung koefisien gini di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dinamakan berdasarkan ahli statistik Italia <a href=\"https:\/\/en.wikipedia.org\/wiki\/Corrado_Gini\" target=\"_blank\" rel=\"noopener\">Corrado Gini<\/a> , <strong>koefisien Gini<\/strong> adalah cara mengukur distribusi pendapatan suatu populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai koefisien Gini berkisar antara 0 sampai 1, dimana nilai yang lebih tinggi menunjukkan ketimpangan pendapatan yang lebih besar dan dimana:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>0<\/strong> mewakili kesetaraan pendapatan yang sempurna (setiap orang memiliki pendapatan yang sama)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> mewakili ketimpangan pendapatan sempurna (satu individu mempunyai seluruh pendapatan)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan daftar koefisien Gini menurut negara <a href=\"https:\/\/en.wikipedia.org\/wiki\/List_of_countries_by_income_equality\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara menghitung koefisien Gini di Excel.<\/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<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung luas di bawah kurva Lorenz<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menghitung masing-masing area di bawah <a href=\"https:\/\/en.wikipedia.org\/wiki\/Lorenz_curve\" target=\"_blank\" rel=\"noopener\">kurva Lorenz<\/a> , yaitu kurva yang kita gunakan untuk memvisualisasikan distribusi pendapatan di suatu negara.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh kita, kita akan mengetikkan rumus berikut di sel <strong>C3<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=( <span style=\"color: #3366ff;\">A3<\/span> - <span style=\"color: #ff0000;\">A2<\/span> )*( <span style=\"color: #800080;\">B3<\/span> + <span style=\"color: #008000;\">B2<\/span> )*0.5\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26729 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/giniexcel2.jpg\" alt=\"\" width=\"554\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung koefisien Gini<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> untuk menghitung koefisien Gini untuk populasi ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=1-2*SUM( <span style=\"color: #3366ff;\">C3:C6<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26730\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/giniexcel3.jpg\" alt=\"Koefisien Gini di Excel\" width=\"602\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koefisien Gini untuk populasi ini adalah <strong>0,226<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini adalah contoh yang sangat sederhana tentang cara menghitung koefisien Gini, namun Anda dapat menggunakan rumus yang sama persis untuk menghitung koefisien Gini untuk kumpulan data yang jauh lebih besar.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dinamakan berdasarkan ahli statistik Italia Corrado Gini , koefisien Gini adalah cara mengukur distribusi pendapatan suatu populasi. Nilai koefisien Gini berkisar antara 0 sampai 1, dimana nilai yang lebih tinggi menunjukkan ketimpangan pendapatan yang lebih besar dan dimana: 0 mewakili kesetaraan pendapatan yang sempurna (setiap orang memiliki pendapatan yang sama) 1 mewakili ketimpangan pendapatan sempurna [&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 menghitung koefisien Gini di Excel (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung koefisien Gini di Excel, dengan sebuah contoh.\" \/>\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\/koefisien-gini-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung koefisien Gini di Excel (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung koefisien Gini di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T00:30:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/giniexcel1.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\/koefisien-gini-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/\",\"name\":\"Cara menghitung koefisien Gini di Excel (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T00:30:07+00:00\",\"dateModified\":\"2023-07-19T00:30:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung koefisien Gini di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung koefisien gini 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 menghitung koefisien Gini di Excel (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghitung koefisien Gini di Excel, dengan sebuah contoh.","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\/koefisien-gini-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung koefisien Gini di Excel (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung koefisien Gini di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-19T00:30:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/giniexcel1.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\/koefisien-gini-unggul\/","url":"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/","name":"Cara menghitung koefisien Gini di Excel (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T00:30:07+00:00","dateModified":"2023-07-19T00:30:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung koefisien Gini di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/koefisien-gini-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/koefisien-gini-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung koefisien gini 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\/3142"}],"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=3142"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3142\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}