{"id":3011,"date":"2023-07-19T15:49:34","date_gmt":"2023-07-19T15:49:34","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/"},"modified":"2023-07-19T15:49:34","modified_gmt":"2023-07-19T15:49:34","slug":"plot-distribusi-chi-kuadrat-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/","title":{"rendered":"Cara membuat plot distribusi chi-kuadrat di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial langkah demi langkah ini menjelaskan cara memplot distribusi chi-kuadrat berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25977\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi5.jpg\" alt=\"plot distribusi chi kuadrat di Excel\" width=\"474\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Tetapkan Nilai X<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita tentukan rentang nilai X yang akan digunakan untuk plot kita.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kita akan membuat rentang dari 0 hingga 20:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25972 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi1.jpg\" alt=\"\" width=\"440\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung Nilai Y<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Nilai y pada plot akan mewakili nilai PDF yang terkait dengan distribusi Chi-kuadrat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat mengetikkan rumus berikut di sel <strong>B2<\/strong> untuk menghitung PDF distribusi Chi-kuadrat yang terkait dengan nilai x 0 dan nilai derajat kebebasan 3:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=CHISQ.DIST( <span style=\"color: #3366ff;\">A2<\/span> , <span style=\"color: #ff0000;\">$E$1<\/span> , FALSE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom B:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25973 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi2.jpg\" alt=\"\" width=\"468\" height=\"504\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Plot distribusi chi-kuadrat<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot cell range <strong>A2:B22<\/strong> , lalu klik tab <strong>Insert<\/strong> di sepanjang pita atas, lalu klik opsi <strong>Scatter<\/strong> di grup <strong>Charts<\/strong> dan klik <strong>Scatter with Smooth Lines<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25974 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/scattersmoothexcel.jpg\" alt=\"\" width=\"519\" height=\"274\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Grafik berikut akan dibuat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25975 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi3.jpg\" alt=\"\" width=\"658\" height=\"510\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menunjukkan nilai variabel acak yang mengikuti distribusi Chi-kuadrat dengan 3 derajat kebebasan dan sumbu y menunjukkan nilai PDF yang sesuai dari distribusi Chi-kuadrat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda mengubah nilai derajat kebebasan di sel <strong>E1<\/strong> , grafik akan diperbarui secara otomatis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat mengubah derajat kebebasan menjadi 7:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25976 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi4.jpg\" alt=\"\" width=\"638\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa bentuk plot secara otomatis berubah untuk mencerminkan distribusi Chi-kuadrat dengan 7 derajat kebebasan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Langkah 4: Ubah Tampilan Jalur<\/span><\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menambahkan judul, label sumbu, dan menghapus garis kisi untuk membuat plot lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25977\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi5.jpg\" alt=\"plot distribusi chi kuadrat di Excel\" width=\"474\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara memplot distribusi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana Menggambar Kurva Lonceng di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-excel-distribusi-binomial\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Distribusi Binomial di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-excel-sebaran-ikan\/\" target=\"_blank\" rel=\"noopener\">Cara memplot distribusi Poisson di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial langkah demi langkah ini menjelaskan cara memplot distribusi chi-kuadrat berikut di Excel: Langkah 1: Tetapkan Nilai X Pertama, mari kita tentukan rentang nilai X yang akan digunakan untuk plot kita. Untuk contoh ini, kita akan membuat rentang dari 0 hingga 20: Langkah 2: Hitung Nilai Y Nilai y pada plot akan mewakili nilai PDF [&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 Distribusi Chi-Kuadrat di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memplot distribusi Chi-kuadrat di Excel, termasuk 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\/plot-distribusi-chi-kuadrat-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 Distribusi Chi-Kuadrat di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memplot distribusi Chi-kuadrat di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T15:49:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi5.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\/plot-distribusi-chi-kuadrat-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/\",\"name\":\"Cara Membuat Plot Distribusi Chi-Kuadrat di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T15:49:34+00:00\",\"dateModified\":\"2023-07-19T15:49:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memplot distribusi Chi-kuadrat di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot distribusi chi-kuadrat 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 Distribusi Chi-Kuadrat di Excel - Statorials","description":"Tutorial ini menjelaskan cara memplot distribusi Chi-kuadrat di Excel, termasuk 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\/plot-distribusi-chi-kuadrat-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Distribusi Chi-Kuadrat di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara memplot distribusi Chi-kuadrat di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T15:49:34+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plotchi5.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\/plot-distribusi-chi-kuadrat-excel\/","url":"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/","name":"Cara Membuat Plot Distribusi Chi-Kuadrat di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T15:49:34+00:00","dateModified":"2023-07-19T15:49:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memplot distribusi Chi-kuadrat di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-distribusi-chi-kuadrat-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot distribusi chi-kuadrat 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\/3011"}],"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=3011"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3011\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}