{"id":3156,"date":"2023-07-18T22:55:07","date_gmt":"2023-07-18T22:55:07","guid":{"rendered":"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/"},"modified":"2023-07-18T22:55:07","modified_gmt":"2023-07-18T22:55:07","slug":"garis-yang-difilter-rata-rata-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/","title":{"rendered":"Cara rata-rata baris yang difilter di google spreadsheet (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk mengambil rata-rata rentang yang difilter di Google Spreadsheet adalah dengan menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>SUBTOTAL( <span style=\"color: #0000ff;\">101<\/span> , <span style=\"color: #ff6600;\">A1:A10<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai 101 adalah <a href=\"https:\/\/support.google.com\/docs\/answer\/3093649?hl=en\" target=\"_blank\" rel=\"noopener\">jalan pintas<\/a> untuk mengambil rata-rata rentang baris yang difilter.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Rata-rata Baris yang Difilter di Google Spreadsheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai spreadsheet berikut yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21153 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt1.png\" alt=\"\" width=\"457\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menambahkan filter pada data ini, kita bisa menyorot sel <strong>A1:B10<\/strong> , lalu klik tab <strong>Data<\/strong> , lalu klik <strong>Buat Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21154 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt2.png\" alt=\"\" width=\"504\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik ikon Filter di bagian atas kolom Poin dan hapus centang pada kotak di sebelah tiga nilai pertama 84, 89 dan 93:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21155 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt3.png\" alt=\"\" width=\"491\" height=\"642\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kami mengklik <strong>OK<\/strong> , data akan disaring untuk menghapus nilai-nilai ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mencoba menggunakan fungsi <strong>AVERAGE()<\/strong> untuk menghitung rata-rata kolom poin dari baris yang difilter, itu tidak akan mengembalikan nilai yang benar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-26817 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avgfilt1.jpg\" alt=\"\" width=\"477\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebagai gantinya, Anda harus menggunakan fungsi <strong>SUBTOTAL()<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-26818\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/avgfilt2.jpg\" alt=\"rata-rata baris yang difilter di Google Spreadsheet\" width=\"476\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini hanya mengambil rata-rata dari garis yang terlihat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat memeriksanya secara manual dengan merata-ratakan garis yang terlihat:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata garis terlihat: (99 + 94 + 97 + 104 + 109 + 99) \/ 6 = <strong>100.333<\/strong> .<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lembar-hitungan-google-memfilter-baris\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung baris yang difilter di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menjumlahkan-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan baris yang difilter di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk mengambil rata-rata rentang yang difilter di Google Spreadsheet adalah dengan menggunakan sintaks berikut: SUBTOTAL( 101 , A1:A10 ) Perhatikan bahwa nilai 101 adalah jalan pintas untuk mengambil rata-rata rentang baris yang difilter. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Rata-rata Baris yang Difilter di Google Spreadsheet Misalkan kita mempunyai [&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 Rata-rata Baris yang Difilter di Google Spreadsheet (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata baris yang difilter di Google Spreadsheet, 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-yang-difilter-rata-rata-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Rata-rata Baris yang Difilter di Google Spreadsheet (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata baris yang difilter di Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T22:55:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt1.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\/garis-yang-difilter-rata-rata-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/\",\"name\":\"Cara Rata-rata Baris yang Difilter di Google Spreadsheet (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T22:55:07+00:00\",\"dateModified\":\"2023-07-18T22:55:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai rata-rata baris yang difilter di Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara rata-rata baris yang difilter di google spreadsheet (dengan contoh)\"}]},{\"@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 Rata-rata Baris yang Difilter di Google Spreadsheet (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata baris yang difilter di Google Spreadsheet, 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-yang-difilter-rata-rata-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Rata-rata Baris yang Difilter di Google Spreadsheet (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata baris yang difilter di Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-18T22:55:07+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommefilt1.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\/garis-yang-difilter-rata-rata-google-sheet\/","url":"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/","name":"Cara Rata-rata Baris yang Difilter di Google Spreadsheet (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T22:55:07+00:00","dateModified":"2023-07-18T22:55:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata baris yang difilter di Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/garis-yang-difilter-rata-rata-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara rata-rata baris yang difilter di google spreadsheet (dengan contoh)"}]},{"@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\/3156"}],"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=3156"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3156\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}