{"id":3615,"date":"2023-07-16T12:58:45","date_gmt":"2023-07-16T12:58:45","guid":{"rendered":"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/"},"modified":"2023-07-16T12:58:45","modified_gmt":"2023-07-16T12:58:45","slug":"tempat-sampah-histogram-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/","title":{"rendered":"Google sheets: cara mengubah jumlah bin di histogram"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Histogram<\/strong> adalah plot yang dapat digunakan untuk memvisualisasikan dengan cepat distribusi nilai dalam suatu kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah cara membuat histogram di Google Sheets dan mengubah <strong>jumlah kotak<\/strong> sehingga histogram terlihat persis seperti yang Anda inginkan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, mari buat kumpulan data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29762 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins1.jpg\" alt=\"\" width=\"463\" height=\"546\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat histogram<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang <strong>A2:A21<\/strong> , lalu klik tab <strong>Sisipkan<\/strong> , lalu <strong>Bagan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29763 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins2.jpg\" alt=\"\" width=\"519\" height=\"567\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, klik panah drop-down di bawah <strong>Chart Type<\/strong> dan pilih <strong>Histogram Chart<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29764 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins3.jpg\" alt=\"\" width=\"312\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Histogram berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29765 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins4.jpg\" alt=\"\" width=\"510\" height=\"327\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan jumlah nampan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk menyesuaikan jumlah nampan dalam histogram, klik tab <strong>Kustomisasi<\/strong> di panel <strong>Editor Bagan<\/strong> , lalu klik panah tarik-turun di samping <strong>Histogram<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik panah drop-down di bawah <strong>Ukuran Bucket<\/strong> untuk melihat daftar kemungkinan ukuran bucket yang dapat Anda gunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29766 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins5.jpg\" alt=\"\" width=\"323\" height=\"567\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mengklik <strong>2<\/strong> , itu akan mengubah ukuran ember menjadi <strong>2<\/strong> di histogram:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29767 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins6.jpg\" alt=\"\" width=\"543\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Keranjang pertama memberi tahu kita berapa banyak nilai dalam kumpulan data asli yang lebih besar atau sama dengan 2 tetapi kurang dari 4.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Keranjang kedua memberi tahu kita berapa banyak nilai dalam kumpulan data asli yang lebih besar atau sama dengan 4 tetapi kurang dari 6.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita memilih ukuran ember <strong>10<\/strong> , ember tersebut akan memiliki lebar 10:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29768 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins7.jpg\" alt=\"\" width=\"583\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengubah jumlah nampan ke nilai apa pun yang Anda inginkan dan ingatlah aturan praktis berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Menambah ukuran bin<\/strong> akan menurunkan jumlah total grup dalam histogram dan menghasilkan grup yang semakin besar.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Mengurangi ukuran bin<\/strong> akan meningkatkan jumlah total grup dalam histogram dan menyebabkan grup menjadi lebih sempit dan lebih banyak.<\/span><\/li>\n<\/ul>\n<h2> <strong>Sumber daya tambahan<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/bagan-gelembung-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Gelembung di Google Spreadsheet<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/diagram-lingkaran-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Diagram Lingkaran di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grafik-jumlah-kumulatif-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Bagan Jumlah Berjalan di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Histogram adalah plot yang dapat digunakan untuk memvisualisasikan dengan cepat distribusi nilai dalam suatu kumpulan data. Tutorial ini memberikan contoh langkah demi langkah cara membuat histogram di Google Sheets dan mengubah jumlah kotak sehingga histogram terlihat persis seperti yang Anda inginkan. Langkah 1: Buat datanya Pertama, mari buat kumpulan data berikut: Langkah 2: Buat histogram [&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>Google Spreadsheet: Cara mengubah jumlah bin di histogram - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah jumlah bin yang digunakan dalam histogram 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\/tempat-sampah-histogram-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengubah jumlah bin di histogram - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah jumlah bin yang digunakan dalam histogram di Google Sheets, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T12:58:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins1.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\/tempat-sampah-histogram-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/\",\"name\":\"Google Spreadsheet: Cara mengubah jumlah bin di histogram - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T12:58:45+00:00\",\"dateModified\":\"2023-07-16T12:58:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah jumlah bin yang digunakan dalam histogram di Google Sheets, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengubah jumlah bin di histogram\"}]},{\"@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":"Google Spreadsheet: Cara mengubah jumlah bin di histogram - Statorials","description":"Tutorial ini menjelaskan cara mengubah jumlah bin yang digunakan dalam histogram 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\/tempat-sampah-histogram-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengubah jumlah bin di histogram - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah jumlah bin yang digunakan dalam histogram di Google Sheets, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-16T12:58:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/histbins1.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\/tempat-sampah-histogram-google-sheet\/","url":"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/","name":"Google Spreadsheet: Cara mengubah jumlah bin di histogram - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T12:58:45+00:00","dateModified":"2023-07-16T12:58:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah jumlah bin yang digunakan dalam histogram di Google Sheets, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tempat-sampah-histogram-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengubah jumlah bin di histogram"}]},{"@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\/3615"}],"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=3615"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3615\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}