{"id":4610,"date":"2023-07-09T15:56:19","date_gmt":"2023-07-09T15:56:19","guid":{"rendered":"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/"},"modified":"2023-07-09T15:56:19","modified_gmt":"2023-07-09T15:56:19","slug":"median-excel-mengabaikan-0","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/","title":{"rendered":"Excel: cara menghitung nilai median dan mengabaikan angka nol"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut di Excel untuk menghitung nilai median dari rentang tertentu dan mengabaikan semua nilai yang sama dengan nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MEDIAN(IF( <span style=\"color: #3366ff;\">B2:B10<\/span> &lt;&gt;0, <span style=\"color: #3366ff;\">B2:B10<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan menghitung nilai median dalam rentang <strong>B2:B10<\/strong> dan mengabaikan semua nilai yang sama dengan nol saat menghitung median.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Nilai Median dan Abaikan Angka Nol di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35979 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mig1.png\" alt=\"\" width=\"450\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita menggunakan rumus berikut untuk menghitung nilai median pada kolom poin:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=MEDIAN( <span style=\"color: #3366ff;\">B2:B10<\/span> )\n<\/span><\/strong><\/span><\/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=\" wp-image-35980 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mig2.png\" alt=\"\" width=\"483\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Secara default, Excel mempertimbangkan setiap nilai dalam rentang saat menghitung median.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi rumus <strong>MEDIAN<\/strong> mengurutkan setiap nilai pada kolom poin dari yang terkecil hingga terbesar dan memilih nilai median sebagai mediannya:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai poin: 0, 0, 13, 14, <strong>18<\/strong> , 22, 24, 28, 29<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita dapat menggunakan rumus berikut untuk menghitung nilai median pada kolom poin dan mengabaikan semua nilai yang sama dengan nol:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MEDIAN(IF( <span style=\"color: #3366ff;\">B2:B10<\/span> &lt;&gt;0, <span style=\"color: #3366ff;\">B2:B10<\/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=\" wp-image-35981 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mig3.png\" alt=\"\" width=\"512\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung nilai median pada kolom poin dan mengabaikan nilai poin yang sama dengan nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi rumus <strong>MEDIAN<\/strong> mengurutkan setiap nilai pada kolom poin dari yang terkecil hingga terbesar (tidak termasuk angka nol) dan memilih nilai tengah sebagai median:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai poin: 13, 14, 18, <strong>22<\/strong> , 24, 28, 29<\/span><\/p>\n<p> <span style=\"color: #000000;\">Mengabaikan nilai sama dengan nol, nilai mediannya menjadi <strong>22<\/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> <a href=\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung median berdasarkan grup di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung median baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung median dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut di Excel untuk menghitung nilai median dari rentang tertentu dan mengabaikan semua nilai yang sama dengan nol: =MEDIAN(IF( B2:B10 &lt;&gt;0, B2:B10 )) Contoh khusus ini akan menghitung nilai median dalam rentang B2:B10 dan mengabaikan semua nilai yang sama dengan nol saat menghitung median. Contoh berikut menunjukkan cara menggunakan sintaksis ini [&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>Excel: Cara menghitung nilai median dan mengabaikan angka nol - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai median dalam suatu rentang di Excel dan mengabaikan nilai nol, 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\/median-excel-mengabaikan-0\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung nilai median dan mengabaikan angka nol - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai median dalam suatu rentang di Excel dan mengabaikan nilai nol, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T15:56:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mig1.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\/median-excel-mengabaikan-0\/\",\"url\":\"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/\",\"name\":\"Excel: Cara menghitung nilai median dan mengabaikan angka nol - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T15:56:19+00:00\",\"dateModified\":\"2023-07-09T15:56:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai median dalam suatu rentang di Excel dan mengabaikan nilai nol, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung nilai median dan mengabaikan angka 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: Cara menghitung nilai median dan mengabaikan angka nol - Statorials","description":"Tutorial ini menjelaskan cara menghitung nilai median dalam suatu rentang di Excel dan mengabaikan nilai nol, 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\/median-excel-mengabaikan-0\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung nilai median dan mengabaikan angka nol - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung nilai median dalam suatu rentang di Excel dan mengabaikan nilai nol, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/","og_site_name":"Statorials","article_published_time":"2023-07-09T15:56:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mig1.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\/median-excel-mengabaikan-0\/","url":"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/","name":"Excel: Cara menghitung nilai median dan mengabaikan angka nol - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T15:56:19+00:00","dateModified":"2023-07-09T15:56:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai median dalam suatu rentang di Excel dan mengabaikan nilai nol, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/median-excel-mengabaikan-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung nilai median dan mengabaikan angka 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\/4610"}],"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=4610"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4610\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}