{"id":4843,"date":"2023-07-07T08:11:01","date_gmt":"2023-07-07T08:11:01","guid":{"rendered":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/"},"modified":"2023-07-07T08:11:01","modified_gmt":"2023-07-07T08:11:01","slug":"distribusi-frekuensi-berkelompok-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/","title":{"rendered":"Cara membuat distribusi frekuensi berkelompok di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Distribusi frekuensi berkerumun<\/strong> menggambarkan seberapa sering nilai dalam kumpulan data muncul dalam rentang berkerumun tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Cara termudah untuk membuat distribusi frekuensi yang dikelompokkan untuk kumpulan data di Excel adalah dengan menggunakan fungsionalitas <strong>Grup<\/strong> di PivotTable.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Membuat distribusi frekuensi berkelompok di Excel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37833 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf1.png\" alt=\"\" width=\"462\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat distribusi frekuensi yang dikelompokkan untuk kumpulan data ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot rentang <strong>A1:A16<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> di sepanjang pita atas, lalu klik ikon <strong>PivotTable<\/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=\"633\" height=\"136\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, masukkan informasi berikut lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37834 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf2.png\" alt=\"\" width=\"594\" height=\"488\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada panel <strong>Bidang PivotTable<\/strong> yang muncul di sisi kanan layar, seret <strong>titik<\/strong> ke area <strong>Baris<\/strong> dan area <strong>Nilai<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik panah drop-down di sebelah <strong>Point Sum<\/strong> dan klik <strong>Value Field Settings<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37835 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf3.png\" alt=\"\" width=\"354\" height=\"550\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Hitung<\/strong> di kotak <strong>Ringkas nilai bidang per<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37836 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf4.png\" alt=\"\" width=\"435\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan salah satu nilai di kolom <strong>Label Baris<\/strong> PivotTable, lalu klik <strong>Grup<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37837 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf5.png\" alt=\"\" width=\"467\" height=\"545\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, Anda dapat mengatur ukuran grup.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan memilih untuk mengelompokkan nilai dari <strong>1<\/strong> hingga <strong>20<\/strong> , dengan kelipatan <strong>5<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37839 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf6-1.png\" alt=\"\" width=\"523\" height=\"473\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah kita klik <strong>OK<\/strong> , tabel pivot akan secara otomatis mengelompokkan nilai data dari 1 hingga 20 dengan kelipatan 5 dan menghitung frekuensi setiap grup:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37840\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf7.png\" alt=\"Distribusi Frekuensi yang Dikelompokkan Excel\" width=\"484\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari distribusi frekuensi yang dikelompokkan kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada <strong>3<\/strong> nilai dalam dataset antara 1 dan 5.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>4<\/strong> nilai dalam dataset antara 6 dan 10.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>5<\/strong> nilai dalam dataset antara 11 dan 15.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>3<\/strong> nilai dalam dataset antara 16 dan 20.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami memilih untuk menggunakan ukuran bin <strong>5<\/strong> untuk distribusi frekuensi binned ini, namun jangan ragu untuk memilih ukuran bin apa pun yang Anda inginkan berdasarkan kumpulan data Anda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-persentase-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Distribusi Frekuensi Persentase di Excel<\/a><br \/> <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\/frekuensi-poligon-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Poligon Frekuensi di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Distribusi frekuensi berkerumun menggambarkan seberapa sering nilai dalam kumpulan data muncul dalam rentang berkerumun tertentu. Cara termudah untuk membuat distribusi frekuensi yang dikelompokkan untuk kumpulan data di Excel adalah dengan menggunakan fungsionalitas Grup di PivotTable. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Membuat distribusi frekuensi berkelompok di Excel Katakanlah kita memiliki kumpulan [&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 Clustered di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat distribusi frekuensi berkelompok di Excel, beserta contoh lengkapnya.\" \/>\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-berkelompok-excel\/\" \/>\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 Clustered di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat distribusi frekuensi berkelompok di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T08:11:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf1.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=\"2 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-berkelompok-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/\",\"name\":\"Cara Membuat Distribusi Frekuensi Clustered di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T08:11:01+00:00\",\"dateModified\":\"2023-07-07T08:11:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat distribusi frekuensi berkelompok di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat distribusi frekuensi berkelompok 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 Clustered di Excel \u2013 Statorials","description":"Tutorial ini menjelaskan cara membuat distribusi frekuensi berkelompok di Excel, beserta contoh lengkapnya.","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-berkelompok-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Distribusi Frekuensi Clustered di Excel \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara membuat distribusi frekuensi berkelompok di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-07T08:11:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gf1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/","url":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/","name":"Cara Membuat Distribusi Frekuensi Clustered di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T08:11:01+00:00","dateModified":"2023-07-07T08:11:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat distribusi frekuensi berkelompok di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/distribusi-frekuensi-berkelompok-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat distribusi frekuensi berkelompok 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\/4843"}],"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=4843"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4843\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}