{"id":2161,"date":"2023-07-23T10:56:26","date_gmt":"2023-07-23T10:56:26","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-abaikan-saja\/"},"modified":"2023-07-23T10:56:26","modified_gmt":"2023-07-23T10:56:26","slug":"excel-abaikan-saja","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-abaikan-saja\/","title":{"rendered":"Cara mengabaikan nilai #n\/a saat menggunakan rumus di excel"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menghitung mean, median, jumlah, deviasi standar, dll. di Excel sambil mengabaikan nilai #N\/A:<\/span><\/p>\n

 =AVERAGE(IFNA( A2:A21<\/span> , \"\")) \n\n=MEDIAN(IFNA( A2:A21<\/span> , \"\"))\n\n=SUM(IFNA( A2:A21<\/span> , \"\"))\n\n=STDEV(IFNA( A2:A21<\/span> , \"\"))\n<\/strong><\/pre>\n
 Sintaks ini hanya mengganti nilai #N\/A dengan spasi dan kemudian menghitung statistik deskriptif yang Anda minati.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh 1: Hitung rata-rata dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung rata-rata kumpulan data yang berisi nilai #N\/A:<\/span> <\/p>\n
\"Rata-rata<\/p>\n
 Rata-rata kumpulan data (mengabaikan semua nilai #N\/A) adalah 14.76<\/strong> .<\/span><\/p>\n
 Contoh 2:<\/strong><\/span> Hitung median dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung median kumpulan data yang berisi nilai #N\/A:<\/span> <\/p>\n
\"Median<\/p>\n
 Median kumpulan data (mengabaikan semua nilai #N\/A) adalah 14<\/strong> .<\/span><\/p>\n
 Contoh 3:<\/strong><\/span> Hitung jumlahnya dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung jumlah kumpulan data yang berisi nilai #N\/A:<\/span> <\/p>\n
\"SUM<\/p>\n
 Jumlah seluruh kumpulan data (mengabaikan semua nilai #N\/A) adalah 251<\/strong> .<\/span><\/p>\n
 Contoh 4:<\/strong><\/span> Hitung deviasi standar dan abaikan nilai #N\/A<\/strong><\/span><\/h3>\n
 Tangkapan layar berikut menunjukkan cara menghitung deviasi standar kumpulan data yang berisi nilai #N\/A:<\/span> <\/p>\n
\"Standar<\/p>\n
 Simpangan baku kumpulan data (mengabaikan semua nilai #N\/A) adalah 6<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Bagaimana cara mengganti nilai #N\/A di Excel<\/a>
 Cara Mudah Menemukan Pencilan di Excel<\/a>
 Cara menemukan 10% nilai teratas di kolom Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menghitung mean, median, jumlah, deviasi standar, dll. di Excel sambil mengabaikan nilai #N\/A: =AVERAGE(IFNA( A2:A21 , “”)) =MEDIAN(IFNA( A2:A21 , “”)) =SUM(IFNA( A2:A21 , “”)) =STDEV(IFNA( A2:A21 , “”)) Sintaks ini hanya mengganti nilai #N\/A dengan spasi dan kemudian menghitung statistik deskriptif yang Anda minati. Contoh berikut menunjukkan […]<\/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":"\nCara mengabaikan nilai #N\/A saat menggunakan rumus di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A di Excel saat menggunakan rumus, 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\/excel-abaikan-saja\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A di Excel saat menggunakan rumus, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T10:56:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer1.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-abaikan-saja\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/\",\"name\":\"Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T10:56:26+00:00\",\"dateModified\":\"2023-07-23T10:56:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A di Excel saat menggunakan rumus, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-abaikan-saja\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengabaikan nilai #n\/a saat menggunakan rumus 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 mengabaikan nilai #N\/A saat menggunakan rumus di Excel - Statorials","description":"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A di Excel saat menggunakan rumus, 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\/excel-abaikan-saja\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A di Excel saat menggunakan rumus, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/excel-abaikan-saja\/","og_site_name":"Statorials","article_published_time":"2023-07-23T10:56:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ignorer1.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-abaikan-saja\/","url":"https:\/\/statorials.org\/id\/excel-abaikan-saja\/","name":"Cara mengabaikan nilai #N\/A saat menggunakan rumus di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T10:56:26+00:00","dateModified":"2023-07-23T10:56:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan nilai #N\/A di Excel saat menggunakan rumus, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-abaikan-saja\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-abaikan-saja\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-abaikan-saja\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengabaikan nilai #n\/a saat menggunakan rumus 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\/2161"}],"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=2161"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2161\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}