{"id":2879,"date":"2023-07-20T07:01:34","date_gmt":"2023-07-20T07:01:34","guid":{"rendered":"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/"},"modified":"2023-07-20T07:01:34","modified_gmt":"2023-07-20T07:01:34","slug":"unggul-dalam-mode-tabel-pivot","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/","title":{"rendered":"Excel: cara menghitung mode dalam tabel pivot"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghitung mode dalam tabel pivot Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sayangnya, Excel tidak memiliki fitur bawaan untuk mode penghitungan, namun Anda bisa menggunakan fungsi MODE IF sebagai solusinya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-median-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Median di PivotTable Excel<\/a><\/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 mode per grup<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita bisa menggunakan rumus berikut untuk menghitung mode nilai poin setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MODE(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-25162 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/modepivot1.jpg\" alt=\"\" width=\"535\" height=\"445\" 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-25163 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/modepivot2.jpg\" alt=\"\" width=\"627\" height=\"474\" 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>Mode Titik<\/b> ke area <strong>Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25164 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/modepivot3.jpg\" alt=\"\" width=\"355\" height=\"596\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Berikutnya, klik panah tarik-turun <strong>Jumlah Poin Mode<\/strong> , lalu klik <strong>Pengaturan Bidang Nilai<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25165 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/modepivot4.jpg\" alt=\"\" width=\"364\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, ubah nama kustom menjadi <strong>Pts Mode<\/strong> , lalu klik <strong>Rata-rata<\/strong> sebagai nilai ringkasan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25167 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/modepivot5-1.jpg\" alt=\"\" width=\"406\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , jumlah poin yang dicetak untuk setiap mode tim akan ditambahkan ke tabel pivot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-25168\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/modepivot6-1.jpg\" alt=\"metode perhitungan dalam tabel pivot Excel\" width=\"581\" height=\"435\" 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 yang 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;\">Jumlah poin yang dicetak oleh setiap mode 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 mode dalam tabel pivot Excel. Sayangnya, Excel tidak memiliki fitur bawaan untuk mode penghitungan, namun Anda bisa menggunakan fungsi MODE IF sebagai solusinya. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Terkait: Cara Menghitung Median di PivotTable Excel Langkah 1: Masukkan datanya Pertama, masukkan data berikut yang menunjukkan [&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 mode dalam tabel pivot - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung mode dalam tabel pivot 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\/unggul-dalam-mode-tabel-pivot\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menghitung mode dalam tabel pivot - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung mode dalam tabel pivot Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T07:01:34+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\/unggul-dalam-mode-tabel-pivot\/\",\"url\":\"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/\",\"name\":\"Excel: Cara menghitung mode dalam tabel pivot - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T07:01:34+00:00\",\"dateModified\":\"2023-07-20T07:01:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung mode dalam tabel pivot Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menghitung mode 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 mode dalam tabel pivot - Statorial","description":"Tutorial ini menjelaskan cara menghitung mode dalam tabel pivot 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\/unggul-dalam-mode-tabel-pivot\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menghitung mode dalam tabel pivot - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung mode dalam tabel pivot Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/","og_site_name":"Statorials","article_published_time":"2023-07-20T07:01:34+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\/unggul-dalam-mode-tabel-pivot\/","url":"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/","name":"Excel: Cara menghitung mode dalam tabel pivot - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T07:01:34+00:00","dateModified":"2023-07-20T07:01:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung mode dalam tabel pivot Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/unggul-dalam-mode-tabel-pivot\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menghitung mode 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\/2879"}],"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=2879"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2879\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}