{"id":3617,"date":"2023-07-16T12:40:50","date_gmt":"2023-07-16T12:40:50","guid":{"rendered":"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/"},"modified":"2023-07-16T12:40:50","modified_gmt":"2023-07-16T12:40:50","slug":"pegangan-rata-rata-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/","title":{"rendered":"Cara menghitung rata-rata terpangkas di excel"},"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 teratas dari akhir kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung rata-rata terpangkas di Excel, Anda bisa menggunakan fungsi <strong>TRIMMEAN<\/strong> , yang menggunakan sintaks dasar berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>TRIMMEAN (array, persentase)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>array<\/strong> : Rentang yang berisi kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>persen<\/strong> : Persentase 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 Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29781 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture2-1.jpg\" alt=\"\" width=\"477\" height=\"505\" 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;\"> <span style=\"color: #000000;\"><strong>TRIMMEAN( <span style=\"color: #3366ff;\">A2:A21<\/span> , 0.1)<\/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-29782 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture3.jpg\" alt=\"\" width=\"513\" height=\"548\" 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 kumpulan data khusus ini, ada 20 nilai total. Jadi 10% dari 20 adalah 2.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, untuk menghitung rata-rata terpangkas 10% dalam contoh ini, Excel harus menghapus dua nilai dari ujung kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya Excel membuang 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 menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rata-rata-bersyarat-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Bersyarat di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kesalahan-standar-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Standard Error Mean di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kartu-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean Absolute Percentage Error (MAPE) di Excel<\/a><\/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 teratas dari akhir kumpulan data. Untuk menghitung rata-rata terpangkas di Excel, Anda bisa 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 Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung mean terpangkas 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\/pegangan-rata-rata-unggul\/\" \/>\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 Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung mean terpangkas di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T12:40:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture2-1.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\/pegangan-rata-rata-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/\",\"name\":\"Cara menghitung rata-rata terpangkas di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T12:40:50+00:00\",\"dateModified\":\"2023-07-16T12:40:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung mean terpangkas di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata terpangkas 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 rata-rata terpangkas di Excel - Statorials","description":"Tutorial ini menjelaskan cara menghitung mean terpangkas 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\/pegangan-rata-rata-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata terpangkas di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung mean terpangkas di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-16T12:40:50+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/garniture2-1.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\/pegangan-rata-rata-unggul\/","url":"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/","name":"Cara menghitung rata-rata terpangkas di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T12:40:50+00:00","dateModified":"2023-07-16T12:40:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung mean terpangkas di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pegangan-rata-rata-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata terpangkas 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\/3617"}],"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=3617"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3617\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}