{"id":3751,"date":"2023-07-15T18:36:18","date_gmt":"2023-07-15T18:36:18","guid":{"rendered":"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/"},"modified":"2023-07-15T18:36:18","modified_gmt":"2023-07-15T18:36:18","slug":"hamparan-histogram-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/","title":{"rendered":"Cara overlay dua histogram di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Histogram<\/strong> adalah plot yang dapat digunakan untuk memvisualisasikan dengan cepat distribusi nilai dalam suatu kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara melapisi dua histogram dalam satu plot di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan jenis kelamin dan nilai ujian 20 siswa dalam satu kelas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30557 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo1.jpg\" alt=\"\" width=\"453\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat PivotTable<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang <strong>A1:C21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bernama <strong>PivotTable<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24299 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp0.jpg\" alt=\"\" width=\"642\" height=\"138\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela yang muncul, masukkan informasi berikut lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30558 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo2.jpg\" alt=\"\" width=\"657\" height=\"563\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Bidang PivotTable<\/strong> yang muncul di sisi kanan layar, seret variabel <strong>Skor<\/strong> ke kotak <strong>Baris<\/strong> dan <strong>Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30559 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo3.jpg\" alt=\"\" width=\"350\" height=\"620\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, klik panah tarik-turun <strong>Jumlah Skor<\/strong> , lalu klik <strong>Pengaturan Bidang Nilai<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30560 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo4.jpg\" alt=\"\" width=\"349\" height=\"588\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Hitung<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30561 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo5.jpg\" alt=\"\" width=\"412\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikutnya, klik nilai apa pun di PivotTable, lalu klik tab <strong>Analisis PivotTable<\/strong> , lalu klik <strong>Pilihan Grup<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30564 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo8.jpg\" alt=\"\" width=\"605\" height=\"194\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, kelompokkan data Mulai dari <strong>65<\/strong> , Berakhir pada <strong>100<\/strong> , Oleh <strong>5<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30565 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo9.jpg\" alt=\"\" width=\"496\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, seret variabel <strong>Gender<\/strong> ke area <strong>Kolom<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30563 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo6-1.jpg\" alt=\"\" width=\"385\" height=\"655\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikut tampilan tabel pivot yang diperbarui:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30566 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo10.jpg\" alt=\"\" width=\"492\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Tumpang tindih dua histogram dalam plot<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Analisis PivotTable<\/strong> , lalu klik ikon bernama <strong>PivotChart<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30567 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo11.jpg\" alt=\"\" width=\"583\" height=\"163\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih <strong>Clustered Column<\/strong> sebagai tipe bagan lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30568 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo12.jpg\" alt=\"\" width=\"627\" height=\"584\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Tabel berikut akan muncul:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30569\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo13.jpg\" alt=\"overlay dua histogram di Excel\" width=\"626\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bilah biru menunjukkan frekuensi nilai ujian untuk perempuan dan bilah oranye menunjukkan frekuensi untuk laki-laki.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Dua wanita dan dua pria memperoleh skor antara <strong>65 dan 69<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tidak ada perempuan dan dua laki-laki mendapat nilai antara <strong>70 dan 74<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tidak ada perempuan dan satu laki-laki mendapat nilai antara <strong>75 dan 79<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengubah lebar bin histogram di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan pengelompokan data di excel<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/analisis-data-eksplorasi-unggul\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Melakukan Analisis Data Eksplorasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Histogram adalah plot yang dapat digunakan untuk memvisualisasikan dengan cepat distribusi nilai dalam suatu kumpulan data. Tutorial ini memberikan contoh langkah demi langkah tentang cara melapisi dua histogram dalam satu plot di Excel. Langkah 1: Masukkan datanya Pertama, masukkan data berikut yang menunjukkan jenis kelamin dan nilai ujian 20 siswa dalam satu kelas: Langkah 2: [&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 overlay dua histogram di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara overlay dua histogram di Excel, dengan contoh langkah demi langkah.\" \/>\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\/hamparan-histogram-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara overlay dua histogram di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara overlay dua histogram di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T18:36:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo1.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\/hamparan-histogram-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/\",\"name\":\"Cara overlay dua histogram di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T18:36:18+00:00\",\"dateModified\":\"2023-07-15T18:36:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara overlay dua histogram di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara overlay dua histogram di excel\"}]},{\"@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 overlay dua histogram di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara overlay dua histogram di Excel, dengan contoh langkah demi langkah.","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\/hamparan-histogram-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara overlay dua histogram di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara overlay dua histogram di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-15T18:36:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histo1.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\/hamparan-histogram-excel\/","url":"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/","name":"Cara overlay dua histogram di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T18:36:18+00:00","dateModified":"2023-07-15T18:36:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara overlay dua histogram di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hamparan-histogram-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hamparan-histogram-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara overlay dua histogram di excel"}]},{"@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\/3751"}],"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=3751"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3751\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}