{"id":4839,"date":"2023-07-07T09:04:04","date_gmt":"2023-07-07T09:04:04","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/"},"modified":"2023-07-07T09:04:04","modified_gmt":"2023-07-07T09:04:04","slug":"excel-menambahkan-bilah-kesalahan-khusus","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/","title":{"rendered":"Cara menambahkan bilah kesalahan kustom di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin menambahkan bilah kesalahan khusus 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 kustom di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37804\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce5.png\" alt=\"Bilah Kesalahan Kustom Excel\" width=\"537\" height=\"357\" 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: Masukkan diagram sebar<\/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>Cloud<\/b> di grup <strong>Charts<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"566\" height=\"233\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot sebar berikut akan dibuat untuk menunjukkan rata-rata peringkat pemain dalam lima tahun terakhir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37800 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce1.png\" alt=\"\" width=\"570\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Bilah Kesalahan Kustom<\/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>Bilah Kesalahan<\/strong> untuk menambahkan bilah kesalahan vertikal dan horizontal ke setiap titik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37801 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce2.png\" alt=\"\" width=\"579\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik salah satu bilah kesalahan horizontal dan tekan <strong>Hapus<\/strong> untuk menghapus setiap bilah kesalahan horizontal dari setiap titik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik salah satu bilah kesalahan vertikal 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-37802 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce3.png\" alt=\"\" width=\"304\" height=\"608\" 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 vertikal 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-37803 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce4.png\" alt=\"\" width=\"642\" height=\"551\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Semakin panjang bilah kesalahannya, semakin besar perbedaan 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 batang kesalahan vertikal pada tahun pertama hampir dua kali lebih panjang 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-37804\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce5.png\" alt=\"Bilah Kesalahan Kustom Excel\" width=\"537\" height=\"357\" 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\/excel-menambahkan-bilah-kesalahan-horizontal\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Menambahkan Bilah Kesalahan Horizontal 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 khusus ke bagan di Excel. Tutorial ini memberikan contoh langkah demi langkah tentang cara membuat bagan berikut dengan bilah kesalahan kustom 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 Bilah Kesalahan Kustom di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan khusus ke bagan 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\/excel-menambahkan-bilah-kesalahan-khusus\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambahkan Bilah Kesalahan Kustom di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan khusus ke bagan di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T09:04:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce5.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-khusus\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/\",\"name\":\"Cara Menambahkan Bilah Kesalahan Kustom di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T09:04:04+00:00\",\"dateModified\":\"2023-07-07T09:04:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan khusus ke bagan di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan bilah kesalahan kustom 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 Bilah Kesalahan Kustom di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan khusus ke bagan 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\/excel-menambahkan-bilah-kesalahan-khusus\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Bilah Kesalahan Kustom di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan khusus ke bagan di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/","og_site_name":"Statorials","article_published_time":"2023-07-07T09:04:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ce5.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-khusus\/","url":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/","name":"Cara Menambahkan Bilah Kesalahan Kustom di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T09:04:04+00:00","dateModified":"2023-07-07T09:04:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan khusus ke bagan di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menambahkan-bilah-kesalahan-khusus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan bilah kesalahan kustom 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\/4839"}],"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=4839"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4839\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}