{"id":4840,"date":"2023-07-07T09:01:18","date_gmt":"2023-07-07T09:01:18","guid":{"rendered":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/"},"modified":"2023-07-07T09:01:18","modified_gmt":"2023-07-07T09:01:18","slug":"diagram-kotak-horizontal-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/","title":{"rendered":"Cara membuat plot kotak horizontal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara membuat plot kotak horizontal berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37818\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox10.png\" alt=\"plot kotak horizontal di Excel\" width=\"547\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data berikut yang menunjukkan poin yang dicetak oleh 15 pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37808 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox1.png\" alt=\"\" width=\"433\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung nilai plot<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin membuat diagram kotak horizontal untuk memvisualisasikan distribusi nilai titik.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/kumis-kotak\/\" target=\"_blank\" rel=\"noopener\">Plot kotak<\/a> (terkadang disebut plot kotak) adalah bagan yang memperlihatkan ringkasan lima digit kumpulan data, yang mencakup<\/span> <span style=\"color: #000000;\">nilai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Minimum<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuartil pertama<\/span><\/li>\n<li> <span style=\"color: #000000;\">median<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kuartil ketiga<\/span><\/li>\n<li> <span style=\"color: #000000;\">Maksimum<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung kelima nilai ini serta nilai yang akan ditampilkan pada diagram kotak horizontal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37809 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox2.png\" alt=\"\" width=\"562\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sisipkan Diagram Batang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>D7:D9<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon yang disebut <b>Batang Bertumpuk<\/b> di grup <strong>Bagan<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37810 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/barre-de-pile.png\" alt=\"\" width=\"448\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37811 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox3.png\" alt=\"\" width=\"531\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada grafik, lalu klik <strong>Pilih Data<\/strong> di menu drop-down yang muncul, lalu klik tombol bernama <strong>Ubah Baris\/Kolom<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , grafiknya sekarang akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37812 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox4.png\" alt=\"\" width=\"540\" height=\"325\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Ubah Diagram Batang menjadi Plot Kotak<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya klik kanan bar berwarna biru, lalu klik icon <strong>Fill<\/strong> , lalu klik <strong>No Fill<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37813 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox5.png\" alt=\"\" width=\"531\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikutnya, klik bilah no-fill, lalu klik tanda tambah kecil berwarna hijau di sudut kanan atas plot, lalu klik panah drop-down di sebelah <strong>Error Bars<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37814 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox6.png\" alt=\"\" width=\"676\" height=\"305\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Error Bar Format<\/strong> yang muncul di sisi kanan layar, klik <strong>Custom<\/strong> , lalu klik tombol bernama <strong>Specify Value<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37787 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il6.png\" alt=\"\" width=\"328\" height=\"612\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, ketik <strong>0<\/strong> untuk <strong>nilai kesalahan positif<\/strong> dan <strong>D10 f<\/strong> atau kotak <strong>Nilai kesalahan negatif<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37815 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox7.png\" alt=\"\" width=\"664\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Ulangi proses untuk kotak abu-abu, gunakan <strong>0<\/strong> untuk <strong>nilai error negatif<\/strong> dan <strong>D11<\/strong> untuk <strong>nilai error positif<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37816 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox8.png\" alt=\"\" width=\"674\" height=\"346\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik kanan pada bilah oranye dan pilih <strong>No Fill<\/strong> untuk <strong>Fill<\/strong> dan <strong>Black<\/strong> untuk <strong>Outline<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses ini untuk bilah abu-abu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Plot kotak terakhir akan terlihat seperti ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37817 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox9.png\" alt=\"\" width=\"528\" height=\"322\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Dari boxplot, kita dapat melihat ringkasan lima angka dari dataset:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kumis kiri memberi tahu kita bahwa nilai minimumnya adalah <strong>5<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Garis di sisi kiri kotak memberitahu kita bahwa Q1 adalah <strong>6<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Garis di dalam kotak memberitahu kita bahwa nilai mediannya adalah <strong>8<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Garis di sebelah kanan kotak memberitahu kita bahwa Q3 adalah <strong>12<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kumis kanan memberitahu kita bahwa nilai maksimumnya adalah <strong>17<\/strong> .<\/span><\/li>\n<\/ul>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 5: Sesuaikan Plot Kotak (Opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan judul, menyesuaikan warna, dan menyesuaikan lebar kumis agar plot lebih mudah dibaca.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Plot terakhirnya mungkin terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37818 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox10.png\" alt=\"\" width=\"547\" height=\"323\" srcset=\"\" sizes=\"\"><\/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> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-menambahkan-garis-rata-rata-ke-diagram-batang\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Garis Rata-Rata ke Diagram Batang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-poligon-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Poligon Frekuensi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-sebar-garis-horizontal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis horizontal ke scatterplot di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini memberikan contoh langkah demi langkah cara membuat plot kotak horizontal berikut di Excel: Ayo pergi! Langkah 1: Masukkan datanya Pertama, mari buat kumpulan data berikut yang menunjukkan poin yang dicetak oleh 15 pemain bola basket berbeda: Langkah 2: Hitung nilai plot Misalkan kita ingin membuat diagram kotak horizontal untuk memvisualisasikan distribusi nilai titik. [&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 Plot Kotak Horizontal di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram kotak horizontal 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\/diagram-kotak-horizontal-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Kotak Horizontal di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram kotak horizontal di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T09:01:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox10.png\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/\",\"name\":\"Cara Membuat Plot Kotak Horizontal di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T09:01:18+00:00\",\"dateModified\":\"2023-07-07T09:01:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram kotak horizontal di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot kotak horizontal 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 Membuat Plot Kotak Horizontal di Excel - Statorials","description":"Tutorial ini menjelaskan cara membuat diagram kotak horizontal 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\/diagram-kotak-horizontal-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Kotak Horizontal di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara membuat diagram kotak horizontal di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T09:01:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hbox10.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/","url":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/","name":"Cara Membuat Plot Kotak Horizontal di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T09:01:18+00:00","dateModified":"2023-07-07T09:01:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram kotak horizontal di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/diagram-kotak-horizontal-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot kotak horizontal 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\/4840"}],"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=4840"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4840\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}