{"id":3829,"date":"2023-07-15T07:35:37","date_gmt":"2023-07-15T07:35:37","guid":{"rendered":"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/"},"modified":"2023-07-15T07:35:37","modified_gmt":"2023-07-15T07:35:37","slug":"garis-median-yang-difilter-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/","title":{"rendered":"Cara menghitung median baris yang difilter di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan sintaks berikut untuk menghitung nilai median dari rentang yang difilter di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=AGGREGATE(12,1, <span style=\"color: #3366ff;\">B2:B13<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai <strong>12<\/strong> adalah <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/aggregate-function-43b9278e-6aa7-4f17-92b6-e19993fa26df\" target=\"_blank\" rel=\"noopener\">jalan pintas<\/a> untuk menghitung median suatu rentang dan nilai <strong>1<\/strong> memberitahu Excel untuk mengabaikan baris tersembunyi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Median Baris yang Difilter di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan jumlah penjualan yang dilakukan suatu bisnis pada hari yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24050 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremois1.jpg\" alt=\"\" width=\"480\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, mari kita filter datanya agar hanya menampilkan tanggal di bulan Januari atau April.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, sorot rentang sel <strong>A1:B13<\/strong> . Kemudian klik pada tab <b>Data<\/b> di sepanjang pita atas dan klik tombol <strong>Filter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24051 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremois2-1.jpg\" alt=\"\" width=\"542\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik panah drop-down di sebelah <b>Tanggal<\/b> dan pastikan hanya kotak di sebelah Januari dan April yang dicentang, lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24060 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptefiltre1.jpg\" alt=\"\" width=\"439\" height=\"471\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Data akan difilter secara otomatis untuk hanya menampilkan baris dengan tanggal di bulan Januari atau April:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24059 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/comptefiltre2.jpg\" alt=\"\" width=\"450\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mencoba menggunakan fungsi <strong>MEDIAN()<\/strong> untuk mencari nilai rata-rata di kolom Penjualan, fungsi tersebut akan mengembalikan median dari semua nilai asli:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31007 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane1-1.jpg\" alt=\"\" width=\"473\" height=\"447\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebagai gantinya, kita dapat menggunakan fungsi <strong>AGGREGATE()<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-31008\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane2-1.jpg\" alt=\"Median Excel dari baris yang difilter\" width=\"487\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menghitung median dari garis yang terlihat saja.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat memeriksanya secara manual dengan menghitung median garis yang terlihat:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Penjualan median di baris yang terlihat: [9, 13, <strong>14<\/strong> , 14, 19]<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika nilai dicantumkan dalam urutan menaik, nilai di tengahnya memang <strong>14<\/strong> .<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/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\/excel-menghapus-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-rata-rata-excel-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/baris-filter-jumlah-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan baris yang difilter di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan sintaks berikut untuk menghitung nilai median dari rentang yang difilter di Excel: =AGGREGATE(12,1, B2:B13 ) Nilai 12 adalah jalan pintas untuk menghitung median suatu rentang dan nilai 1 memberitahu Excel untuk mengabaikan baris tersembunyi. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Hitung Median Baris yang Difilter di Excel Misalkan [&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 median baris yang difilter di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai median baris yang difilter di Excel, dengan 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\/garis-median-yang-difilter-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung median baris yang difilter di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai median baris yang difilter di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T07:35:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremois1.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\/garis-median-yang-difilter-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/\",\"name\":\"Cara menghitung median baris yang difilter di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T07:35:37+00:00\",\"dateModified\":\"2023-07-15T07:35:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai median baris yang difilter di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung median baris yang difilter 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 menghitung median baris yang difilter di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung nilai median baris yang difilter di Excel, dengan 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\/garis-median-yang-difilter-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung median baris yang difilter di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung nilai median baris yang difilter di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-15T07:35:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/filtremois1.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\/garis-median-yang-difilter-excel\/","url":"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/","name":"Cara menghitung median baris yang difilter di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T07:35:37+00:00","dateModified":"2023-07-15T07:35:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai median baris yang difilter di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/garis-median-yang-difilter-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung median baris yang difilter 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\/3829"}],"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=3829"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3829\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}