{"id":2953,"date":"2023-07-19T22:34:01","date_gmt":"2023-07-19T22:34:01","guid":{"rendered":"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/"},"modified":"2023-07-19T22:34:01","modified_gmt":"2023-07-19T22:34:01","slug":"mengelompokkan-data-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/","title":{"rendered":"Cara melakukan pengelompokan data di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Menempatkan data numerik ke dalam <strong>keranjang<\/strong> adalah cara yang berguna untuk meringkas distribusi nilai dalam kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan pengelompokan data di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: mengelompokkan data di excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang menunjukkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25620 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement1.jpg\" alt=\"\" width=\"443\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menempatkan setiap nilai ke dalam bin, kita dapat membuat kolom baru yang menentukan nilai terbesar untuk setiap bin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25621 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement2.jpg\" alt=\"\" width=\"454\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam contoh ini, kami menentukan bin berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">0-5<\/span><\/li>\n<li> <span style=\"color: #000000;\">6-10<\/span><\/li>\n<li> <span style=\"color: #000000;\">11-15<\/span><\/li>\n<li> <span style=\"color: #000000;\">16-20<\/span><\/li>\n<li> <span style=\"color: #000000;\">21-25<\/span><\/li>\n<li> <span style=\"color: #000000;\">26-30<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menghitung jumlah nilai data yang terdapat di setiap nampan, klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik <strong>Analisis Data<\/strong> di grup <strong>Analisis<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-22127 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boite-a-outils.png\" alt=\"\" width=\"426\" height=\"135\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika Anda tidak melihat opsi untuk analisis data, Anda harus <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">memuat perangkat lunak Analysis Toolpak gratis<\/a> terlebih dahulu di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, klik <strong>Histogram<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25622 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement3.jpg\" alt=\"\" width=\"545\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pilih A2:A16 sebagai <strong>Input Range<\/strong> , C2:C7 sebagai <strong>Bin Range<\/strong> , E2 sebagai <strong>Output Range<\/strong> dan centang kotak di sebelah <strong>Chart Output<\/strong> . Lalu klik <strong>oke<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25623 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement4.jpg\" alt=\"\" width=\"573\" height=\"527\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah nilai yang sesuai dengan setiap nampan akan dihitung secara otomatis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-25624 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement5.jpg\" alt=\"\" width=\"578\" height=\"425\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> nilai masuk ke dalam kotak 0-5.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>2<\/strong> nilai masuk ke dalam kotak 6-10.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> nilai masuk ke dalam kotak 11-15.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>1<\/strong> nilai masuk ke kotak 16-20.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>3<\/strong> nilai masuk ke dalam kotak 21-25.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>4<\/strong> nilai masuk ke dalam kotak 26-30.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai <strong>0<\/strong> lebih besar dari 30.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Histogram juga memungkinkan kita memvisualisasikan distribusi nilai data ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh ini, kita telah memilih untuk membuat setiap nampan memiliki lebar yang sama, namun kita dapat membuat nampan individual dengan ukuran berbeda jika kita mau.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-excel-10-teratas\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara Memfilter 10 Nilai Teratas di PivotTable<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengurutkan-tabel-pivot-berdasarkan-total-umum\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengurutkan tabel pivot berdasarkan total keseluruhan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-perbedaan-antara-dua-tabel-pivot\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menghitung selisih antara dua tabel pivot<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Menempatkan data numerik ke dalam keranjang adalah cara yang berguna untuk meringkas distribusi nilai dalam kumpulan data. Contoh berikut menunjukkan cara melakukan pengelompokan data di Excel. Contoh: mengelompokkan data di excel Misalkan kita mempunyai kumpulan data berikut yang menunjukkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda: Untuk menempatkan setiap nilai ke dalam [&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 Melakukan Pengelompokan Data di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan pengelompokan data di Excel, beserta contohnya.\" \/>\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\/mengelompokkan-data-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Pengelompokan Data di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan pengelompokan data di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T22:34:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement1.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\/mengelompokkan-data-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/\",\"name\":\"Cara Melakukan Pengelompokan Data di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T22:34:01+00:00\",\"dateModified\":\"2023-07-19T22:34:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan pengelompokan data di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan pengelompokan data di excel (dengan contoh)\"}]},{\"@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 Melakukan Pengelompokan Data di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara melakukan pengelompokan data di Excel, beserta contohnya.","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\/mengelompokkan-data-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Pengelompokan Data di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan pengelompokan data di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-19T22:34:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/regroupement1.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\/mengelompokkan-data-di-excel\/","url":"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/","name":"Cara Melakukan Pengelompokan Data di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T22:34:01+00:00","dateModified":"2023-07-19T22:34:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan pengelompokan data di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mengelompokkan-data-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan pengelompokan data di excel (dengan contoh)"}]},{"@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\/2953"}],"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=2953"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2953\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}