{"id":3940,"date":"2023-07-14T15:14:56","date_gmt":"2023-07-14T15:14:56","guid":{"rendered":"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/"},"modified":"2023-07-14T15:14:56","modified_gmt":"2023-07-14T15:14:56","slug":"median-excel-berdasarkan-kelompok","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/","title":{"rendered":"Cara menghitung median berdasarkan grup di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung nilai median berdasarkan grup di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/rata-rata-unggul-per-kelompok\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Berdasarkan Kelompok di Excel<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut yang menunjukkan total poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31673 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane1.jpg\" alt=\"\" width=\"472\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari nilai median dari poin yang dicetak, dikelompokkan berdasarkan tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukan ini, kita dapat menggunakan fungsi <strong>UNIQUE()<\/strong> untuk membuat daftar tim unik terlebih dahulu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #000000;\">SINGLE<\/span> ( <span style=\"color: #3366ff;\">B2:B12<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah kita menekan <strong>Enter<\/strong> , daftar nama tim unik akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31675 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane2.jpg\" alt=\"\" width=\"500\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk mencari nilai median poin yang dicetak pemain di setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong>=MEDIAN(IF( <span style=\"color: #3366ff;\">$B$2:$B$12<\/span> = <span style=\"color: #ff0000;\">E2<\/span> , <span style=\"color: #800080;\">$C$2:$C$12<\/span> ))\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus ini di sel <strong>F2<\/strong> , menyalinnya, dan menempelkannya ke setiap sel yang tersisa di kolom F:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-31676 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane3.jpg\" alt=\"\" width=\"564\" height=\"482\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom E menampilkan masing-masing tim unik dan kolom F menampilkan nilai median poin yang dicetak setiap tim.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai median poin pemain Lakers: <strong>16<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai median poin untuk pemain Mavericks: <strong>25<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai median poin pemain Spurs: <strong>30,5<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi kebenaran hasil ini dengan menghitung median salah satu tim secara manual.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya poin yang dicetak pemain tim Spurs adalah: 14, 28, 33, 35.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai median adalah nilai antara 28 dan 33, atau <strong>30.5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sesuai dengan nilai yang dihitung menggunakan rumus.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/jika-median-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Fungsi Median IF di Excel<\/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\/lima-digit-resume-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rangkuman Lima Angka di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mean-dan-deviasi-standar-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Mean dan Deviasi Standar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut ini memperlihatkan cara menghitung nilai median berdasarkan grup di Excel. Terkait: Cara Menghitung Rata-Rata Berdasarkan Kelompok di Excel Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data berikut yang menunjukkan total poin yang dicetak oleh pemain bola basket yang berbeda: Sekarang misalkan kita ingin mencari nilai median dari poin yang dicetak, [&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 berdasarkan grup di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung nilai median berdasarkan grup di Excel, dengan contoh langkah demi langkah.\" \/>\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\/median-excel-berdasarkan-kelompok\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung median berdasarkan grup di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung nilai median berdasarkan grup di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T15:14:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane1.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\/median-excel-berdasarkan-kelompok\/\",\"url\":\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/\",\"name\":\"Cara menghitung median berdasarkan grup di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T15:14:56+00:00\",\"dateModified\":\"2023-07-14T15:14:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung nilai median berdasarkan grup di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung median berdasarkan grup 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 berdasarkan grup di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung nilai median berdasarkan grup di Excel, dengan contoh langkah demi langkah.","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\/median-excel-berdasarkan-kelompok\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung median berdasarkan grup di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung nilai median berdasarkan grup di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/","og_site_name":"Statorials","article_published_time":"2023-07-14T15:14:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mediane1.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\/median-excel-berdasarkan-kelompok\/","url":"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/","name":"Cara menghitung median berdasarkan grup di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T15:14:56+00:00","dateModified":"2023-07-14T15:14:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung nilai median berdasarkan grup di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/median-excel-berdasarkan-kelompok\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung median berdasarkan grup 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\/3940"}],"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=3940"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3940\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}