{"id":4838,"date":"2023-07-07T09:31:09","date_gmt":"2023-07-07T09:31:09","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/"},"modified":"2023-07-07T09:31:09","modified_gmt":"2023-07-07T09:31:09","slug":"excel-menambahkan-bilah-kesalahan-horizontal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/","title":{"rendered":"Bagaimana menambahkan bilah kesalahan horizontal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin menambahkan bilah kesalahan horizontal ke bagan di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan berikut dengan bilah kesalahan horizontal di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37795\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb4.png\" alt=\"bilah kesalahan horizontal di Excel\" width=\"582\" height=\"353\" 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 kita buat kumpulan data berikut yang menunjukkan bagaimana berbagai analis olahraga memberi peringkat pada pemain bola basket tertentu selama lima tahun pertamanya di liga:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il1.png\" alt=\"\" width=\"512\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung mean dan deviasi standar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan rumus berikut di sel <strong>B6<\/strong> dan <strong>B7<\/strong> untuk menghitung mean dan deviasi standar nilai setiap tahun:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>B6 :<\/strong> = RATA-RATA (B2 : B5)<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>B7:<\/strong> =STDEV(B2: B5)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret masing-masing rumus ini ke kanan untuk menghitung mean dan deviasi standar nilai setiap tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37783 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il2.png\" alt=\"\" width=\"525\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sisipkan Diagram Batang Horizontal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>B6:F6<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon bernama <b>Bilah 2D<\/b> di grup <strong>Bagan<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36411 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/programme1.png\" alt=\"\" width=\"337\" height=\"319\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Diagram batang horizontal berikut akan dibuat untuk menunjukkan rata-rata peringkat pemain dalam lima tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37792 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb1.png\" alt=\"\" width=\"527\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Bilah Kesalahan Horizontal<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik di mana saja pada grafik, lalu klik tanda tambah kecil berwarna hijau di sudut kanan atas grafik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian centang kotak di sebelah <strong>Error Bars<\/strong> untuk menambahkan bilah kesalahan horizontal ke setiap bilah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37793 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb2.png\" alt=\"\" width=\"593\" height=\"270\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik salah satu bilah kesalahan horizontal untuk menampilkan panel <strong>Format Error Bars<\/strong> di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik <strong>Custom<\/strong> , lalu klik tombol berlabel <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>=Sheet1!$B$7:$F$7<\/strong> untuk kotak <strong>Nilai Kesalahan Positif<\/strong> dan <strong>Nilai Kesalahan Negatif<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37788 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/il7-2.png\" alt=\"\" width=\"306\" height=\"233\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , bilah kesalahan horizontal akan ditambahkan ke setiap bilah pada bagan untuk menampilkan deviasi standar nilai setiap tahun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37794 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb3.png\" alt=\"\" width=\"658\" height=\"551\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semakin lebar garis kesalahannya, semakin besar pula variasi skor dari tahun ke tahun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, simpangan baku nilai Kelas 1 adalah <strong>0,9574<\/strong> dan simpangan baku nilai Kelas 2 adalah <strong>0,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini menjelaskan mengapa garis kesalahan horizontal pada tahun pertama hampir dua kali lebih lebar dibandingkan pada tahun kedua.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 5: Sesuaikan bagan (opsional)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan judul, menyesuaikan warna, menghapus garis kisi, menyesuaikan lebar bilah kesalahan, dan menambahkan label sumbu 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=\"aligncenter wp-image-37795\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb4.png\" alt=\"bilah kesalahan horizontal di Excel\" width=\"582\" height=\"353\" 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>Terkadang Anda mungkin ingin menambahkan bilah kesalahan horizontal ke bagan di Excel. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan berikut dengan bilah kesalahan horizontal di Excel: Ayo pergi! Langkah 1: Masukkan datanya Pertama, mari kita buat kumpulan data berikut yang menunjukkan bagaimana berbagai analis olahraga memberi peringkat pada pemain bola basket [&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 Menambahkan Error Bar Horizontal di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan horizontal 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\/excel-menambahkan-bilah-kesalahan-horizontal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambahkan Error Bar Horizontal di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan horizontal di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T09:31:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb4.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\/excel-menambahkan-bilah-kesalahan-horizontal\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/\",\"name\":\"Cara Menambahkan Error Bar Horizontal di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T09:31:09+00:00\",\"dateModified\":\"2023-07-07T09:31:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan horizontal di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana menambahkan bilah kesalahan 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 Menambahkan Error Bar Horizontal di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan horizontal 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\/excel-menambahkan-bilah-kesalahan-horizontal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Error Bar Horizontal di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan horizontal di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/","og_site_name":"Statorials","article_published_time":"2023-07-07T09:31:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/eb4.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\/excel-menambahkan-bilah-kesalahan-horizontal\/","url":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/","name":"Cara Menambahkan Error Bar Horizontal di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T09:31:09+00:00","dateModified":"2023-07-07T09:31:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan horizontal di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-horizontal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana menambahkan bilah kesalahan 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\/4838"}],"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=4838"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4838\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}