{"id":1475,"date":"2023-07-26T06:00:56","date_gmt":"2023-07-26T06:00:56","guid":{"rendered":"https:\/\/statorials.org\/id\/normalcdf-di-excel\/"},"modified":"2023-07-26T06:00:56","modified_gmt":"2023-07-26T06:00:56","slug":"normalcdf-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/normalcdf-di-excel\/","title":{"rendered":"Cara menghitung probabilitas normalcdf di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Fungsi <a href=\"https:\/\/statorials.org\/id\/probabilitas-normal-ti-84-kalkulator\/\" target=\"_blank\" rel=\"noopener\">NormalCDF<\/a> pada kalkulator TI-83 atau TI-84 dapat digunakan untuk mencari probabilitas suatu variabel acak yang berdistribusi normal mengambil nilai dalam rentang tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada kalkulator TI-83 atau TI-84, fungsi ini menggunakan sintaks berikut<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>normalcdf (bawah, atas, \u03bc, \u03c3)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>lebih rendah<\/strong> = nilai kisaran yang lebih rendah<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>atas<\/strong> = nilai atas rentang<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc<\/strong> = rata-rata populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03c3<\/strong> = simpangan baku populasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Misalnya, suatu variabel acak <a href=\"https:\/\/statorials.org\/id\/menghasilkan-distribusi-normal-di-r\/\" target=\"_blank\" rel=\"noopener\">berdistribusi normal<\/a> dengan rata-rata 50 dan simpangan baku 4. Peluang suatu variabel acak bernilai antara 48 dan 52 dapat dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>normalcdf(48, 52, 50, 4) = 0,3829<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mereproduksi respons ini di Excel menggunakan fungsi <strong>NORM.DIST()<\/strong> , yang menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>NORM.DIST(x, \u03c3, \u03bc, kumulatif)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x<\/strong> = nilai data individu<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc<\/strong> = rata-rata populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03c3<\/strong> = simpangan baku populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>kumulatif =<\/strong> SALAH menghitung PDF; TRUE menghitung CDF<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Probabilitas antara dua nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan suatu variabel acak berdistribusi normal dengan rata-rata 50 dan simpangan baku 4. Peluang suatu variabel acak bernilai <strong>antara<\/strong> 48 dan 52 dapat dihitung sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NORM. <span style=\"color: #3366ff;\">DIST<\/span> (52, 50, 4, <span style=\"color: #008000;\">TRUE<\/span> ) - NORM. <span style=\"color: #3366ff;\">DIST<\/span> (48, 50, 4, <span style=\"color: #008000;\">TRUE<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara melakukan perhitungan ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14617 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normalcdf1.png\" alt=\"Fungsi CDF normal di Excel\" width=\"486\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Probabilitasnya adalah <strong>0,3829.<\/strong><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Probabilitas kurang dari satu nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan suatu variabel acak berdistribusi normal dengan rata-rata 50 dan simpangan baku 4. Peluang suatu variabel acak bernilai <strong>kurang dari<\/strong> 48 dapat dihitung sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NORM. <span style=\"color: #3366ff;\">DIST<\/span> (48, 50, 4, <span style=\"color: #008000;\">TRUE<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara melakukan perhitungan ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14619 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normalcdf2-1.png\" alt=\"\" width=\"461\" height=\"326\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemungkinannya adalah <strong>0,3085.<\/strong><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Probabilitas lebih besar dari suatu nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan suatu variabel acak berdistribusi normal dengan rata-rata 50 dan simpangan baku 4. Peluang suatu variabel acak bernilai <strong>lebih besar dari<\/strong> 55 dapat dihitung sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=1 - NORM. <span style=\"color: #3366ff;\">DIST<\/span> (55, 50, 4, <span style=\"color: #008000;\">TRUE<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Gambar berikut memperlihatkan cara melakukan perhitungan ini di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14620 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normalcdf3.png\" alt=\"\" width=\"473\" height=\"333\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemungkinannya adalah <strong>0,1056.<\/strong><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anda juga dapat menggunakan <a href=\"https:\/\/statorials.org\/id\/kalkulator-cdf-normal-cepat\/\" target=\"_blank\" rel=\"noopener\">kalkulator CDF normal<\/a> ini untuk secara otomatis mencari probabilitas yang terkait dengan distribusi normal.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi NormalCDF pada kalkulator TI-83 atau TI-84 dapat digunakan untuk mencari probabilitas suatu variabel acak yang berdistribusi normal mengambil nilai dalam rentang tertentu. Pada kalkulator TI-83 atau TI-84, fungsi ini menggunakan sintaks berikut normalcdf (bawah, atas, \u03bc, \u03c3) Emas: lebih rendah = nilai kisaran yang lebih rendah atas = nilai atas rentang \u03bc = rata-rata [&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 NormalCDF di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas NormalCDF 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\/normalcdf-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 NormalCDF di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung probabilitas NormalCDF di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/normalcdf-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T06:00:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normalcdf1.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\/normalcdf-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/normalcdf-di-excel\/\",\"name\":\"Cara Menghitung Probabilitas NormalCDF di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T06:00:56+00:00\",\"dateModified\":\"2023-07-26T06:00:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung probabilitas NormalCDF di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/normalcdf-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/normalcdf-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/normalcdf-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung probabilitas normalcdf 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 NormalCDF di Excel","description":"Tutorial ini menjelaskan cara menghitung probabilitas NormalCDF 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\/normalcdf-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Probabilitas NormalCDF di Excel","og_description":"Tutorial ini menjelaskan cara menghitung probabilitas NormalCDF di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/normalcdf-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T06:00:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/normalcdf1.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\/normalcdf-di-excel\/","url":"https:\/\/statorials.org\/id\/normalcdf-di-excel\/","name":"Cara Menghitung Probabilitas NormalCDF di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T06:00:56+00:00","dateModified":"2023-07-26T06:00:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung probabilitas NormalCDF di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/normalcdf-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/normalcdf-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/normalcdf-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung probabilitas normalcdf 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\/1475"}],"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=1475"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1475\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}