{"id":2092,"date":"2023-07-23T17:54:52","date_gmt":"2023-07-23T17:54:52","guid":{"rendered":"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/"},"modified":"2023-07-23T17:54:52","modified_gmt":"2023-07-23T17:54:52","slug":"bilah-kesalahan-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/","title":{"rendered":"Bagaimana cara menambahkan bilah kesalahan ke bagan di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda mungkin sering ingin menambahkan <strong>bilah kesalahan<\/strong> ke diagram di Google Spreadsheet untuk menangkap ketidakpastian seputar pengukuran atau nilai yang dihitung.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan berkat fitur pembuatan bagan bawaan Google Sheets.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menambahkan bilah kesalahan ke histogram di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan beberapa nilai data ke dalam Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19458 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles1.png\" alt=\"\" width=\"519\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat histogram<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari masukkan histogram. Sorot sel <strong>A1:B6<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> dan klik <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19459 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles2.png\" alt=\"\" width=\"454\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela <strong>Chart Editor<\/strong> di sisi kanan layar, klik <strong>Chart Type<\/strong> lalu klik <strong>Histogram<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19460 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles3.png\" alt=\"\" width=\"350\" height=\"555\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagan kolom berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19465 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles0.png\" alt=\"\" width=\"513\" height=\"324\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sisipkan Bilah Kesalahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menyisipkan bilah kesalahan, klik tab <strong>Kustomisasi<\/strong> di jendela Editor Bagan. Gulir ke bawah dan klik <strong>Seri<\/strong> , lalu centang kotak di samping <strong>Bilah kesalahan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19461 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles4.png\" alt=\"\" width=\"355\" height=\"727\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, bilah kesalahan yang mewakili 10% ukuran setiap kolom akan ditampilkan di bagan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19462 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuilles-derreur5.png\" alt=\"\" width=\"517\" height=\"329\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Sesuaikan Bilah Kesalahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ada tiga jenis bilah kesalahan yang dapat Anda gunakan di histogram Google Spreadsheet:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Persentase (default)<\/span><\/li>\n<li> <span style=\"color: #000000;\">Konstan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Deviasi standar<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat memilih untuk menampilkan bilah kesalahan konstan dengan panjang 5 untuk setiap kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19463 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles6.png\" alt=\"\" width=\"367\" height=\"295\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bilah kesalahan dengan panjang 5 akan ditambahkan ke setiap kolom bagan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19464 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles7.png\" alt=\"\" width=\"522\" height=\"342\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Silakan memilih salah satu dari tiga jenis bilah kesalahan yang akan ditampilkan, bergantung pada tampilan bagan yang Anda inginkan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara membuat visualisasi umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/plot-kotak-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Kotak di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-pareto-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Pareto di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda mungkin sering ingin menambahkan bilah kesalahan ke diagram di Google Spreadsheet untuk menangkap ketidakpastian seputar pengukuran atau nilai yang dihitung. Untungnya, hal ini mudah dilakukan berkat fitur pembuatan bagan bawaan Google Sheets. Contoh langkah demi langkah berikut menunjukkan cara menambahkan bilah kesalahan ke histogram di Google Spreadsheet. Langkah 1: Masukkan datanya Mari kita mulai [&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 ke bagan di Google Spreadsheet \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet, dengan beberapa 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\/bilah-kesalahan-google-sheets\/\" \/>\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 ke bagan di Google Spreadsheet \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T17:54:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/\",\"name\":\"Cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T17:54:52+00:00\",\"dateModified\":\"2023-07-23T17:54:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan bilah kesalahan ke bagan di google spreadsheet\"}]},{\"@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 ke bagan di Google Spreadsheet \u2013 Statologi","description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet, dengan beberapa 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\/bilah-kesalahan-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-23T17:54:52+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/erreurfeuilles1.png"}],"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\/bilah-kesalahan-google-sheets\/","url":"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/","name":"Cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T17:54:52+00:00","dateModified":"2023-07-23T17:54:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan bilah kesalahan ke bagan di Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bilah-kesalahan-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan bilah kesalahan ke bagan di google spreadsheet"}]},{"@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\/2092"}],"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=2092"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2092\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}