{"id":4890,"date":"2023-07-06T19:00:19","date_gmt":"2023-07-06T19:00:19","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/"},"modified":"2023-07-06T19:00:19","modified_gmt":"2023-07-06T19:00:19","slug":"excel-temukan-5-angka-yang-paling-sering-muncul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/","title":{"rendered":"Excel: cara menemukan 5 angka yang paling sering muncul"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan rumus berikut untuk menemukan 5 angka paling sering dalam daftar di Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MODE(IF(ISERROR(MATCH( <span style=\"color: #3366ff;\">$A$2:$A$24<\/span> , <span style=\"color: #ff0000;\">C$1:C1<\/span> ,0)), <span style=\"color: #3366ff;\">$A$2:$A$24<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini akan menemukan nilai paling sering dalam rentang <strong>A2:A24<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat mengklik dan menyeret rumus ini ke empat sel tambahan untuk menemukan 5 angka paling sering dalam rentang <strong>A2:A24<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: temukan 5 angka yang paling sering muncul di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar angka berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38192 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mos1.png\" alt=\"\" width=\"499\" height=\"538\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mencari 5 angka yang paling sering muncul dalam daftar ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=MODE(IF(ISERROR(MATCH( <span style=\"color: #3366ff;\">$A$2:$A$24<\/span> , <span style=\"color: #ff0000;\">C$1:C1<\/span> ,0)), <span style=\"color: #3366ff;\">$A$2:$A$24<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke empat sel lain di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38193\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mos2.png\" alt=\"Excel menemukan 5 angka yang paling sering muncul\" width=\"633\" height=\"550\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kolom C sekarang menampilkan lima angka yang paling sering muncul di kolom A.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mencari frekuensi setiap angka, selanjutnya kita dapat mengetikkan rumus berikut pada sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">$A$2:$A$24<\/span> , <span style=\"color: #ff0000;\">C2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38194 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mos3.png\" alt=\"\" width=\"512\" height=\"544\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Angka <strong>4<\/strong> paling sering muncul dalam daftar. Ini terjadi 6 kali.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Angka <strong>15<\/strong> paling sering muncul kedua dalam daftar. Ini terjadi 4 kali.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Angka <strong>5<\/strong> paling sering muncul ketiga dalam daftar. Ini terjadi 3 kali.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menawarkan informasi tambahan tentang cara menghitung frekuensi di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Distribusi Frekuensi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-relatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Relatif di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/frekuensi-kumulatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Kumulatif di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan rumus berikut untuk menemukan 5 angka paling sering dalam daftar di Excel: =MODE(IF(ISERROR(MATCH( $A$2:$A$24 , C$1:C1 ,0)), $A$2:$A$24 )) Rumus khusus ini akan menemukan nilai paling sering dalam rentang A2:A24 . Anda kemudian dapat mengklik dan menyeret rumus ini ke empat sel tambahan untuk menemukan 5 angka paling sering dalam rentang A2:A24 [&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 Menemukan 5 Angka Paling Sering - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menemukan 5 angka paling sering dalam daftar 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\/excel-temukan-5-angka-yang-paling-sering-muncul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara Menemukan 5 Angka Paling Sering - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menemukan 5 angka paling sering dalam daftar di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T19:00:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mos1.png\" \/>\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\/excel-temukan-5-angka-yang-paling-sering-muncul\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/\",\"name\":\"Excel: Cara Menemukan 5 Angka Paling Sering - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T19:00:19+00:00\",\"dateModified\":\"2023-07-06T19:00:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menemukan 5 angka paling sering dalam daftar di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menemukan 5 angka yang paling sering muncul\"}]},{\"@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 Menemukan 5 Angka Paling Sering - Statologi","description":"Tutorial ini menjelaskan cara menemukan 5 angka paling sering dalam daftar 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\/excel-temukan-5-angka-yang-paling-sering-muncul\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara Menemukan 5 Angka Paling Sering - Statologi","og_description":"Tutorial ini menjelaskan cara menemukan 5 angka paling sering dalam daftar di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/","og_site_name":"Statorials","article_published_time":"2023-07-06T19:00:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/mos1.png"}],"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\/excel-temukan-5-angka-yang-paling-sering-muncul\/","url":"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/","name":"Excel: Cara Menemukan 5 Angka Paling Sering - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T19:00:19+00:00","dateModified":"2023-07-06T19:00:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menemukan 5 angka paling sering dalam daftar di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-temukan-5-angka-yang-paling-sering-muncul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menemukan 5 angka yang paling sering muncul"}]},{"@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\/4890"}],"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=4890"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4890\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}