{"id":2001,"date":"2023-07-24T03:30:58","date_gmt":"2023-07-24T03:30:58","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/"},"modified":"2023-07-24T03:30:58","modified_gmt":"2023-07-24T03:30:58","slug":"plot-interval-kepercayaan-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/","title":{"rendered":"Cara merencanakan interval keyakinan di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Interval kepercayaan<\/strong> mewakili rentang nilai yang kemungkinan berisi <a href=\"https:\/\/statorials.org\/id\/statistik-vs-parameter\/\" target=\"_blank\" rel=\"noopener\">parameter populasi<\/a> dengan tingkat kepercayaan tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Merencanakan Interval Keyakinan pada Grafik Batang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki data berikut di Excel yang memperlihatkan rata-rata empat kategori berbeda bersama dengan margin kesalahan yang sesuai untuk interval kepercayaan 95%:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18814 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelleci1.png\" alt=\"\" width=\"490\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk membuat diagram batang guna memvisualisasikan rata-rata kategori, sorot sel dalam rentang <strong>A1:B5<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas. Lalu klik <strong>Sisipkan Kolom atau Bagan Batang<\/strong> di grup Bagan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan grafik batang berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18815 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/intrigueci2.png\" alt=\"\" width=\"548\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menambahkan pita interval kepercayaan, klik tanda tambah (+) di sudut kanan atas diagram batang, lalu klik <strong>Bilah Kesalahan<\/strong> , lalu klik <strong>Opsi Lainnya<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18816 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelleci3.png\" alt=\"\" width=\"625\" height=\"291\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sebelah kanan, klik tombol <strong>Kustom<\/strong> di bagian bawah. Pada jendela baru yang muncul, pilih <strong>=Sheet1!$C$2:$C$5<\/strong> untuk nilai error positif dan nilai error negatif. Lalu klik <strong>oke<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18817 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/traceci4.png\" alt=\"\" width=\"429\" height=\"541\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan pita interval kepercayaan berikut pada diagram batang:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18818 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelleci5.png\" alt=\"\" width=\"442\" height=\"291\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk juga mengubah warna batang agar pita interval kepercayaan lebih mudah dilihat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18820\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelleci6.png\" alt=\"plot interval kepercayaan di Excel\" width=\"525\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Bagian atas bilah mewakili nilai rata-rata untuk setiap kategori dan bilah kesalahan menunjukkan kisaran interval kepercayaan untuk setiap rata-rata.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai rata-rata untuk kategori A adalah 12 dan selang kepercayaan 95% untuk rata-rata ini adalah 10 sampai 14.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai mean untuk kategori B adalah 15 dan selang kepercayaan 95% untuk mean ini adalah 12 hingga 18.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai mean untuk kategori C adalah 18 dan selang kepercayaan 95% untuk mean ini adalah 13 sampai 23.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai mean untuk kategori D adalah 13 dan selang kepercayaan 95% untuk mean ini adalah 10 sampai 16.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> Pengantar Interval Keyakinan<br \/> <a href=\"https:\/\/statorials.org\/id\/interval-kepercayaan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Interval Keyakinan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/margin-kesalahan-vs-interval-kepercayaan\/\" target=\"_blank\" rel=\"noopener\">Margin kesalahan dan interval kepercayaan: apa bedanya?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Interval kepercayaan mewakili rentang nilai yang kemungkinan berisi parameter populasi dengan tingkat kepercayaan tertentu. Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel. Contoh 1: Merencanakan Interval Keyakinan pada Grafik Batang Katakanlah kita memiliki data berikut di Excel yang memperlihatkan rata-rata empat kategori berbeda bersama dengan margin kesalahan yang sesuai untuk interval [&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 Merencanakan Interval Keyakinan di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel, beserta contohnya.\" \/>\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\/plot-interval-kepercayaan-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Merencanakan Interval Keyakinan di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T03:30:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelleci1.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\/plot-interval-kepercayaan-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/\",\"name\":\"Cara Merencanakan Interval Keyakinan di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T03:30:58+00:00\",\"dateModified\":\"2023-07-24T03:30:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara merencanakan interval keyakinan di excel: dengan contoh\"}]},{\"@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 Merencanakan Interval Keyakinan di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel, beserta contohnya.","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\/plot-interval-kepercayaan-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Merencanakan Interval Keyakinan di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-24T03:30:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelleci1.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\/plot-interval-kepercayaan-unggul\/","url":"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/","name":"Cara Merencanakan Interval Keyakinan di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T03:30:58+00:00","dateModified":"2023-07-24T03:30:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot interval kepercayaan pada diagram batang di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-interval-kepercayaan-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara merencanakan interval keyakinan di excel: dengan contoh"}]},{"@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\/2001"}],"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=2001"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2001\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}