{"id":716,"date":"2023-07-29T00:15:03","date_gmt":"2023-07-29T00:15:03","guid":{"rendered":"https:\/\/statorials.org\/id\/kelas-lebar-excel\/"},"modified":"2023-07-29T00:15:03","modified_gmt":"2023-07-29T00:15:03","slug":"kelas-lebar-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelas-lebar-excel\/","title":{"rendered":"Cara menghitung lebar kelas di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam distribusi frekuensi, <b>lebar kelas<\/b> mengacu pada perbedaan antara batas atas dan bawah suatu kelas atau kategori.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, distribusi frekuensi berikut memiliki lebar bin <strong>4<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7102 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel1.png\" alt=\"Tabel frekuensi di Excel\" width=\"239\" height=\"163\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>misalnya<\/strong> \u2013 lebar kelas untuk kelas pertama adalah 5-1 = <strong>4<\/strong> . Lebar kelas untuk kelas kedua adalah 10-6 = <strong>4<\/strong> , dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dan distribusi frekuensi berikut mempunyai lebar kelas <strong>9 :<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7103 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel2.png\" alt=\"Distribusi frekuensi di Excel\" width=\"239\" height=\"175\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>misalnya<\/strong> \u2013 lebar kelas untuk kelas pertama adalah 10-1 = <strong>9<\/strong> . Lebar kelas untuk kelas kedua adalah 20-11 = <strong>9<\/strong> , dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda memiliki kumpulan nilai data mentah, Anda bisa menghitung kelas lebar menggunakan rumus berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Lebar kelas<\/strong> = (maks \u2013 min) \/ n<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>max<\/strong> adalah nilai maksimum dalam suatu kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>min<\/strong> adalah nilai minimum dalam kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> adalah jumlah kelas yang ingin Anda gunakan<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menghitung lebar kelas untuk kumpulan data di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara menghitung lebar kelas di excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data 20 nilai berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7104 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel3.png\" alt=\"Data mentah di Excel\" width=\"366\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung lebar kelas pada distribusi frekuensi kumpulan data ini, kita hanya perlu memutuskan berapa banyak kelas yang ingin kita gunakan. Katakanlah kita ingin menggunakan n = 5. Selanjutnya kita dapat menggunakan rumus berikut untuk mencari lebar kelas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7105 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel4.png\" alt=\"Menghitung Lebar Kelas di Excel\" width=\"482\" height=\"406\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lebar kelas adalah <strong>4.6<\/strong> . Untuk memudahkan, kita biasanya membulatkan ke bilangan bulat terdekat, jadi dalam kasus ini kita akan menggunakan <strong>5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita dapat membuat tabel frekuensi yang menggunakan lebar kelas 5:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7107 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel5-1.png\" alt=\"Menghitung Lebar Kelas di Excel\" width=\"427\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa lebar setiap bin adalah 5 dan jumlah nilai di kolom \u201cFrekuensi\u201d berjumlah 20, yang merupakan jumlah total nilai dalam kumpulan data kita.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam distribusi frekuensi, lebar kelas mengacu pada perbedaan antara batas atas dan bawah suatu kelas atau kategori. Misalnya, distribusi frekuensi berikut memiliki lebar bin 4 : misalnya \u2013 lebar kelas untuk kelas pertama adalah 5-1 = 4 . Lebar kelas untuk kelas kedua adalah 10-6 = 4 , dan seterusnya. Dan distribusi frekuensi berikut mempunyai [&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 Lebar Kelas di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung lebar kelas untuk distribusi frekuensi di Excel.\" \/>\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\/kelas-lebar-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Lebar Kelas di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung lebar kelas untuk distribusi frekuensi di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelas-lebar-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T00:15:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel1.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\/kelas-lebar-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kelas-lebar-excel\/\",\"name\":\"Cara Menghitung Lebar Kelas di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T00:15:03+00:00\",\"dateModified\":\"2023-07-29T00:15:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung lebar kelas untuk distribusi frekuensi di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelas-lebar-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelas-lebar-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelas-lebar-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung lebar kelas 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 Lebar Kelas di Excel \u2013 Statorials","description":"Penjelasan sederhana cara menghitung lebar kelas untuk distribusi frekuensi di Excel.","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\/kelas-lebar-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Lebar Kelas di Excel \u2013 Statorials","og_description":"Penjelasan sederhana cara menghitung lebar kelas untuk distribusi frekuensi di Excel.","og_url":"https:\/\/statorials.org\/id\/kelas-lebar-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T00:15:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurexcel1.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\/kelas-lebar-excel\/","url":"https:\/\/statorials.org\/id\/kelas-lebar-excel\/","name":"Cara Menghitung Lebar Kelas di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T00:15:03+00:00","dateModified":"2023-07-29T00:15:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung lebar kelas untuk distribusi frekuensi di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelas-lebar-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelas-lebar-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelas-lebar-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung lebar kelas 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\/716"}],"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=716"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/716\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}