{"id":3616,"date":"2023-07-16T12:51:08","date_gmt":"2023-07-16T12:51:08","guid":{"rendered":"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/"},"modified":"2023-07-16T12:51:08","modified_gmt":"2023-07-16T12:51:08","slug":"pengurangan-rata-rata-di-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/","title":{"rendered":"Cara menghitung rata-rata terpangkas di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Rata-rata yang dipangkas<\/strong> adalah rata-rata kumpulan data yang telah dihitung setelah menghilangkan persentase tertentu dari nilai terkecil dan terbesar dalam kumpulan data tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, rata-rata terpangkas 10% akan mewakili rata-rata kumpulan data setelah menghilangkan 10% nilai dari ujung kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung rata-rata terpangkas di Google Spreadsheet, Anda dapat menggunakan fungsi <strong>TRIMMEAN<\/strong> , yang menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>TRIMMEAN(data, kecualikan_proporsi)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>data<\/strong> : Rentang yang berisi kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>include_proportion<\/strong> : Proporsi data yang akan dikecualikan (antara 0 dan 1)<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini untuk menghitung rata-rata terpangkas dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Hitung Rata-Rata Terpangkas di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29762 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins1.jpg\" alt=\"\" width=\"447\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut untuk menghitung rata-rata terpangkas 10% untuk kumpulan data ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>TRIMMEAN( <span style=\"color: #ff6600;\">A2:A21<\/span> , <span style=\"color: #3366ff;\">0.1<\/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-29773 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture1-1.jpg\" alt=\"\" width=\"462\" height=\"523\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata pemangkasan 10% dari kumpulan data adalah <strong>7.61<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh khusus ini, ada 20 nilai total dalam kumpulan data. Jadi 10% dari 20 adalah 2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, untuk menghitung rata-rata pemangkasan 10% dalam contoh ini, Google Spreadsheet harus menghapus dua nilai dari ujung kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya, Google Spreadsheet menghapus nilai terkecil (2) dan nilai terbesar (15) dari kumpulan data, lalu menghitung rata-ratanya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami dapat memastikan bahwa rumus tersebut benar dengan menghitung sendiri rata-rata terpangkas ini secara manual:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata terpotong pada 10%: (2+3+3+4+5+6+7+7+7+7+8+8+9+10+11+12+14+14) \/ 18 = <strong>7.61<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh khusus ini, nilai yang dihapus dari ujungnya jelas bukan outlier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, rata-rata yang dipangkas lebih berguna dalam praktiknya ketika terdapat outlier ekstrem dalam kumpulan data dan Anda ingin menghitung nilai rata-rata tanpa membiarkan outlier tersebut <a href=\"https:\/\/statorials.org\/id\/bagaimana-outlier-mempengaruhi-mean\/\" target=\"_blank\" rel=\"noopener\">memengaruhi penghitungan<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut memberikan informasi tambahan tentang rata-rata yang dipangkas:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menghitung-rata-rata-yang-disesuaikan\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Terpangkas Secara Manual<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ukuran-sedang-dengan-python\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung mean terpangkas dengan Python<\/a><br \/> Kalkulator Rata-rata yang Dipangkas<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Rata-rata yang dipangkas adalah rata-rata kumpulan data yang telah dihitung setelah menghilangkan persentase tertentu dari nilai terkecil dan terbesar dalam kumpulan data tersebut. Misalnya, rata-rata terpangkas 10% akan mewakili rata-rata kumpulan data setelah menghilangkan 10% nilai dari ujung kumpulan data. Untuk menghitung rata-rata terpangkas di Google Spreadsheet, Anda dapat menggunakan fungsi TRIMMEAN , yang menggunakan [&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 rata-rata terpangkas di Google Sheets \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata terpangkas di Google Sheets, 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\/pengurangan-rata-rata-di-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung rata-rata terpangkas di Google Sheets \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata terpangkas di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T12:51:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins1.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\/pengurangan-rata-rata-di-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/\",\"name\":\"Cara menghitung rata-rata terpangkas di Google Sheets \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T12:51:08+00:00\",\"dateModified\":\"2023-07-16T12:51:08+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata terpangkas di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata terpangkas di google spreadsheet\"}]},{\"@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 rata-rata terpangkas di Google Sheets \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata terpangkas di Google Sheets, 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\/pengurangan-rata-rata-di-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata terpangkas di Google Sheets \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata terpangkas di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-16T12:51:08+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins1.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\/pengurangan-rata-rata-di-google-sheet\/","url":"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/","name":"Cara menghitung rata-rata terpangkas di Google Sheets \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T12:51:08+00:00","dateModified":"2023-07-16T12:51:08+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata terpangkas di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pengurangan-rata-rata-di-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata terpangkas di google spreadsheet"}]},{"@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\/3616"}],"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=3616"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3616\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}