{"id":2604,"date":"2023-07-21T13:16:41","date_gmt":"2023-07-21T13:16:41","guid":{"rendered":"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/"},"modified":"2023-07-21T13:16:41","modified_gmt":"2023-07-21T13:16:41","slug":"probabilitas-distribusi-normal-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/","title":{"rendered":"Cara menghitung probabilitas distribusi normal di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Distribusi normal adalah distribusi yang paling umum digunakan dalam semua statistik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung probabilitas terkait distribusi normal di Excel, Anda bisa menggunakan fungsi <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/normdist-function-126db625-c53e-4591-9a22-c9ff422d6d58\" target=\"_blank\" rel=\"noopener\">NORMDIST<\/a> , yang menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">=NORMDIST(x, mean, standard_dev, cumulative)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x<\/strong> : Nilai minat pada distribusi normal<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>mean<\/strong> : Rata-rata dari distribusi normal<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>standard_dev<\/strong> : Simpangan baku dari distribusi normal<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kumulatif<\/strong> : apakah akan menghitung probabilitas kumulatif (umumnya BENAR)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini untuk menghitung probabilitas yang terkait dengan distribusi normal.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung probabilitas yang kurang dari nilai tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Asumsikan bahwa nilai suatu ujian berdistribusi normal dengan rata-rata 90 dan deviasi standar 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tentukan peluang bahwa seorang siswa yang dipilih secara acak akan mendapat nilai kurang dari 80.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menggunakan fungsi <strong>NORMDIST()<\/strong> di Excel untuk menghitung probabilitas ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22998 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/norme11.jpg\" alt=\"\" width=\"515\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang siswa yang dipilih secara acak mendapat nilai di bawah 80 adalah <strong>0,1587<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: hitung probabilitas yang lebih besar dari nilai tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Asumsikan bahwa nilai suatu ujian berdistribusi normal dengan rata-rata 90 dan deviasi standar 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tentukan peluang bahwa seorang siswa yang dipilih secara acak akan mendapat nilai <em>lebih<\/em> dari 80.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari probabilitas ini, kita cukup melakukan 1 \u2013 <strong>NORMDIST()<\/strong> di Excel sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22999 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/norme12.jpg\" alt=\"\" width=\"522\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang seorang siswa yang dipilih secara acak akan memperoleh nilai di atas 80 adalah <strong>0,1587<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: hitung probabilitas antara dua nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Asumsikan bahwa nilai suatu ujian berdistribusi normal dengan rata-rata 90 dan deviasi standar 10.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tentukan peluang bahwa seorang siswa yang dipilih secara acak akan mendapat nilai antara 87 dan 93.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari probabilitas ini, kita dapat mengurangkan nilai terbesar <strong>NORMDIST()<\/strong> dari nilai terkecil <strong>NORMDIST()<\/strong> lainnya di Excel sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23000 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/norme13.jpg\" alt=\"\" width=\"619\" height=\"375\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Peluang seorang siswa yang dipilih secara acak akan memperoleh nilai antara 87 dan 93 adalah <strong>0,2358<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas lain terkait distribusi normal di Excel:<\/span><\/p>\n<p> Cara Menghasilkan Distribusi Normal di Excel<br \/> <a href=\"https:\/\/statorials.org\/id\/skor-z-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Z Score di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Kurva Lonceng di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi normal adalah distribusi yang paling umum digunakan dalam semua statistik. Untuk menghitung probabilitas terkait distribusi normal di Excel, Anda bisa menggunakan fungsi NORMDIST , yang menggunakan sintaks dasar berikut: =NORMDIST(x, mean, standard_dev, cumulative) Emas: x : Nilai minat pada distribusi normal mean : Rata-rata dari distribusi normal standard_dev : Simpangan baku dari distribusi normal [&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 Distribusi Normal di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas terkait distribusi normal 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\/probabilitas-distribusi-normal-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Probabilitas Distribusi Normal di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas terkait distribusi normal di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T13:16:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/norme11.jpg\" \/>\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-distribusi-normal-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/\",\"name\":\"Cara Menghitung Probabilitas Distribusi Normal di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T13:16:41+00:00\",\"dateModified\":\"2023-07-21T13:16:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung probabilitas terkait distribusi normal di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung probabilitas distribusi normal 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 Menghitung Probabilitas Distribusi Normal di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung probabilitas terkait distribusi normal 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\/probabilitas-distribusi-normal-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Probabilitas Distribusi Normal di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung probabilitas terkait distribusi normal di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-21T13:16:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/norme11.jpg"}],"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-distribusi-normal-unggul\/","url":"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/","name":"Cara Menghitung Probabilitas Distribusi Normal di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T13:16:41+00:00","dateModified":"2023-07-21T13:16:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung probabilitas terkait distribusi normal di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/probabilitas-distribusi-normal-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung probabilitas distribusi normal 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\/2604"}],"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=2604"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2604\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}