{"id":1346,"date":"2023-07-26T19:03:41","date_gmt":"2023-07-26T19:03:41","guid":{"rendered":"https:\/\/statorials.org\/id\/probabilitas-di-excel\/"},"modified":"2023-07-26T19:03:41","modified_gmt":"2023-07-26T19:03:41","slug":"probabilitas-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/probabilitas-di-excel\/","title":{"rendered":"Cara menghitung probabilitas di excel: dengan contoh"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Probabilitas<\/strong> menggambarkan kemungkinan terjadinya suatu peristiwa.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menghitung probabilitas di Excel menggunakan fungsi <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/prob-function-9ac30561-c81c-4259-8253-34f0a238fc49\" target=\"_blank\" rel=\"noopener\">PROB<\/a> , yang menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>MASALAH(x_range, prob_range, batas_bawah, [batas_atas])<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x_range:<\/strong> rentang nilai numerik x.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>prob_range:<\/strong> rentang probabilitas yang terkait dengan setiap nilai x.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>batas_bawah:<\/strong> batas bawah nilai probabilitas yang Anda inginkan.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>batas_atas:<\/strong> batas atas nilai probabilitas yang Anda inginkan. Opsional.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan beberapa contoh penggunaan praktis fungsi ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Probabilitas dadu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan peluang mendaratnya sebuah dadu pada nilai tertentu pada pelemparan tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13143 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel1.png\" alt=\"\" width=\"502\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Karena dadu mempunyai peluang yang sama untuk mendarat pada setiap nilai, maka peluangnya juga sama untuk setiap nilai.<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara mencari peluang munculnya dadu pada angka antara 3 dan 6:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13144 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel2.png\" alt=\"Hitung probabilitas di Excel\" width=\"498\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemungkinannya adalah <strong>0,5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa argumen batas atas bersifat opsional. Jadi, kita dapat menggunakan sintaks berikut untuk mencari peluang munculnya dadu hanya pada angka 4:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13145 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel3.png\" alt=\"Contoh Pencarian Probabilitas di Excel\" width=\"502\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Probabilitasnya ternyata <strong>0,166667<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Probabilitas penjualan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan kemungkinan suatu perusahaan akan menjual sejumlah produk tertentu pada kuartal berikutnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13146 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel4.png\" alt=\"\" width=\"393\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gambar berikut menunjukkan cara menentukan probabilitas suatu perusahaan akan menghasilkan 3 atau 4 penjualan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13147 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel5.png\" alt=\"Contoh penghitungan probabilitas di Excel\" width=\"511\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemungkinannya adalah <strong>0,7<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Relatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Kumulatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Distribusi Frekuensi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Probabilitas menggambarkan kemungkinan terjadinya suatu peristiwa. Kita bisa menghitung probabilitas di Excel menggunakan fungsi PROB , yang menggunakan sintaks berikut: MASALAH(x_range, prob_range, batas_bawah, [batas_atas]) Emas: x_range: rentang nilai numerik x. prob_range: rentang probabilitas yang terkait dengan setiap nilai x. batas_bawah: batas bawah nilai probabilitas yang Anda inginkan. batas_atas: batas atas nilai probabilitas yang Anda inginkan. [&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 Menghitung Probabilitas di Excel: Dengan Contoh<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas 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\/probabilitas-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Probabilitas di Excel: Dengan Contoh\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/probabilitas-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T19:03:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel1.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\/probabilitas-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/probabilitas-di-excel\/\",\"name\":\"Cara Menghitung Probabilitas di Excel: Dengan Contoh\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T19:03:41+00:00\",\"dateModified\":\"2023-07-26T19:03:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung probabilitas di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/probabilitas-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/probabilitas-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/probabilitas-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung probabilitas 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 Menghitung Probabilitas di Excel: Dengan Contoh","description":"Tutorial ini menjelaskan cara menghitung probabilitas 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\/probabilitas-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Probabilitas di Excel: Dengan Contoh","og_description":"Tutorial ini menjelaskan cara menghitung probabilitas di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/probabilitas-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T19:03:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/probexcel1.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\/probabilitas-di-excel\/","url":"https:\/\/statorials.org\/id\/probabilitas-di-excel\/","name":"Cara Menghitung Probabilitas di Excel: Dengan Contoh","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T19:03:41+00:00","dateModified":"2023-07-26T19:03:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung probabilitas di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/probabilitas-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/probabilitas-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/probabilitas-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung probabilitas 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\/1346"}],"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=1346"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1346\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}