{"id":646,"date":"2023-07-29T05:41:09","date_gmt":"2023-07-29T05:41:09","guid":{"rendered":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/"},"modified":"2023-07-29T05:41:09","modified_gmt":"2023-07-29T05:41:09","slug":"plot-batang-dan-daun-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/","title":{"rendered":"Cara membuat plot batang dan daun di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan batang dan daun<\/strong> adalah bagan yang dapat kita gunakan untuk menampilkan data dengan membagi setiap nilai dalam kumpulan data menjadi <em>batang<\/em> dan <em>daun<\/em> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut adalah contoh plot batang dan daun untuk kumpulan data tertentu, yang dibuat oleh<\/span> <a href=\"https:\/\/statorials.org\/id\/generator-diagram-batang-dan-daun\/\" target=\"_blank\" rel=\"noopener\">Statistics Stem and Leaf Plot Generator<\/a> : <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5806 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuillestata1.png\" sizes=\"\" srcset=\"\" alt=\"Contoh plot batang dan daun\" width=\"351\" height=\"485\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Batang<\/em> setiap nilai hanyalah digit pertama dari nilai sedangkan <em>daun<\/em> adalah digit kedua dari nilai tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang mari kita lihat cara membuat plot batang dan daun di Excel.<\/span><\/p>\n<h2> <strong>Contoh: Plot batang dan daun di Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk membuat plot batang dan daun di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Masukkan nilai data dalam satu kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6124 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuilleexcel1.png\" alt=\"Data mentah dalam satu kolom di Excel\" width=\"296\" height=\"305\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Identifikasi nilai minimum dan maksimum.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6125 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuilleexcel2.png\" alt=\"\" width=\"435\" height=\"309\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Masukkan \u201cbatang\u201d secara manual berdasarkan nilai minimum dan maksimum.<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6126 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuilleexcel3.png\" alt=\"Contoh Plotting Batang dan Daun di Excel\" width=\"439\" height=\"341\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung \u201cdaun\u201d untuk baris pertama.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhitungan berikut menunjukkan cara menghitung daun pada baris pertama. Jangan terintimidasi oleh panjangnya rumus \u2013 ini sebenarnya sangat sederhana, hanya berulang-ulang.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6127 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuilleexcel4.png\" alt=\"Menghitung Plot Batang dan Daun di Excel\" width=\"669\" height=\"270\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda selesai mengetik rumus dan klik Enter, Anda akan mendapatkan hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6128 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuilleexcel5.png\" alt=\"Menghitung Plot Batang dan Daun di Excel\" width=\"366\" height=\"305\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 5: Ulangi perhitungan untuk setiap baris.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengulangi perhitungan ini untuk setiap baris, cukup klik sel D7, arahkan kursor ke sudut kanan bawah sel hingga muncul tanda <strong>+<\/strong> kecil, lalu klik dua kali. Ini akan menyalin rumus ke seluruh baris di plot batang dan daun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-6129 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuilleexcel6.png\" alt=\"Contoh Plotting Batang dan Daun di Excel\" width=\"376\" height=\"313\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk memverifikasi bahwa hasil Anda benar, Anda dapat memeriksa tiga angka:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Pastikan jumlah \u201cdaun\u201d individu sesuai dengan jumlah pengamatan.<\/strong> Dalam contoh kita, kita memiliki total 10 \u201cdaun\u201d yang sesuai dengan 10 observasi dalam kumpulan data asli kita.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Periksa jumlah minimumnya.<\/strong> Lembar pertama harus sesuai dengan nilai minimum kumpulan data Anda. Dalam contoh kita, kita melihat bahwa daun pertama adalah &#8220;4&#8221; dan dikaitkan dengan batang &#8220;1&#8221; yang sesuai dengan jumlah minimum &#8220;14&#8221; dalam kumpulan data kita.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Periksa jumlah maksimum.<\/strong> Lembar terakhir harus menjadi nilai maksimum dalam kumpulan data Anda. Dalam contoh kita, kita melihat bahwa daun terakhir adalah &#8220;5&#8221; dan dikaitkan dengan batang &#8220;3&#8221; yang sesuai dengan jumlah minimum &#8220;35&#8221; dalam kumpulan data kita.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Setelah Anda memverifikasi ketiga angka ini, Anda dapat yakin bahwa plot batang dan daun Anda benar.<\/span><\/p>\n<h3> <strong>Sumber daya tambahan<\/strong><\/h3>\n<p> Pengantar Petak Batang dan Daun<br \/> <a href=\"https:\/\/statorials.org\/id\/diagram-batang-dan-daun-bolak-balik\/\" target=\"_blank\" rel=\"noopener\">Pengenalan plot batang dan daun secara berurutan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan batang dan daun adalah bagan yang dapat kita gunakan untuk menampilkan data dengan membagi setiap nilai dalam kumpulan data menjadi batang dan daun . Berikut adalah contoh plot batang dan daun untuk kumpulan data tertentu, yang dibuat oleh Statistics Stem and Leaf Plot Generator : Batang setiap nilai hanyalah digit pertama dari nilai sedangkan [&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 Membuat Bagan Batang dan Daun di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat plot batang dan daun di Excel, termasuk contoh langkah demi langkah.\" \/>\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\/plot-batang-dan-daun-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Bagan Batang dan Daun di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat plot batang dan daun di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T05:41:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuillestata1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/\",\"name\":\"Cara Membuat Bagan Batang dan Daun di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T05:41:09+00:00\",\"dateModified\":\"2023-07-29T05:41:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat plot batang dan daun di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot batang dan daun 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 Membuat Bagan Batang dan Daun di Excel - Statorials","description":"Penjelasan sederhana cara membuat plot batang dan daun di Excel, termasuk contoh langkah demi langkah.","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\/plot-batang-dan-daun-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Batang dan Daun di Excel - Statorials","og_description":"Penjelasan sederhana cara membuat plot batang dan daun di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T05:41:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/tigefeuillestata1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/","url":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/","name":"Cara Membuat Bagan Batang dan Daun di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T05:41:09+00:00","dateModified":"2023-07-29T05:41:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat plot batang dan daun di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/plot-batang-dan-daun-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot batang dan daun 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\/646"}],"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=646"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/646\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}