{"id":1434,"date":"2023-07-26T10:03:27","date_gmt":"2023-07-26T10:03:27","guid":{"rendered":"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/"},"modified":"2023-07-26T10:03:27","modified_gmt":"2023-07-26T10:03:27","slug":"ubah-lebar-bin-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/","title":{"rendered":"Cara mengubah lebar bin histogram di excel"},"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 membuat histogram di Excel dan mengubah <strong>lebar bin<\/strong> sehingga histogram terlihat persis seperti yang Anda inginkan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kita akan membuat kumpulan data berikut yang menunjukkan pendapatan tahunan 26 orang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14180 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine1.png\" alt=\"\" width=\"461\" height=\"533\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat histogram<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kami akan menyorot dua kolom data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14181 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine2.png\" alt=\"\" width=\"448\" height=\"542\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita klik tab <strong>INSERT<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Histogram<\/strong> di bagian <strong>Charts<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14182 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine3.png\" alt=\"\" width=\"548\" height=\"254\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini menciptakan histogram berikut secara default:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14183 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine4.png\" alt=\"\" width=\"540\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan Lebar Bin<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menyesuaikan lebar nampan, klik kanan sumbu horizontal histogram, lalu klik <strong>Format Sumbu<\/strong> dari daftar drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14184 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine5.png\" alt=\"\" width=\"448\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela yang muncul di sebelah kanan, kita dapat melihat bahwa Excel telah memilih lebar bin <strong>29000.<\/strong> Kita dapat mengubahnya ke nomor berapa pun yang kita inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menambah lebar bin menjadi <strong>50.000<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14186 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine6.png\" alt=\"Ubah Lebar Bin di Excel\" width=\"616\" height=\"312\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bagaimana hal ini menambah lebar setiap nampan dan mengurangi jumlah total nampan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat mengurangi lebar bin menjadi <strong>10.000:<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14187 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine7.png\" alt=\"Kurangi Lebar Bin di Excel\" width=\"674\" height=\"352\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hal ini mengurangi lebar masing-masing kelompok dan meningkatkan jumlah kelompok dalam histogram.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk mengubah lebar bin ke nilai apa pun yang Anda inginkan, dan ingatlah aturan praktis berikut ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Menambah lebar nampan<\/strong> sering kali mengurangi jumlah nampan dalam histogram dan menghasilkan nampan yang lebih sedikit dan lebih besar.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Mengurangi lebar grup<\/strong> sering kali meningkatkan jumlah grup dalam histogram dan menyebabkan grup menjadi lebih sempit dan lebih banyak.<\/span><\/li>\n<\/ul>\n<hr>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan tutorial Excel lainnya di halaman ini .<\/em><\/span><\/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 membuat histogram di Excel dan mengubah lebar bin sehingga histogram terlihat persis seperti yang Anda inginkan. Langkah 1: Buat datanya Pertama, kita akan membuat kumpulan data berikut yang menunjukkan pendapatan tahunan 26 [&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 mengubah lebar bin histogram di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah lebar kotak histogram di Excel, dengan beberapa 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\/ubah-lebar-bin-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengubah lebar bin histogram di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah lebar kotak histogram di Excel, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T10:03:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine1.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\/ubah-lebar-bin-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/\",\"name\":\"Cara mengubah lebar bin histogram di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T10:03:27+00:00\",\"dateModified\":\"2023-07-26T10:03:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah lebar kotak histogram di Excel, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah lebar bin histogram 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 mengubah lebar bin histogram di Excel","description":"Tutorial ini menjelaskan cara mengubah lebar kotak histogram di Excel, dengan beberapa 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\/ubah-lebar-bin-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengubah lebar bin histogram di Excel","og_description":"Tutorial ini menjelaskan cara mengubah lebar kotak histogram di Excel, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T10:03:27+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/largeurbine1.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\/ubah-lebar-bin-excel\/","url":"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/","name":"Cara mengubah lebar bin histogram di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T10:03:27+00:00","dateModified":"2023-07-26T10:03:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah lebar kotak histogram di Excel, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ubah-lebar-bin-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah lebar bin histogram 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\/1434"}],"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=1434"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1434\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}