{"id":721,"date":"2023-07-28T23:52:04","date_gmt":"2023-07-28T23:52:04","guid":{"rendered":"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/"},"modified":"2023-07-28T23:52:04","modified_gmt":"2023-07-28T23:52:04","slug":"kurva-lonceng-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/","title":{"rendered":"Cara membuat kurva lonceng di excel: contoh + template"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">&#8220;Kurva lonceng&#8221; adalah julukan yang diberikan pada bentuk distribusi normal , yang memiliki bentuk &#8220;lonceng&#8221; yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7233 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe1.png\" alt=\"Contoh kurva lonceng\" width=\"404\" height=\"225\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara membuat kurva lonceng di Excel untuk mean dan deviasi standar tertentu dan bahkan menyediakan templat yang dapat diunduh gratis yang dapat Anda gunakan untuk membuat kurva lonceng Anda sendiri di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: kurva lonceng di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk membuat kurva lonceng di Excel.<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">Langkah 1: Buat sel untuk mean dan deviasi standar.<\/span><\/strong> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7236 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe.png\" alt=\"Model Kurva Lonceng di Excel\" width=\"359\" height=\"317\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Buat sel untuk persentil dari -4 hingga 4, dengan kelipatan 0,1.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7237\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe2.png\" alt=\"Persentil untuk Kurva Lonceng di Excel\" width=\"381\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p style=\"text-align: center;\"> <span style=\"color: #000000;\"><strong>. . .<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7238 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe3.png\" alt=\"Persentil untuk Kurva Lonceng di Excel\" width=\"379\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Buat kolom nilai data untuk digunakan dalam bagan.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7239 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe4.png\" alt=\"nilai data kurva lonceng di Excel\" width=\"426\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Temukan nilai pdf distribusi normal.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7240 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe5.png\" alt=\"Nilai pdf kurva lonceng di Excel\" width=\"449\" height=\"429\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 5: Buat label plot pada sumbu x hanya untuk persentil bilangan bulat.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7241 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe6.png\" alt=\"label sumbu kurva lonceng di Excel\" width=\"421\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 6: Buat kurva lonceng.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot semua nilai di kolom <strong>pdf<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7242 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe7.png\" alt=\"Nilai pdf kurva lonceng di Excel\" width=\"416\" height=\"507\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya pada grup <strong>Charts<\/strong> pada tab <strong>Insert<\/strong> , klik opsi plot pertama pada kategori <strong>Insert line or area chart<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7243 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe8.png\" alt=\"Merencanakan Kurva Lonceng di Excel\" width=\"464\" height=\"302\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kurva lonceng akan otomatis muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7244 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe9.png\" alt=\"Kurva lonceng di Excel\" width=\"646\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 7: Edit label sumbu X.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik kanan di mana saja pada grafik dan klik <strong>Pilih Data<\/strong> . Jendela baru akan muncul. Klik tombol <strong>Edit<\/strong> di bawah Label Sumbu Horizontal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7245 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe10.png\" alt=\"Ubah label sumbu X pada kurva lonceng di Excel\" width=\"558\" height=\"318\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pilih rentang sel tempat label sumbu X berada. Dalam kasus kami, ini adalah rentang sel <strong>D5:D85<\/strong> . Lalu klik <strong>oke<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7246 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe11.png\" alt=\"kurva lonceng dengan label sumbu X di Excel\" width=\"654\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Label sumbu X akan diperbarui secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7247 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe12.png\" alt=\"Kurva lonceng dengan label di Excel\" width=\"381\" height=\"289\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Anda akan melihat bahwa jika Anda mengubah mean dan deviasi standar, kurva lonceng akan diperbarui secara otomatis. Misalnya seperti inilah bentuk kurva lonceng jika kita menggunakan mean = 10 dan standar deviasi = 2:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7248 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe13.png\" alt=\"kurva lonceng di Excel\" width=\"660\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Silakan mengedit judul bagan, menambahkan label sumbu, dan mengubah warna jika Anda ingin membuat bagan lebih estetis.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Templat gratis<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengunduh pola gratis yang digunakan untuk membuat kurva lonceng yang tepat dalam tutorial ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> Pengenalan distribusi normal<br \/> <a href=\"https:\/\/statorials.org\/id\/kalkulator-cdf-normal-cepat\/\" target=\"_blank\" rel=\"noopener noreferrer\">Kalkulator CDF Biasa<\/a><br \/> Cara memplot distribusi normal di R<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;Kurva lonceng&#8221; adalah julukan yang diberikan pada bentuk distribusi normal , yang memiliki bentuk &#8220;lonceng&#8221; yang berbeda: Tutorial ini menjelaskan cara membuat kurva lonceng di Excel untuk mean dan deviasi standar tertentu dan bahkan menyediakan templat yang dapat diunduh gratis yang dapat Anda gunakan untuk membuat kurva lonceng Anda sendiri di Excel. Contoh: kurva lonceng [&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 Kurva Lonceng di Excel: Contoh + Template<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat kurva lonceng di Excel, termasuk template yang dapat diunduh gratis.\" \/>\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\/kurva-lonceng-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Kurva Lonceng di Excel: Contoh + Template\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat kurva lonceng di Excel, termasuk template yang dapat diunduh gratis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T23:52:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe1.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\/kurva-lonceng-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\",\"name\":\"Cara Membuat Kurva Lonceng di Excel: Contoh + Template\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T23:52:04+00:00\",\"dateModified\":\"2023-07-28T23:52:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat kurva lonceng di Excel, termasuk template yang dapat diunduh gratis.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat kurva lonceng di excel: contoh + template\"}]},{\"@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 Kurva Lonceng di Excel: Contoh + Template","description":"Penjelasan sederhana cara membuat kurva lonceng di Excel, termasuk template yang dapat diunduh gratis.","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\/kurva-lonceng-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Kurva Lonceng di Excel: Contoh + Template","og_description":"Penjelasan sederhana cara membuat kurva lonceng di Excel, termasuk template yang dapat diunduh gratis.","og_url":"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T23:52:04+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clochecourbe1.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\/kurva-lonceng-excel\/","url":"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/","name":"Cara Membuat Kurva Lonceng di Excel: Contoh + Template","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T23:52:04+00:00","dateModified":"2023-07-28T23:52:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat kurva lonceng di Excel, termasuk template yang dapat diunduh gratis.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kurva-lonceng-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kurva-lonceng-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat kurva lonceng di excel: contoh + template"}]},{"@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\/721"}],"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=721"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/721\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}