{"id":1901,"date":"2023-07-24T13:03:09","date_gmt":"2023-07-24T13:03:09","guid":{"rendered":"https:\/\/statorials.org\/id\/cdf-di-excel\/"},"modified":"2023-07-24T13:03:09","modified_gmt":"2023-07-24T13:03:09","slug":"cdf-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/cdf-di-excel\/","title":{"rendered":"Cara memplot cdf di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Fungsi distribusi kumulatif (CDF)<\/strong> menggambarkan probabilitas suatu variabel acak mengambil nilai kurang dari atau sama dengan angka tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan fungsi berikut di Excel untuk menghitung probabilitas distribusi kumulatif:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NORM.DIST(x, <span style=\"color: #3366ff;\">MEAN<\/span> , <span style=\"color: #ff0000;\">STANDARD_DEVIATION<\/span> , TRUE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menghitung dan memplot CDF di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Menghitung dan Plot CDF di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat dataset berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18182 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel1.png\" alt=\"\" width=\"540\" height=\"461\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Mari kita tentukan mean dan deviasi standar distribusi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18183 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel2.png\" alt=\"\" width=\"512\" height=\"521\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menghitung probabilitas distribusi kumulatif untuk nilai pertama dalam kumpulan data menggunakan rumus berikut:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=NORM.DIST(A2, <span style=\"color: #3366ff;\">$F$1<\/span> , <span style=\"color: #ff0000;\">$F$2<\/span> , TRUE)<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18184 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel3.png\" alt=\"\" width=\"593\" height=\"543\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu kita bisa menyalin dan menempelkan rumus ini ke semua sel lain di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18185 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel4.png\" alt=\"\" width=\"571\" height=\"501\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">CDF sekarang telah selesai. Cara kami menafsirkan nilai adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Peluang munculnya variabel acak bernilai sama dengan atau kurang dari 6 adalah . <strong>00135<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Peluang munculnya variabel acak bernilai sama dengan atau kurang dari 7 adalah . <strong>00383<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Peluang munculnya variabel acak bernilai sama dengan atau kurang dari 8 adalah . <strong>00982<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk memvisualisasikan CDF ini, kita dapat menyorot setiap nilai di kolom B. Selanjutnya, kita dapat mengklik tab <strong>Sisipkan<\/strong> di sepanjang pita atas dan klik <strong>Sisipkan Bagan Garis<\/strong> untuk menghasilkan bagan berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-18186 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel5.png\" alt=\"\" width=\"660\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai sepanjang sumbu x menunjukkan nilai dataset dan nilai sepanjang sumbu y menunjukkan nilai CDF.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/cdf-vs-pdf\/\" target=\"_blank\" rel=\"noopener\">CDF atau PDF: apa bedanya?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Kurva Lonceng di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/normalcdf-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Probabilitas NormalCDF di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fungsi distribusi kumulatif (CDF) menggambarkan probabilitas suatu variabel acak mengambil nilai kurang dari atau sama dengan angka tertentu. Kita bisa menggunakan fungsi berikut di Excel untuk menghitung probabilitas distribusi kumulatif: =NORM.DIST(x, MEAN , STANDARD_DEVIATION , TRUE) Contoh berikut memperlihatkan cara menghitung dan memplot CDF di Excel. Contoh: Menghitung dan Plot CDF di Excel Pertama, mari [&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 Plot CDF di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot CDF 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\/cdf-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot CDF di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot CDF di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/cdf-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T13:03:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel1.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\/cdf-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/cdf-di-excel\/\",\"name\":\"Cara Membuat Plot CDF di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T13:03:09+00:00\",\"dateModified\":\"2023-07-24T13:03:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot CDF di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/cdf-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/cdf-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/cdf-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memplot cdf 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 Plot CDF di Excel - Statologi","description":"Tutorial ini menjelaskan cara memplot CDF 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\/cdf-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot CDF di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara memplot CDF di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/cdf-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-24T13:03:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdfexcel1.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\/cdf-di-excel\/","url":"https:\/\/statorials.org\/id\/cdf-di-excel\/","name":"Cara Membuat Plot CDF di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T13:03:09+00:00","dateModified":"2023-07-24T13:03:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot CDF di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/cdf-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/cdf-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/cdf-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memplot cdf 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\/1901"}],"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=1901"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1901\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}