{"id":2147,"date":"2023-07-23T12:14:03","date_gmt":"2023-07-23T12:14:03","guid":{"rendered":"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/"},"modified":"2023-07-23T12:14:03","modified_gmt":"2023-07-23T12:14:03","slug":"menghitung-frekuensi-teks-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/","title":{"rendered":"Cara menghitung frekuensi teks di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>COUNTIF(rentang, kriteria)<\/strong> untuk menghitung seberapa sering teks tertentu muncul di kolom Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menghitung frekuensi teks tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kolom berikut di Excel yang menampilkan nama tim NBA yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19884 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/count_text1.png\" alt=\"\" width=\"503\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita ingin menghitung seberapa sering nama tim &#8220;Hornets&#8221; muncul di kolom, kita bisa menggunakan rumus berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=COUNTIF( <span style=\"color: #3366ff;\">A2:A21<\/span> , \"Hornets\")\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-19885 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/count_text2.png\" alt=\"\" width=\"494\" height=\"540\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa \u201cHornets\u201d muncul <strong>sebanyak 3<\/strong> kali.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menghitung frekuensi beberapa teks<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita ingin menghitung frekuensi beberapa teks berbeda, kita dapat menggunakan fungsi <strong>UNIQUE()<\/strong> untuk mendapatkan array dari setiap teks unik yang muncul dalam sebuah kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19886 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/count_text3.png\" alt=\"\" width=\"499\" height=\"549\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan fungsi <strong>COUNTIF()<\/strong> untuk menghitung seberapa sering setiap nama tim muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19887 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/count_text4.png\" alt=\"\" width=\"498\" height=\"545\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa melihat ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nama tim \u201cMavericks\u201d muncul <strong>3<\/strong> kali.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nama tim \u201cSpurs\u201d muncul <strong>dua kali<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nama tim \u201cLakers\u201d muncul <strong>3<\/strong> kali.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menawarkan informasi tambahan tentang cara menghitung frekuensi di Excel:<\/span><\/p>\n<p> <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><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi COUNTIF(rentang, kriteria) untuk menghitung seberapa sering teks tertentu muncul di kolom Excel. Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh 1: Menghitung frekuensi teks tertentu Katakanlah kita memiliki kolom berikut di Excel yang menampilkan nama tim NBA yang berbeda: Jika kita ingin menghitung seberapa sering nama tim &#8220;Hornets&#8221; muncul [&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 Frekuensi Teks di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung frekuensi teks dalam kolom 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\/menghitung-frekuensi-teks-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Frekuensi Teks di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung frekuensi teks dalam kolom di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T12:14:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/count_text1.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\/menghitung-frekuensi-teks-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\",\"name\":\"Cara Menghitung Frekuensi Teks di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T12:14:03+00:00\",\"dateModified\":\"2023-07-23T12:14:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung frekuensi teks dalam kolom di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung frekuensi teks 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 Frekuensi Teks di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung frekuensi teks dalam kolom 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\/menghitung-frekuensi-teks-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Frekuensi Teks di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung frekuensi teks dalam kolom di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-23T12:14:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/count_text1.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\/menghitung-frekuensi-teks-di-excel\/","url":"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/","name":"Cara Menghitung Frekuensi Teks di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T12:14:03+00:00","dateModified":"2023-07-23T12:14:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung frekuensi teks dalam kolom di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung frekuensi teks 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\/2147"}],"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=2147"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2147\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}