{"id":1908,"date":"2023-07-24T12:24:19","date_gmt":"2023-07-24T12:24:19","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/"},"modified":"2023-07-24T12:24:19","modified_gmt":"2023-07-24T12:24:19","slug":"grafik-excel-distribusi-binomial","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/","title":{"rendered":"Cara membuat bagan distribusi binomial di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-binomial-1\/\" target=\"_blank\" rel=\"noopener\">Distribusi binomial<\/a> digunakan untuk menggambarkan probabilitas diperolehnya <em>k<\/em> keberhasilan dalam <em>n<\/em> percobaan binomial.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Eksperimen binomial adalah eksperimen yang mempunyai sifat-sifat sebagai berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Percobaan terdiri dari n percobaan berulang.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Setiap percobaan hanya memiliki dua kemungkinan hasil.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Probabilitas keberhasilan, dilambangkan dengan p, adalah sama untuk setiap percobaan.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Setiap tes bersifat independen.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jika suatu variabel acak <em>X<\/em> mengikuti distribusi binomial, maka peluang keberhasilan <em>X<\/em> = <em>k<\/em> dapat dicari dengan rumus berikut:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">P(X=k) = <sub>n<\/sub> C <sub>k<\/sub> * p <sup>k<\/sup> * (1-p) <sup>nk<\/sup><\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> : jumlah percobaan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>k<\/strong> : jumlah keberhasilan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>p<\/strong> : probabilitas keberhasilan pada suatu percobaan tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><sub>n<\/sub> C <sub>k<\/sub><\/strong> : banyaknya cara untuk memperoleh k keberhasilan dalam n percobaan<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara membuat bagan distribusi binomial di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Bagan Distribusi Binomial di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat grafik distribusi binomial, pertama-tama kita perlu menentukan nilai <em>n<\/em> (jumlah percobaan) dan <em>p<\/em> (probabilitas keberhasilan dalam percobaan tertentu):<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18224 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph1.png\" alt=\"\" width=\"542\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu membuat kolom untuk setiap kemungkinan jumlah keberhasilan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18225 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph2.png\" alt=\"\" width=\"504\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat menggunakan fungsi <strong>BINOM.DIST()<\/strong> untuk menghitung probabilitas binomial dari jumlah keberhasilan pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18226 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph3.png\" alt=\"\" width=\"576\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke sel lainnya di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18227 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph4.png\" alt=\"\" width=\"548\" height=\"456\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menyorot masing-masing probabilitas binomial, lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik <strong>ikon Sisipkan Kolom atau Bagan Batang<\/strong> di grup <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18228 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph5.png\" alt=\"\" width=\"620\" height=\"631\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x pada grafik menunjukkan jumlah keberhasilan dalam 8 percobaan dan sumbu y menunjukkan probabilitas yang sesuai dari jumlah keberhasilan tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda mengubah nilai <em>n<\/em> atau <em>p<\/em> , grafik akan otomatis berubah untuk mencerminkan probabilitas baru.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/distribusi-binomial-1\/\" target=\"_blank\" rel=\"noopener\">Pengenalan distribusi binomial<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/bentuk-distribusi-binomial\/\" target=\"_blank\" rel=\"noopener\">Memahami bentuk distribusi binomial<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/contoh-nyata-distribusi-binomial\/\" target=\"_blank\" rel=\"noopener\">5 contoh konkrit distribusi binomial<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi binomial digunakan untuk menggambarkan probabilitas diperolehnya k keberhasilan dalam n percobaan binomial. Eksperimen binomial adalah eksperimen yang mempunyai sifat-sifat sebagai berikut: Percobaan terdiri dari n percobaan berulang. Setiap percobaan hanya memiliki dua kemungkinan hasil. Probabilitas keberhasilan, dilambangkan dengan p, adalah sama untuk setiap percobaan. Setiap tes bersifat independen. Jika suatu variabel acak X mengikuti [&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 Bagan Distribusi Binomial di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat bagan distribusi binomial 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\/grafik-excel-distribusi-binomial\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Distribusi Binomial di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat bagan distribusi binomial di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T12:24:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph1.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\/grafik-excel-distribusi-binomial\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/\",\"name\":\"Cara Membuat Bagan Distribusi Binomial di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T12:24:19+00:00\",\"dateModified\":\"2023-07-24T12:24:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat bagan distribusi binomial di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan distribusi binomial 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 Bagan Distribusi Binomial di Excel - Statologi","description":"Tutorial ini menjelaskan cara membuat bagan distribusi binomial 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\/grafik-excel-distribusi-binomial\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Distribusi Binomial di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara membuat bagan distribusi binomial di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/","og_site_name":"Statorials","article_published_time":"2023-07-24T12:24:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/binomgraph1.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\/grafik-excel-distribusi-binomial\/","url":"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/","name":"Cara Membuat Bagan Distribusi Binomial di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T12:24:19+00:00","dateModified":"2023-07-24T12:24:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat bagan distribusi binomial di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan distribusi binomial 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\/1908"}],"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=1908"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1908\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}