{"id":4742,"date":"2023-07-08T09:55:05","date_gmt":"2023-07-08T09:55:05","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/"},"modified":"2023-07-08T09:55:05","modified_gmt":"2023-07-08T09:55:05","slug":"excel-menghitung-2-standar-deviasi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/","title":{"rendered":"Cara menghitung 2 standar deviasi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menghitung nilai dua standar deviasi di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=2*STDEV( <span style=\"color: #3366ff;\">A2:A14<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung nilai dua standar deviasi untuk nilai dalam rentang sel <strong>A2:A14<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Alasan Anda mungkin tertarik untuk menghitung nilai ini adalah karena dalam statistik, <strong>aturan praktis<\/strong> menyatakan bahwa untuk kumpulan data tertentu dengan distribusi normal, sekitar 95% dari semua nilai data termasuk dalam dua jenis rata-rata deviasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara praktis menghitung dua standar deviasi di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: menghitung 2 standar deviasi di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37026 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deux1.png\" alt=\"\" width=\"439\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut di berbagai sel untuk menghitung mean, nilai dua standar deviasi, dan nilai dua standar deviasi di bawah dan di atas mean:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">D1: <strong>= RATA-RATA (A2: A14)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">D2: <strong>=2*ETDEV(A2:A14)<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">D3: <strong>=D1-D2<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">D4: <strong>=D1+D2<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37027\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deux2.png\" alt=\"cara menghitung dua standar deviasi di excel\" width=\"521\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai rata-rata dataset adalah <strong>77.07<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai dua standar deviasi adalah <strong>16.03<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilainya berada dua standar deviasi di bawah mean yaitu <strong>61.0465<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai yang berada dua standar deviasi diatas mean adalah <strong>93.1073<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dengan asumsi bahwa sampel data ini mewakili populasi yang lebih besar dari mana sampel tersebut berasal dan bahwa nilai-nilai dalam populasi tersebut terdistribusi secara normal, kita akan berasumsi bahwa 95% dari seluruh nilai data dalam populasi tersebut berada antara <strong>61.0465<\/strong> dan <strong>93.1073<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda ingin menghitung tiga simpangan baku, cukup ganti <strong>angka 2<\/strong> pada rumus di sel <strong>E2<\/strong> dengan <strong>angka 3<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/rata-rata-grafik-excel-dan-deviasi-standar\/\" target=\"_blank\" rel=\"noopener\">Cara Merencanakan Mean dan Deviasi Standar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Perhitungan IF Standar Deviasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/deviasi-standar-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Deviasi Standar Tertimbang di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menghitung nilai dua standar deviasi di Excel: =2*STDEV( A2:A14 ) Contoh khusus ini menghitung nilai dua standar deviasi untuk nilai dalam rentang sel A2:A14 . Alasan Anda mungkin tertarik untuk menghitung nilai ini adalah karena dalam statistik, aturan praktis menyatakan bahwa untuk kumpulan data tertentu dengan distribusi normal, sekitar [&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 2 standar deviasi di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung 2 standar deviasi di Excel, beserta contoh lengkapnya.\" \/>\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\/excel-menghitung-2-standar-deviasi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung 2 standar deviasi di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung 2 standar deviasi di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T09:55:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deux1.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\/excel-menghitung-2-standar-deviasi\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/\",\"name\":\"Cara menghitung 2 standar deviasi di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T09:55:05+00:00\",\"dateModified\":\"2023-07-08T09:55:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung 2 standar deviasi di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung 2 standar deviasi 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 2 standar deviasi di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung 2 standar deviasi di Excel, beserta contoh lengkapnya.","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\/excel-menghitung-2-standar-deviasi\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung 2 standar deviasi di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung 2 standar deviasi di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/","og_site_name":"Statorials","article_published_time":"2023-07-08T09:55:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deux1.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\/excel-menghitung-2-standar-deviasi\/","url":"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/","name":"Cara menghitung 2 standar deviasi di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T09:55:05+00:00","dateModified":"2023-07-08T09:55:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung 2 standar deviasi di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghitung-2-standar-deviasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung 2 standar deviasi 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\/4742"}],"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=4742"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4742\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}