{"id":4741,"date":"2023-07-08T10:10:02","date_gmt":"2023-07-08T10:10:02","guid":{"rendered":"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/"},"modified":"2023-07-08T10:10:02","modified_gmt":"2023-07-08T10:10:02","slug":"deviasi-standar-excel-abaikan-nol","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/","title":{"rendered":"Excel: hitung simpangan baku dan abaikan nol"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan rumus berikut untuk menghitung deviasi standar suatu rentang di Excel dan mengabaikan semua sel dengan nilai nol:<\/span><\/p>\n

 =STDEV(IF( A2:A13<\/span> >0, A2:A13<\/span> ))\n<\/strong><\/pre>\n
 Rumus khusus ini akan menghitung simpangan baku nilai dalam rentang A2:A13<\/strong> dan mengabaikan sel mana pun yang memiliki nilai nol.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Terkait:<\/strong> Mengapa deviasi standar penting?<\/a><\/span><\/p>\n
 Contoh: Hitung Deviasi Standar dan Abaikan Nol di Excel<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki daftar nilai berikut di Excel:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita mengetikkan rumus berikut di sel C2<\/strong> untuk menghitung simpangan baku dari nilai di kolom A:<\/span><\/p>\n
 =STDEV( A2:A13<\/span> )<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Rumusnya mengembalikan nilai 4,097<\/strong> .<\/span><\/p>\n
 Ini mewakili simpangan baku semua nilai di kolom A.<\/span><\/p>\n
 Namun, kita bisa menggunakan rumus berikut untuk menghitung simpangan baku nilai di kolom A saja untuk sel yang tidak sama dengan nol:<\/span><\/p>\n
 =STDEV(IF( A2:A13<\/span> >0, A2:A13<\/span> ))<\/strong><\/pre>\n
 Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n
\"Excel<\/p>\n
 Rumusnya mengembalikan nilai 2,976<\/strong> .<\/span><\/p>\n
 Ini mewakili simpangan baku semua nilai di kolom A yang tidak sama dengan nol.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara Menghitung Rangkuman Lima Angka di Excel<\/a>
 Cara Menghitung Mean dan Deviasi Standar di Excel<\/a>
 Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda bisa menggunakan rumus berikut untuk menghitung deviasi standar suatu rentang di Excel dan mengabaikan semua sel dengan nilai nol: =STDEV(IF( A2:A13 >0, A2:A13 )) Rumus khusus ini akan menghitung simpangan baku nilai dalam rentang A2:A13 dan mengabaikan sel mana pun yang memiliki nilai nol. Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik. Terkait: […]<\/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":"\nExcel: hitung simpangan baku dan abaikan nol - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung standar deviasi di Excel dan mengabaikan sel yang bernilai nol, beserta sebuah 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-excel-abaikan-nol\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: hitung simpangan baku dan abaikan nol - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung standar deviasi di Excel dan mengabaikan sel yang bernilai nol, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T10:10:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stignore1.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\/deviasi-standar-excel-abaikan-nol\/\",\"url\":\"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/\",\"name\":\"Excel: hitung simpangan baku dan abaikan nol - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T10:10:02+00:00\",\"dateModified\":\"2023-07-08T10:10:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung standar deviasi di Excel dan mengabaikan sel yang bernilai nol, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: hitung simpangan baku dan abaikan nol\"}]},{\"@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":"Excel: hitung simpangan baku dan abaikan nol - Statologi","description":"Tutorial ini menjelaskan cara menghitung standar deviasi di Excel dan mengabaikan sel yang bernilai nol, beserta sebuah 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-excel-abaikan-nol\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: hitung simpangan baku dan abaikan nol - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung standar deviasi di Excel dan mengabaikan sel yang bernilai nol, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/","og_site_name":"Statorials","article_published_time":"2023-07-08T10:10:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/stignore1.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\/deviasi-standar-excel-abaikan-nol\/","url":"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/","name":"Excel: hitung simpangan baku dan abaikan nol - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T10:10:02+00:00","dateModified":"2023-07-08T10:10:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung standar deviasi di Excel dan mengabaikan sel yang bernilai nol, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/deviasi-standar-excel-abaikan-nol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: hitung simpangan baku dan abaikan nol"}]},{"@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\/4741"}],"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=4741"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4741\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}