{"id":2815,"date":"2023-07-20T14:04:38","date_gmt":"2023-07-20T14:04:38","guid":{"rendered":"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/"},"modified":"2023-07-20T14:04:38","modified_gmt":"2023-07-20T14:04:38","slug":"simpangan-baku-excel-jika","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/","title":{"rendered":"Cara melakukan perhitungan if standar deviasi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk melakukan penghitungan standar deviasi IF di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Standar deviasi IF (satu kriteria)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=STDEV(IF( <span style=\"color: #3366ff;\">A:A<\/span> =\"Value\", <span style=\"color: #ff0000;\">C:C<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung simpangan baku nilai pada kolom <strong>C<\/strong> dimana nilai pada kolom <strong>A<\/strong> sama dengan \u201cNilai\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Standar deviasi IF (beberapa kriteria)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=STDEV(IF(( <span style=\"color: #3366ff;\">A:A<\/span> =\"Value1\")*( <span style=\"color: #ff0000;\">B:B<\/span> =\"Value2\"), <span style=\"color: #800080;\">C:C<\/span> ,\"\"))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus ini menghitung simpangan baku nilai pada kolom <strong>C<\/strong> dimana nilai pada kolom <strong>A<\/strong> sama dengan \u201cNilai1\u201d dan nilai pada kolom <strong>B<\/strong> sama dengan \u201cNilai2\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung simpangan baku IF (kriteria)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung simpangan baku nilai pada kolom <strong>Poin<\/strong> dimana nilai pada kolom <strong>Tim<\/strong> sama dengan \u201cMavs\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=STDEV(IF( <span style=\"color: #3366ff;\">A:A<\/span> =\"Mavs\", <span style=\"color: #ff0000;\">C:C<\/span> ))<\/strong><\/pre>\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-24718\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif1.jpg\" alt=\"Rumus simpangan baku IF di Excel\" width=\"521\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Simpangan baku <strong>titik<\/strong> untuk garis di mana <strong>Tim<\/strong> sama dengan &#8220;Mavs&#8221; adalah <strong>7,3326<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menghitung simpangan baku IF (beberapa kriteria)<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menghitung simpangan baku nilai pada kolom <strong>Points<\/strong> dimana nilai pada kolom <strong>Team<\/strong> sama dengan \u201cMavs\u201d dan nilai pada kolom <strong>Position<\/strong> sama dengan \u201cGuard\u201d:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=STDEV(IF(( <span style=\"color: #3366ff;\">A:A<\/span> =\"Mavs\")*( <span style=\"color: #ff0000;\">B:B<\/span> =\"Guard\"), <span style=\"color: #800080;\">C:C<\/span> ,\"\"))<\/strong><\/pre>\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-24719\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif2.jpg\" alt=\"Rumus IF Standar Deviasi Excel dengan Banyak Kriteria\" width=\"570\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Standar deviasi <strong>poin<\/strong> untuk garis di mana <strong>tim<\/strong> sama dengan &#8220;Mavs&#8221; dan <strong>posisinya<\/strong> sama dengan &#8220;Guard&#8221; adalah <strong>5,5603<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/\" target=\"_blank\" rel=\"noopener\">STDEV.P vs STDEV.S di Excel: Apa bedanya?<\/a><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean dan Deviasi Standar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk melakukan penghitungan standar deviasi IF di Excel: Metode 1: Standar deviasi IF (satu kriteria) =STDEV(IF( A:A =&#8221;Value&#8221;, C:C )) Rumus ini menghitung simpangan baku nilai pada kolom C dimana nilai pada kolom A sama dengan \u201cNilai\u201d. Metode 2: Standar deviasi IF (beberapa kriteria) =STDEV(IF(( A:A =&#8221;Value1&#8243;)*( B:B =&#8221;Value2&#8243;), C:C [&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 Melakukan Perhitungan IF Standar Deviasi di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF deviasi standar di Excel, beserta contohnya.\" \/>\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\/simpangan-baku-excel-jika\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Perhitungan IF Standar Deviasi di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan rumus IF deviasi standar di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:04:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif1.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\/simpangan-baku-excel-jika\/\",\"url\":\"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/\",\"name\":\"Cara Melakukan Perhitungan IF Standar Deviasi di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:04:38+00:00\",\"dateModified\":\"2023-07-20T14:04:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan rumus IF deviasi standar di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan perhitungan if 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 Melakukan Perhitungan IF Standar Deviasi di Excel - Statologi","description":"Tutorial ini menjelaskan cara menggunakan rumus IF deviasi standar di Excel, beserta contohnya.","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\/simpangan-baku-excel-jika\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Perhitungan IF Standar Deviasi di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan rumus IF deviasi standar di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:04:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif1.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\/simpangan-baku-excel-jika\/","url":"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/","name":"Cara Melakukan Perhitungan IF Standar Deviasi di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:04:38+00:00","dateModified":"2023-07-20T14:04:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan rumus IF deviasi standar di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/simpangan-baku-excel-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan perhitungan if 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\/2815"}],"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=2815"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2815\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}