{"id":2190,"date":"2023-07-23T08:06:07","date_gmt":"2023-07-23T08:06:07","guid":{"rendered":"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/"},"modified":"2023-07-23T08:06:07","modified_gmt":"2023-07-23T08:06:07","slug":"lebar-kelas-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/","title":{"rendered":"Cara menghitung lebar kelas di google sheets"},"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;\">Misalnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Lebar kelas untuk kelas pertama adalah 5 \u2013 1 = <strong>4<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Lebar kelas untuk kelas kedua adalah 10 \u2013 6 = <strong>4<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Lebar kelas untuk kelas ketiga adalah 15 \u2013 11 = <strong>4<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menghitung lebar kelas untuk kumpulan data apa pun 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> nilai maksimum dalam kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>min:<\/strong> nilai minimum dalam kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> 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 Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara menghitung lebar kelas di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data 20 nilai berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20188 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurfeuilles1.png\" alt=\"\" width=\"502\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat distribusi frekuensi untuk dataset ini menggunakan n = 5 kelas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus berikut di Google Sheets untuk mencari lebar kelas untuk distribusi frekuensi ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span style=\"color: #000000;\">=(MAX( <span style=\"color: #ff6600;\">A2:21<\/span> )-MIN( <span style=\"color: #ff6600;\">A2:A21<\/span> ))\/ <span style=\"color: #3366ff;\">5<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-20189 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/classelargeurfeuilles2.png\" alt=\"\" width=\"507\" height=\"490\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lebar kelas ternyata <strong>4.6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Biasanya, kita selalu membulatkan ke bilangan bulat terdekat, jadi dalam kasus ini kita akan menggunakan lebar kelas <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 hal berikut tentang distribusi frekuensi kami:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Lebar setiap kelas adalah 5.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai di kolom \u201cFrekuensi\u201d berjumlah 20. Ini adalah jumlah total nilai dalam kumpulan data kami.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan pendekatan umum ini untuk menghitung lebar kelas distribusi frekuensi untuk kumpulan data apa pun di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/cara-mencari-ukuran-kelas\/\" target=\"_blank\" rel=\"noopener\">Cara Menemukan Ukuran Kelas (Dengan Contoh)<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/cara-mencari-interval-kelas\/\" target=\"_blank\" rel=\"noopener\">Cara Mencari Interval Kelas: Dengan Contoh<\/a><br \/> Cara Menemukan Batasan Kelas: Dengan Contoh<\/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: Lebar kelas untuk kelas pertama adalah 5 \u2013 1 = 4 Lebar kelas untuk kelas kedua adalah 10 \u2013 6 = 4 Lebar kelas untuk kelas ketiga adalah [&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 Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung lebar kelas di Google Sheets, dengan sebuah contoh.\" \/>\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\/lebar-kelas-google-sheet\/\" \/>\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 Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung lebar kelas di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T08:06:07+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\/lebar-kelas-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/\",\"name\":\"Cara Menghitung Lebar Kelas di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T08:06:07+00:00\",\"dateModified\":\"2023-07-23T08:06:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung lebar kelas di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung lebar kelas di google sheets\"}]},{\"@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 Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung lebar kelas di Google Sheets, dengan sebuah contoh.","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\/lebar-kelas-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Lebar Kelas di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung lebar kelas di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-23T08:06:07+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\/lebar-kelas-google-sheet\/","url":"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/","name":"Cara Menghitung Lebar Kelas di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T08:06:07+00:00","dateModified":"2023-07-23T08:06:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung lebar kelas di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lebar-kelas-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung lebar kelas di google sheets"}]},{"@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\/2190"}],"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=2190"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2190\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}