{"id":1897,"date":"2023-07-24T13:24:40","date_gmt":"2023-07-24T13:24:40","guid":{"rendered":"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/"},"modified":"2023-07-24T13:24:40","modified_gmt":"2023-07-24T13:24:40","slug":"distribusi-hipergeometri-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/","title":{"rendered":"Cara menggunakan distribusi hipergeometri di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-1\/\" target=\"_blank\" rel=\"noopener\">Distribusi hipergeometri<\/a> menggambarkan peluang terpilihnya <em>k<\/em> objek dengan karakteristik tertentu dalam <em>n<\/em> pengambilan tanpa pengembalian, dari populasi terbatas berukuran <em>N<\/em> yang berisi <em>K<\/em> objek dengan karakteristik tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika suatu variabel acak <em>X<\/em> mengikuti distribusi hipergeometri, maka peluang terpilihnya <em>k<\/em> objek dengan karakteristik tertentu dapat dicari dengan rumus berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>P(X=k) = <sub>K<\/sub> C <sub>k<\/sub> ( <sub>NK<\/sub> C <sub>nk<\/sub> ) \/ <sub>N<\/sub> C <sub>n<\/sub><\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>N:<\/strong> ukuran populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>K :<\/strong> banyaknya objek dalam populasi yang mempunyai ciri-ciri tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> ukuran sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>k :<\/strong> jumlah objek dalam sampel dengan fungsi tertentu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><sub>K<\/sub> C <sub>k<\/sub> :<\/strong> banyaknya kombinasi K benda yang diambil k sekaligus<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menghitung probabilitas yang terkait dengan distribusi hipergeometri di Excel, kita dapat menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=HYPGEOM.DIST(sample_s, number_sample, population_s, number_pop, cumulative)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>sample_s<\/strong> : jumlah keberhasilan dalam sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>number_sample<\/strong> : ukuran sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>populasi_s<\/strong> : jumlah keberhasilan dalam populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>number_pop<\/strong> : ukuran populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kumulatif<\/strong> : Apakah akan menghitung fungsi distribusi kumulatif<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h3> <strong>Contoh 1: Memilih kartu dari tumpukan<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Ada 4 Ratu dalam setumpuk 52 kartu standar. Misalkan kita secara acak memilih sebuah kartu dari tumpukan kartu dan kemudian, tanpa pengembalian, secara acak memilih kartu lain dari tumpukan tersebut. Berapa peluang terambilnya kedua kartu tersebut adalah Queens?<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut di Excel untuk menghitung probabilitas kartu menjadi ratu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-18154\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hypgeomexcel1.png\" alt=\"Distribusi hipergeometri di Excel\" width=\"605\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang terambilnya kedua kartu adalah Queens adalah . <strong>00452<\/strong> .<\/span><\/p>\n<h3> <strong>Contoh 2: mengumpulkan bola dari sebuah guci<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Sebuah guci berisi 3 bola merah dan 5 bola hijau. Anda secara acak memilih 4 bola. Berapa peluang terambilnya tepat 2 bola merah?<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut di Excel untuk mencari probabilitas ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18155 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hypgeomexcel2.png\" alt=\"\" width=\"584\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang terambilnya tepat 2 bola merah adalah . <strong>428571<\/strong> .<\/span><\/p>\n<h3> <strong>Contoh 3: Memilih kelereng dari keranjang<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Sebuah keranjang berisi 7 kelereng ungu dan 3 kelereng merah muda. Anda secara acak memilih 6 kelereng. Berapa peluang terambilnya tepat 3 kelereng berwarna merah muda?<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut di Excel untuk mencari probabilitas ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18156 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hypgeomexcel3.png\" alt=\"\" width=\"584\" height=\"507\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang terambilnya tepat 3 kelereng berwarna merah muda adalah . <strong>16667<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-1\/\" target=\"_blank\" rel=\"noopener\">Pengenalan distribusi hipergeometri<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kalkulator-distribusi-hipergeometri\/\" target=\"_blank\" rel=\"noopener\">Kalkulator distribusi hipergeometri online<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi hipergeometri menggambarkan peluang terpilihnya k objek dengan karakteristik tertentu dalam n pengambilan tanpa pengembalian, dari populasi terbatas berukuran N yang berisi K objek dengan karakteristik tersebut. Jika suatu variabel acak X mengikuti distribusi hipergeometri, maka peluang terpilihnya k objek dengan karakteristik tertentu dapat dicari dengan rumus berikut: P(X=k) = K C k ( NK [&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 menggunakan distribusi hipergeometri di Excel \u2013 Statology<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas distribusi hipergeometri di Excel, 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\/distribusi-hipergeometri-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan distribusi hipergeometri di Excel \u2013 Statology\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas distribusi hipergeometri di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T13:24:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hypgeomexcel1.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\/distribusi-hipergeometri-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/\",\"name\":\"Cara menggunakan distribusi hipergeometri di Excel \u2013 Statology\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T13:24:40+00:00\",\"dateModified\":\"2023-07-24T13:24:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung probabilitas distribusi hipergeometri di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan distribusi hipergeometri 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 menggunakan distribusi hipergeometri di Excel \u2013 Statology","description":"Tutorial ini menjelaskan cara menghitung probabilitas distribusi hipergeometri di Excel, 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\/distribusi-hipergeometri-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan distribusi hipergeometri di Excel \u2013 Statology","og_description":"Tutorial ini menjelaskan cara menghitung probabilitas distribusi hipergeometri di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-24T13:24:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/hypgeomexcel1.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\/distribusi-hipergeometri-unggul\/","url":"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/","name":"Cara menggunakan distribusi hipergeometri di Excel \u2013 Statology","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T13:24:40+00:00","dateModified":"2023-07-24T13:24:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung probabilitas distribusi hipergeometri di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/distribusi-hipergeometri-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan distribusi hipergeometri 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\/1897"}],"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=1897"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1897\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}