{"id":908,"date":"2023-07-28T08:45:02","date_gmt":"2023-07-28T08:45:02","guid":{"rendered":"https:\/\/statorials.org\/id\/log-plot-log-excel\/"},"modified":"2023-07-28T08:45:02","modified_gmt":"2023-07-28T08:45:02","slug":"log-plot-log-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/log-plot-log-excel\/","title":{"rendered":"Cara membuat plot log-log di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Plot log-log<\/strong> adalah plot sebar yang menggunakan skala logaritmik pada sumbu x dan sumbu y.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jenis plot ini berguna untuk memvisualisasikan dua variabel ketika hubungan sebenarnya di antara keduanya mengikuti hukum pangkat. Fenomena ini terjadi di banyak bidang kehidupan nyata, termasuk astronomi, biologi, kimia, dan fisika.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menunjukkan cara membuat plot log-log untuk dua variabel di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Log-Log Plot di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel yang memperlihatkan nilai dua variabel, x dan y:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9679 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel1.png\" alt=\"\" width=\"344\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gunakan langkah-langkah berikut untuk membuat plot log-log untuk kumpulan data ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Buat diagram sebar.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Sorot data dalam rentang <strong>A2:B11<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9680 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel2.png\" alt=\"\" width=\"399\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di pita atas, klik tab <strong>Sisipkan<\/strong> . Di grup <strong>Grafik<\/strong> , klik <strong>Menyebarkan<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9681 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel3.png\" alt=\"\" width=\"478\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara otomatis akan muncul point cloud berikut ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9682 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel4.png\" alt=\"\" width=\"446\" height=\"363\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Ubah skala sumbu X menjadi logaritmik.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik kanan nilai di sepanjang sumbu x dan klik <strong>Format Axis<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9683 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel5.png\" alt=\"\" width=\"452\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, centang kotak di samping <strong>Skala logaritma<\/strong> untuk mengubah skala sumbu X.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9684 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel6.png\" alt=\"Skala logaritmik untuk membuat plot di Excel\" width=\"280\" height=\"575\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Ubah skala sumbu Y menjadi logaritmik.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik pada sumbu y dan ulangi langkah yang sama untuk mengubah skala sumbu y menjadi logaritmik. Plot yang dihasilkan akan terlihat seperti ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9685 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel7.png\" alt=\"Log-Log Plot di Excel\" width=\"538\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hal ini menunjukkan bahwa kedua variabel tersebut memang mempunyai hubungan hukum kuasa.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em><strong>Anda dapat menemukan lebih banyak tutorial Excel di sini .<\/strong><\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot log-log adalah plot sebar yang menggunakan skala logaritmik pada sumbu x dan sumbu y. Jenis plot ini berguna untuk memvisualisasikan dua variabel ketika hubungan sebenarnya di antara keduanya mengikuti hukum pangkat. Fenomena ini terjadi di banyak bidang kehidupan nyata, termasuk astronomi, biologi, kimia, dan fisika. Tutorial ini menunjukkan cara membuat plot log-log untuk dua [&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 Log-Log di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat log-log plot di excel beserta contohnya.\" \/>\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\/log-plot-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 Plot Log-Log di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat log-log plot di excel beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/log-plot-log-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T08:45:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel1.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\/log-plot-log-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/log-plot-log-excel\/\",\"name\":\"Cara Membuat Plot Log-Log di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T08:45:02+00:00\",\"dateModified\":\"2023-07-28T08:45:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat log-log plot di excel beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/log-plot-log-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/log-plot-log-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/log-plot-log-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot log-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 Plot Log-Log di Excel - Statorials","description":"Penjelasan sederhana cara membuat log-log plot di excel beserta contohnya.","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\/log-plot-log-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Log-Log di Excel - Statorials","og_description":"Penjelasan sederhana cara membuat log-log plot di excel beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/log-plot-log-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T08:45:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/loglogexcel1.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\/log-plot-log-excel\/","url":"https:\/\/statorials.org\/id\/log-plot-log-excel\/","name":"Cara Membuat Plot Log-Log di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T08:45:02+00:00","dateModified":"2023-07-28T08:45:02+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat log-log plot di excel beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/log-plot-log-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/log-plot-log-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/log-plot-log-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot log-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\/908"}],"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=908"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/908\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}