{"id":1639,"date":"2023-07-25T13:44:18","date_gmt":"2023-07-25T13:44:18","guid":{"rendered":"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/"},"modified":"2023-07-25T13:44:18","modified_gmt":"2023-07-25T13:44:18","slug":"petak-hutan-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/","title":{"rendered":"Cara membuat plot hutan di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Plot hutan<\/strong> (terkadang disebut \u201cblobbogram\u201d) digunakan dalam meta-analisis untuk memvisualisasikan hasil berbagai penelitian dalam satu plot.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16172 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel14.png\" alt=\"\" width=\"508\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">teh<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jenis plot ini memberikan cara mudah untuk melihat hasil beberapa penelitian secara bersamaan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara membuat plot hutan di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan data dari masing-masing penelitian dengan format sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16159 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel1.png\" alt=\"\" width=\"495\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat Diagram Batang Horizontal<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot sel dalam rentang A2:B21. Di pita atas, klik tab <strong>Sisipkan<\/strong> , lalu klik opsi 2D Grouped Bar di bagian <strong>Bagan<\/strong> . Diagram batang horizontal berikut akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16160 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel2.png\" alt=\"\" width=\"432\" height=\"365\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Pindahkan Label Sumbu ke Kiri<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik dua kali label sumbu vertikal. Di panel <strong>Format Axis<\/strong> yang muncul di sisi kanan layar, atur <strong>posisi label<\/strong> ke Rendah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16161 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel3.png\" alt=\"\" width=\"270\" height=\"568\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan memindahkan label sumbu vertikal ke sisi kiri grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16162 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel4-1.png\" alt=\"\" width=\"443\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Tambahkan Poin Cloud Point<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menambahkan rangkaian baru bernama <strong>Poin<\/strong> yang akan kita gunakan untuk menambahkan titik plot sebar ke bagan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16163 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel5.png\" alt=\"\" width=\"500\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan di mana saja pada plot dan klik <strong>Select Data<\/strong> . Di jendela baru yang muncul, klik <strong>Tambah<\/strong> untuk menambahkan seri baru. Kemudian biarkan nama serinya kosong dan klik <strong>OK<\/strong> . Ini akan menambahkan satu bilah ke plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16164 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel6.png\" alt=\"\" width=\"442\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan satu batang oranye dan klik <strong>Ubah Jenis Bagan Seri<\/strong> . Di jendela baru yang muncul, ganti Seri2 dengan plot sebar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16165 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel7.png\" alt=\"\" width=\"558\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , satu titik plot sebar akan muncul pada grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16166 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel8.png\" alt=\"\" width=\"447\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan satu titik oranye dan klik <strong>Pilih Data<\/strong> . Di jendela yang muncul, klik <strong>Seri2<\/strong> lalu klik <strong>Edit<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Gunakan rentang sel yang berisi ukuran efek untuk nilai x dan rentang sel yang berisi titik untuk nilai y. Lalu klik <strong>oke<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Titik awan berikut akan ditambahkan ke plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16167 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel9.png\" alt=\"\" width=\"613\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 5: Hapus Batangan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan pada salah satu bilah di jalur dan ubah warna isian menjadi <strong>Tanpa Isi<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16168 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel10.png\" alt=\"\" width=\"443\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik dua kali sumbu y di sebelah kanan dan ubah batas sumbu menjadi minimal 0 dan maksimal 20. Kemudian klik sumbu y di sebelah kanan dan hapus. Anda akan mendapatkan plot berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16169 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel11.png\" alt=\"\" width=\"428\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 6: Tambahkan Bilah Kesalahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tanda plus kecil berwarna hijau di pojok kanan atas plot. Di menu tarik-turun, centang kotak di sebelah <strong>Bilah kesalahan<\/strong> . Kemudian klik salah satu bilah kesalahan vertikal di salah satu titik dan klik Hapus untuk menghapus bilah kesalahan vertikal dari setiap titik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik <strong>Opsi Lainnya<\/strong> dari daftar drop-down di sebelah bilah kesalahan. Di panel yang muncul di sebelah kanan, tentukan bilah kesalahan khusus yang akan digunakan untuk batas atas dan bawah interval kepercayaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16170 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel12.png\" alt=\"\" width=\"392\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menghasilkan bilah kesalahan berikut pada plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16171 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel13.png\" alt=\"\" width=\"448\" height=\"405\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 7: Tambahkan Label Judul dan Sumbu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Terakhir, jangan ragu untuk menambahkan judul dan label sumbu serta memodifikasi warna grafik untuk tampilan yang lebih estetis:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16172\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel14.png\" alt=\"Grafik hutan di Excel\" width=\"561\" height=\"476\" srcset=\"\" sizes=\"\"><\/p>\n<hr>\n<p> <span style=\"color: #000000;\">Anda dapat menemukan tutorial visualisasi Excel lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot hutan (terkadang disebut \u201cblobbogram\u201d) digunakan dalam meta-analisis untuk memvisualisasikan hasil berbagai penelitian dalam satu plot. teh Jenis plot ini memberikan cara mudah untuk melihat hasil beberapa penelitian secara bersamaan. Contoh langkah demi langkah berikut ini memperlihatkan cara membuat plot hutan di Excel. Langkah 1: Masukkan datanya Pertama, kita akan memasukkan data dari masing-masing penelitian [&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 Plot Hutan di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat plot hutan di Excel, dengan 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\/petak-hutan-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Hutan di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat plot hutan di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T13:44:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel14.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\/petak-hutan-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/\",\"name\":\"Cara Membuat Plot Hutan di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T13:44:18+00:00\",\"dateModified\":\"2023-07-25T13:44:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat plot hutan di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot hutan 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 Plot Hutan di Excel - Statorials","description":"Tutorial ini menjelaskan cara membuat plot hutan di Excel, dengan 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\/petak-hutan-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Hutan di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara membuat plot hutan di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T13:44:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/parcelle-forestiereexcel14.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\/petak-hutan-di-excel\/","url":"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/","name":"Cara Membuat Plot Hutan di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T13:44:18+00:00","dateModified":"2023-07-25T13:44:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat plot hutan di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/petak-hutan-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/petak-hutan-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot hutan 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\/1639"}],"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=1639"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1639\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}