{"id":1909,"date":"2023-07-24T12:21:38","date_gmt":"2023-07-24T12:21:38","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/"},"modified":"2023-07-24T12:21:38","modified_gmt":"2023-07-24T12:21:38","slug":"grafik-excel-sebaran-ikan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/","title":{"rendered":"Cara membuat bagan distribusi ikan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-ikan\/\" target=\"_blank\" rel=\"noopener\">Distribusi Poisson<\/a> menggambarkan probabilitas diperolehnya <em>k<\/em> keberhasilan selama interval waktu tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika suatu variabel acak <em>X<\/em> mengikuti distribusi Poisson, maka peluang keberhasilan <em>X<\/em> = <em>k<\/em> dapat dicari dengan rumus berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>P(X=k) = \u03bb <sup>k<\/sup> * e <sup>\u2013 \u03bb<\/sup> \/ k!<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03bb:<\/strong> jumlah rata-rata keberhasilan yang terjadi selama interval tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>k:<\/strong> jumlah keberhasilan<\/span><\/li>\n<li> <span style=\"color: #000000;\"><b>e:<\/b> konstanta sama dengan sekitar 2,71828<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara membuat bagan distribusi Poisson di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Bagan distribusi Poisson di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat grafik distribusi Poisson, pertama-tama kita perlu menentukan nilai \u03bb (jumlah rata-rata keberhasilan):<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18235 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph1.png\" alt=\"\" width=\"540\" height=\"425\" 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-18236 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph2.png\" alt=\"\" width=\"509\" height=\"449\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita mempunyai k = 10 kemungkinan keberhasilan. Kami dapat memilih lebih banyak, tetapi probabilitasnya menjadi sangat rendah untuk nilai yang lebih besar dari 10, seperti yang akan kita lihat nanti di artikel ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita dapat menggunakan fungsi <strong>POISSON.DIST()<\/strong> untuk menghitung probabilitas Poisson untuk jumlah keberhasilan pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph3.png\" alt=\"\" width=\"530\" height=\"448\" 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-18238 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph4.png\" alt=\"\" width=\"548\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menyorot masing-masing probabilitas Poisson, 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=\"aligncenter wp-image-18240\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph5-1.png\" alt=\"Bagan Distribusi Ikan di Excel\" width=\"678\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x pada grafik menunjukkan jumlah keberhasilan dan sumbu y menunjukkan probabilitas jumlah keberhasilan tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda mengubah nilai \u03bb (jumlah rata-rata keberhasilan), grafik akan otomatis berubah untuk mencerminkan probabilitas baru.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika kita mengubah nilai \u03bb menjadi 4, probabilitas Poisson dan grafik akan diperbarui secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18241\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph6.png\" alt=\"Plot distribusi Poisson di Excel\" width=\"672\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/kalkulator-distribusi-ikan\/\" target=\"_blank\" rel=\"noopener\">Kalkulator Distribusi Ikan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/distribusi-ikan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan distribusi Poisson di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/probabilitas-ikan-ti-84-kalkulator\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Probabilitas Poisson pada Kalkulator TI-84<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi Poisson menggambarkan probabilitas diperolehnya k keberhasilan selama interval waktu tertentu. Jika suatu variabel acak X mengikuti distribusi Poisson, maka peluang keberhasilan X = k dapat dicari dengan rumus berikut: P(X=k) = \u03bb k * e \u2013 \u03bb \/ k! Emas: \u03bb: jumlah rata-rata keberhasilan yang terjadi selama interval tertentu k: jumlah keberhasilan e: konstanta [&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 Ikan di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat diagram distribusi Poisson 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-sebaran-ikan\/\" \/>\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 Ikan di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat diagram distribusi Poisson di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T12:21:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph1.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-sebaran-ikan\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/\",\"name\":\"Cara Membuat Bagan Distribusi Ikan di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T12:21:38+00:00\",\"dateModified\":\"2023-07-24T12:21:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat diagram distribusi Poisson di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan distribusi ikan 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 Ikan di Excel - Statorials","description":"Tutorial ini menjelaskan cara membuat diagram distribusi Poisson 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-sebaran-ikan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Distribusi Ikan di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara membuat diagram distribusi Poisson di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/","og_site_name":"Statorials","article_published_time":"2023-07-24T12:21:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poissongraph1.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-sebaran-ikan\/","url":"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/","name":"Cara Membuat Bagan Distribusi Ikan di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T12:21:38+00:00","dateModified":"2023-07-24T12:21:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat diagram distribusi Poisson di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan distribusi ikan 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\/1909"}],"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=1909"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1909\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}