{"id":2878,"date":"2023-07-20T07:09:03","date_gmt":"2023-07-20T07:09:03","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/"},"modified":"2023-07-20T07:09:03","modified_gmt":"2023-07-20T07:09:03","slug":"tabel-pivot-median-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/","title":{"rendered":"Excel: cara menghitung median dalam tabel pivot"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung nilai median dalam tabel pivot Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sayangnya, Excel tidak memiliki fitur bawaan untuk menghitung median, namun Anda bisa menggunakan fungsi MEDIAN IF sebagai solusinya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut yang menunjukkan poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25152 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median1.jpg\" alt=\"\" width=\"473\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung nilai median berdasarkan kelompok<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk menghitung nilai median poin setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MEDIAN(IF( <span style=\"color: #3366ff;\">$A$2:$B$13<\/span> = <span style=\"color: #ff0000;\">A2<\/span> , <span style=\"color: #800080;\">$B$2:$B$13<\/span> ))\n<\/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-25153 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median2.jpg\" alt=\"\" width=\"559\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Buat PivotTable<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat tabel pivot, klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>tabel pivot<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24299 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gp0.jpg\" alt=\"\" width=\"544\" height=\"117\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, pilih <strong>A1:C13<\/strong> sebagai rentang dan pilih untuk menempatkan tabel pivot di sel <strong>E1<\/strong> lembar kerja yang ada:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25154 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median3.jpg\" alt=\"\" width=\"676\" height=\"539\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , <strong>panel Bidang PivotTable<\/strong> baru akan muncul di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seret bidang <b>Tim<\/b> ke area <strong>Garis<\/strong> , lalu seret bidang <b>Titik<\/b> dan <b>Titik Tengah<\/b> ke area <strong>Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25155 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/medianepivot4.jpg\" alt=\"\" width=\"342\" height=\"578\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikutnya, klik panah tarik-turun <strong>Jumlah Titik Tengah<\/strong> , lalu klik <strong>Pengaturan Bidang Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25156 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median5.jpg\" alt=\"\" width=\"359\" height=\"562\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, ubah nama kustom menjadi <strong>Median Pts<\/strong> , lalu klik <strong>Rata-rata<\/strong> sebagai nilai ringkasan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25157 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median6.jpg\" alt=\"\" width=\"430\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , nilai median poin untuk setiap tim akan ditambahkan ke tabel pivot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25158 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median7.jpg\" alt=\"\" width=\"619\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel pivot sekarang berisi informasi berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Setiap nama tim unik<\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah poin yang dicetak oleh masing-masing tim<\/span><\/li>\n<li> <span style=\"color: #000000;\">Poin median yang dicetak oleh masing-masing tim<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/excel-mengurutkan-tabel-pivot-berdasarkan-total-umum\/\" target=\"_blank\" rel=\"noopener\">Cara mengurutkan tabel pivot berdasarkan total keseluruhan di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-rentang\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan nilai dalam tabel pivot berdasarkan rentang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-tabel-pivot-excel-berdasarkan-bulan-dan-tahun\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan bulan dan tahun dalam tabel pivot di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung nilai median dalam tabel pivot Excel. Sayangnya, Excel tidak memiliki fitur bawaan untuk menghitung median, namun Anda bisa menggunakan fungsi MEDIAN IF sebagai solusinya. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Masukkan datanya Pertama, masukkan data berikut yang menunjukkan poin yang dicetak oleh pemain bola [&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>Excel: Cara menghitung median dalam tabel pivot - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung median pada tabel pivot di Excel, dengan contoh lengkap.\" \/>\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\/tabel-pivot-median-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung median dalam tabel pivot - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung median pada tabel pivot di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T07:09:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median1.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\/tabel-pivot-median-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/\",\"name\":\"Excel: Cara menghitung median dalam tabel pivot - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T07:09:03+00:00\",\"dateModified\":\"2023-07-20T07:09:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung median pada tabel pivot di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung median dalam tabel pivot\"}]},{\"@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":"Excel: Cara menghitung median dalam tabel pivot - Statorials","description":"Tutorial ini menjelaskan cara menghitung median pada tabel pivot di Excel, dengan contoh lengkap.","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\/tabel-pivot-median-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung median dalam tabel pivot - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung median pada tabel pivot di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-20T07:09:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot-median1.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\/tabel-pivot-median-excel\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/","name":"Excel: Cara menghitung median dalam tabel pivot - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T07:09:03+00:00","dateModified":"2023-07-20T07:09:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung median pada tabel pivot di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung median dalam tabel pivot"}]},{"@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\/2878"}],"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=2878"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2878\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}