{"id":1653,"date":"2023-07-25T12:30:30","date_gmt":"2023-07-25T12:30:30","guid":{"rendered":"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/"},"modified":"2023-07-25T12:30:30","modified_gmt":"2023-07-25T12:30:30","slug":"grafik-semi-log-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/","title":{"rendered":"Cara membuat bagan semi-log di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Bagan semi logaritma<\/strong> adalah jenis bagan yang menggunakan skala logaritma pada sumbu y dan skala linier pada sumbu x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bagan jenis ini sering digunakan ketika nilai variabel y mempunyai variabilitas yang jauh lebih besar dibandingkan nilai variabel x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hal ini sering terjadi pada kumpulan data di bidang keuangan, ekonomi, biologi, astronomi, dan bidang lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara membuat bagan semi-logaritmik di Excel untuk kumpulan data tertentu.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai dari kumpulan data palsu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16292 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel1.png\" alt=\"\" width=\"494\" height=\"481\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Buat diagram sebar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot nilai data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16293 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel2.png\" alt=\"\" width=\"470\" height=\"467\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di pita atas, klik <strong>Sisipkan<\/strong> . Kemudian klik opsi pertama di bawah opsi <strong>Scatter<\/strong> Plot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16294 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/disperserexcel.png\" alt=\"\" width=\"530\" height=\"218\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Cloud titik berikut akan otomatis ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel3.png\" alt=\"\" width=\"586\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari grafik terlihat bahwa nilai variabel y mempunyai variabilitas yang jauh lebih tinggi dibandingkan dengan nilai variabel x.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya, sebaiknya ubah sumbu y menjadi skala logaritmik untuk memvisualisasikan nilai y dengan lebih efektif.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah Skala Sumbu Y<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan pada sumbu Y. Di menu tarik-turun yang muncul, klik <strong>Format Sumbu<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16296 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel4.png\" alt=\"\" width=\"563\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul di sebelah kanan layar, centang kotak di sebelah <strong>Skala logaritma<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16297 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel5.png\" alt=\"\" width=\"284\" height=\"566\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu y secara otomatis akan dikonversi ke skala logaritmik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16298 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel6.png\" alt=\"\" width=\"540\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x tetap pada skala linier, namun sumbu y telah diubah menjadi skala logaritmik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan betapa mudahnya menafsirkan nilai y pada grafik ini dibandingkan dengan grafik sebelumnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/log-plot-log-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Log-Log di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengubah-data-menjadi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Mentransformasi Data di Excel (Log, Akar Kuadrat, Akar Kubus)<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/transformasi-box-cox-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana melakukan transformasi Box-Cox di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagan semi logaritma adalah jenis bagan yang menggunakan skala logaritma pada sumbu y dan skala linier pada sumbu x. Bagan jenis ini sering digunakan ketika nilai variabel y mempunyai variabilitas yang jauh lebih besar dibandingkan nilai variabel x. Hal ini sering terjadi pada kumpulan data di bidang keuangan, ekonomi, biologi, astronomi, dan bidang lainnya. Contoh [&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 Semi-Log di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat bagan semi-logaritma 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\/grafik-semi-log-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 Semi-Log di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat bagan semi-logaritma di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T12:30:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel1.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\/grafik-semi-log-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/\",\"name\":\"Cara Membuat Bagan Semi-Log di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T12:30:30+00:00\",\"dateModified\":\"2023-07-25T12:30:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat bagan semi-logaritma di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat bagan semi-log 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 Semi-Log di Excel","description":"Tutorial ini menjelaskan cara membuat bagan semi-logaritma 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\/grafik-semi-log-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Bagan Semi-Log di Excel","og_description":"Tutorial ini menjelaskan cara membuat bagan semi-logaritma di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T12:30:30+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/semilogexcel1.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\/grafik-semi-log-excel\/","url":"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/","name":"Cara Membuat Bagan Semi-Log di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T12:30:30+00:00","dateModified":"2023-07-25T12:30:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat bagan semi-logaritma di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grafik-semi-log-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grafik-semi-log-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat bagan semi-log 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\/1653"}],"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=1653"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1653\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}