{"id":2316,"date":"2023-07-22T19:33:07","date_gmt":"2023-07-22T19:33:07","guid":{"rendered":"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/"},"modified":"2023-07-22T19:33:07","modified_gmt":"2023-07-22T19:33:07","slug":"kurva-lonceng-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/","title":{"rendered":"Cara membuat kurva lonceng di google spreadsheet (langkah demi langkah)"},"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;\">Contoh langkah demi langkah berikut menunjukkan cara membuat kurva lonceng di Google Spreadsheet untuk mean dan deviasi standar tertentu.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Tentukan Mean dan Deviasi Standar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kita akan menentukan nilai mean dan deviasi standar dari distribusi normal tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21057 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cloche1.png\" alt=\"\" width=\"441\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Tentukan persentil<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menentukan persentil yang akan digunakan dalam plot mulai dari -4 hingga 4 dengan kelipatan 0,1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21058 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cloche2.png\" alt=\"\" width=\"444\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Tetapkan nilai data<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat kolom nilai data untuk digunakan dalam plot menggunakan rumus berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21064 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cloche3-1.png\" alt=\"\" width=\"451\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Temukan Nilai PDF Distribusi Normal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menggunakan rumus berikut untuk mencari nilai fungsi kepadatan probabilitas distribusi normal:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21060 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cloche4.png\" alt=\"\" width=\"438\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 5: Buat Kurva Lonceng<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat menyorot nilai dalam rentang <strong>B5:C85<\/strong> , lalu klik <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kurva lonceng berikut akan dibuat secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21061 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cloche5.png\" alt=\"\" width=\"664\" height=\"497\" 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.<\/span><\/p>\n<p> <span style=\"color: #000000;\">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=\" wp-image-21062 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cloche6.png\" alt=\"\" width=\"655\" height=\"432\" 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>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut memberikan informasi tambahan tentang distribusi normal:<\/span><\/p>\n<p> Pengenalan distribusi normal<br \/> <a href=\"https:\/\/statorials.org\/id\/contoh-distribusi-normal\/\" target=\"_blank\" rel=\"noopener\">6 contoh konkrit distribusi normal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kalkulator-cdf-normal-cepat\/\" target=\"_blank\" rel=\"noopener noreferrer\">Kalkulator CDF Biasa<\/a><\/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: Contoh langkah demi langkah berikut menunjukkan cara membuat kurva lonceng di Google Spreadsheet untuk mean dan deviasi standar tertentu. Langkah 1: Tentukan Mean dan Deviasi Standar Pertama, kita akan menentukan nilai mean dan deviasi standar 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 Membuat Kurva Lonceng di Google Spreadsheet (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat kurva lonceng di Google Sheets, 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\/kurva-lonceng-google-sheet\/\" \/>\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 Google Spreadsheet (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat kurva lonceng di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T19:33:07+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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/\",\"name\":\"Cara Membuat Kurva Lonceng di Google Spreadsheet (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T19:33:07+00:00\",\"dateModified\":\"2023-07-22T19:33:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat kurva lonceng di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat kurva lonceng di google spreadsheet (langkah demi langkah)\"}]},{\"@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 Google Spreadsheet (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara membuat kurva lonceng di Google Sheets, 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\/kurva-lonceng-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Kurva Lonceng di Google Spreadsheet (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara membuat kurva lonceng di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T19:33:07+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-google-sheet\/","url":"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/","name":"Cara Membuat Kurva Lonceng di Google Spreadsheet (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T19:33:07+00:00","dateModified":"2023-07-22T19:33:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat kurva lonceng di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kurva-lonceng-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat kurva lonceng di google spreadsheet (langkah demi langkah)"}]},{"@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\/2316"}],"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=2316"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2316\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}