{"id":2146,"date":"2023-07-23T12:22:14","date_gmt":"2023-07-23T12:22:14","guid":{"rendered":"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/"},"modified":"2023-07-23T12:22:14","modified_gmt":"2023-07-23T12:22:14","slug":"distribusi-frekuensi-persentase-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/","title":{"rendered":"Cara membuat distribusi frekuensi persentase di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Distribusi persentase frekuensi<\/strong> dapat digunakan untuk memahami berapa persentase distribusi yang terdiri dari nilai-nilai tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara membuat distribusi frekuensi persentase di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita buat kumpulan data yang berisi informasi tentang 20 pemain bola basket berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19873 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence1.png\" alt=\"\" width=\"501\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung frekuensi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>UNIQUE()<\/strong> untuk menghasilkan array nilai tim unik di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19874 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence2.png\" alt=\"\" width=\"495\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>COUNTIF()<\/strong> untuk menghitung berapa kali setiap tim muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19875 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence3.png\" alt=\"\" width=\"498\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah Frekuensi menjadi Persentase<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengonversi setiap frekuensi menjadi persentase dengan membagi setiap frekuensi dengan jumlah frekuensinya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19876 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence4.png\" alt=\"\" width=\"502\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyorot masing-masing nilai di kolom F dan klik ikon <strong>persentase<\/strong> (%) di grup <strong>Angka<\/strong> di sepanjang pita atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19877 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence5.png\" alt=\"\" width=\"637\" height=\"381\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai secara otomatis akan ditampilkan sebagai persentase:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19878 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence6.png\" alt=\"\" width=\"364\" height=\"263\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat bahwa:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>35%<\/strong> dari semua pemain tergabung dalam tim A<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>25%<\/strong> dari semua pemain tergabung dalam tim B<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>15%<\/strong> dari semua pemain tergabung dalam tim C<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>25%<\/strong> dari semua pemain tergabung dalam tim D<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa persentasenya berjumlah 100%.<\/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\/frekuensi-kumulatif-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Frekuensi Kumulatif di Excel<\/a><br \/> <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-poligon-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Poligon Frekuensi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi persentase frekuensi dapat digunakan untuk memahami berapa persentase distribusi yang terdiri dari nilai-nilai tertentu. Contoh langkah demi langkah berikut ini memperlihatkan cara membuat distribusi frekuensi persentase di Excel. Langkah 1: Buat datanya Pertama, mari kita buat kumpulan data yang berisi informasi tentang 20 pemain bola basket berbeda: Langkah 2: Hitung frekuensi Selanjutnya, kita akan [&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 Membuat Distribusi Frekuensi Persentase di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat distribusi frekuensi persentase 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\/distribusi-frekuensi-persentase-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Distribusi Frekuensi Persentase di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat distribusi frekuensi persentase di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T12:22:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence1.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\/distribusi-frekuensi-persentase-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/\",\"name\":\"Cara Membuat Distribusi Frekuensi Persentase di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T12:22:14+00:00\",\"dateModified\":\"2023-07-23T12:22:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat distribusi frekuensi persentase di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat distribusi frekuensi persentase 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 Membuat Distribusi Frekuensi Persentase di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat distribusi frekuensi persentase 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\/distribusi-frekuensi-persentase-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Distribusi Frekuensi Persentase di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat distribusi frekuensi persentase di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-23T12:22:14+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/frequence1.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\/distribusi-frekuensi-persentase-unggul\/","url":"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/","name":"Cara Membuat Distribusi Frekuensi Persentase di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T12:22:14+00:00","dateModified":"2023-07-23T12:22:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat distribusi frekuensi persentase di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat distribusi frekuensi persentase 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\/2146"}],"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=2146"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2146\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}