{"id":2816,"date":"2023-07-20T14:00:40","date_gmt":"2023-07-20T14:00:40","guid":{"rendered":"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/"},"modified":"2023-07-20T14:00:40","modified_gmt":"2023-07-20T14:00:40","slug":"deviasi-standar-google-sheet-jika","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/","title":{"rendered":"Cara menghitung standar deviasi if di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk melakukan penghitungan deviasi standar IF di Google Spreadsheet:<\/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>=ArrayFormula(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>=ArrayFormula(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>=ArrayFormula(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-24725\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif3.jpg\" alt=\"simpangan baku jika dihitung di Google Sheets\" width=\"640\" height=\"472\" 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>=ArrayFormula(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-24726\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif4.jpg\" alt=\"simpangan baku jika dihitung di Google Sheets\" width=\"677\" height=\"472\" 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<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 Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/standar-deviasi-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung standar deviasi di Google Sheets (sampel dan populasi)<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/statistik-deskriptif-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung statistik deskriptif di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk melakukan penghitungan deviasi standar IF di Google Spreadsheet: Metode 1: Standar deviasi IF (satu kriteria) =ArrayFormula(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) =ArrayFormula(STDEV(IF(( A:A =&#8221;Value1&#8243;)*( B:B =&#8221;Value2&#8243;), [&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 Deviasi Standar IF di Google Sheets - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat rumus IF deviasi standar di Google Sheets, dengan beberapa contoh.\" \/>\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\/deviasi-standar-google-sheet-jika\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Deviasi Standar IF di Google Sheets - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat rumus IF deviasi standar di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T14:00:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif3.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\/deviasi-standar-google-sheet-jika\/\",\"url\":\"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/\",\"name\":\"Cara Menghitung Deviasi Standar IF di Google Sheets - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T14:00:40+00:00\",\"dateModified\":\"2023-07-20T14:00:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat rumus IF deviasi standar di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung standar deviasi if di google sheets\"}]},{\"@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 Deviasi Standar IF di Google Sheets - Statorials","description":"Tutorial ini menjelaskan cara membuat rumus IF deviasi standar di Google Sheets, dengan beberapa contoh.","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\/deviasi-standar-google-sheet-jika\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Deviasi Standar IF di Google Sheets - Statorials","og_description":"Tutorial ini menjelaskan cara membuat rumus IF deviasi standar di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/","og_site_name":"Statorials","article_published_time":"2023-07-20T14:00:40+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stdevif3.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\/deviasi-standar-google-sheet-jika\/","url":"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/","name":"Cara Menghitung Deviasi Standar IF di Google Sheets - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T14:00:40+00:00","dateModified":"2023-07-20T14:00:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat rumus IF deviasi standar di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/deviasi-standar-google-sheet-jika\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung standar deviasi if di google sheets"}]},{"@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\/2816"}],"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=2816"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2816\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}