{"id":2851,"date":"2023-07-20T10:12:14","date_gmt":"2023-07-20T10:12:14","guid":{"rendered":"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/"},"modified":"2023-07-20T10:12:14","modified_gmt":"2023-07-20T10:12:14","slug":"rata-rata-unggul-per-kelompok","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/","title":{"rendered":"Cara menghitung rata-rata berdasarkan kelompok di excel"},"content":{"rendered":"

<\/p>\n

\n

Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung nilai rata-rata berdasarkan grup di Excel.<\/span><\/p>\n

Contoh: menghitung rata-rata berdasarkan kelompok di Excel<\/strong><\/span><\/h2>\n

Pertama, masukkan kumpulan data berikut yang menunjukkan total poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n

\"\"<\/p>\n

Sekarang misalkan kita ingin mencari nilai rata-rata poin yang dicetak, dikelompokkan berdasarkan tim.<\/span><\/p>\n

Untuk melakukan ini, kita dapat menggunakan fungsi UNIQUE()<\/strong> untuk membuat daftar tim unik terlebih dahulu.<\/span><\/p>\n

Kami akan mengetikkan rumus berikut di sel E2<\/strong> :<\/span><\/p>\n

 = SINGLE<\/span> ( B2:B12<\/span> )<\/strong><\/pre>\n
 Setelah kita menekan Enter<\/strong> , daftar nama tim unik akan ditampilkan:<\/span> <\/p>\n
\"\"<\/p>\n
 Selanjutnya, kita dapat menggunakan fungsi =AVERAGEIF()<\/strong> untuk mencari rata-rata poin yang dicetak oleh pemain di setiap tim:<\/span><\/p>\n
 =AVERAGEIF( $B$2:$B$12<\/span> , E2<\/span> , $C$2:$C$12<\/span> )\n<\/strong><\/span><\/pre>\n
 Kami akan mengetikkan rumus ini di sel F2<\/strong> , menyalinnya, dan menempelkannya ke setiap sel yang tersisa di kolom F:<\/span> <\/p>\n
\"rata-rata<\/p>\n
 Kolom E menampilkan masing-masing tim unik dan kolom F menampilkan nilai rata-rata poin yang dicetak setiap tim.<\/span><\/p>\n
 Kami dapat memverifikasi kebenaran hasil ini dengan menghitung rata-rata salah satu tim secara manual.<\/span><\/p>\n
 Misalnya, rata-rata poin yang dicetak oleh pemain di tim Spurs adalah:<\/span><\/p>\n
 Rata-rata poin pemain Spurs: (13.7 + 12.7 + 22.4) \/ 3 = 12.26667<\/strong> .<\/span><\/p>\n
 Ini sesuai dengan nilai yang dihitung menggunakan rumus.<\/span><\/p>\n
 Catatan<\/strong> : Dokumentasi lengkap rumus AVERAGE<\/strong> di Excel dapat Anda temukan di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n
 Cara Menghitung Rangkuman Lima Angka di Excel<\/a>
 Cara Menghitung Mean dan Deviasi Standar di Excel<\/a>
 Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung nilai rata-rata berdasarkan grup di Excel. Contoh: menghitung rata-rata berdasarkan kelompok di Excel Pertama, masukkan kumpulan data berikut yang menunjukkan total poin yang dicetak oleh pemain bola basket yang berbeda: Sekarang misalkan kita ingin mencari nilai rata-rata poin yang dicetak, dikelompokkan berdasarkan tim. Untuk melakukan ini, […]<\/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":"\nCara menghitung rata-rata berdasarkan kelompok di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata berdasarkan kelompok 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\/rata-rata-unggul-per-kelompok\/\" \/>\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 berdasarkan kelompok di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai rata-rata berdasarkan kelompok di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T10:12:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/test1.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\/rata-rata-unggul-per-kelompok\/\",\"url\":\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\",\"name\":\"Cara menghitung rata-rata berdasarkan kelompok di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T10:12:14+00:00\",\"dateModified\":\"2023-07-20T10:12:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai rata-rata berdasarkan kelompok di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata berdasarkan kelompok 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 berdasarkan kelompok di Excel - Statologi","description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata berdasarkan kelompok 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\/rata-rata-unggul-per-kelompok\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata berdasarkan kelompok di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata berdasarkan kelompok di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/","og_site_name":"Statorials","article_published_time":"2023-07-20T10:12:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/test1.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\/rata-rata-unggul-per-kelompok\/","url":"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/","name":"Cara menghitung rata-rata berdasarkan kelompok di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T10:12:14+00:00","dateModified":"2023-07-20T10:12:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai rata-rata berdasarkan kelompok di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata berdasarkan kelompok 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\/2851"}],"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=2851"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2851\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}