{"id":1453,"date":"2023-07-26T08:14:51","date_gmt":"2023-07-26T08:14:51","guid":{"rendered":"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/"},"modified":"2023-07-26T08:14:51","modified_gmt":"2023-07-26T08:14:51","slug":"regresi-logaritmik-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/","title":{"rendered":"Regresi logaritma di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Regresi logaritmik<\/strong> adalah jenis regresi yang digunakan untuk memodelkan situasi di mana pertumbuhan atau penurunan pada awalnya meningkat dengan cepat dan kemudian melambat seiring berjalannya waktu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, grafik berikut menunjukkan contoh peluruhan logaritmik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14289 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel2.png\" alt=\"\" width=\"375\" height=\"284\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk situasi seperti ini, hubungan antara variabel prediktor dan variabel respon dapat dimodelkan dengan baik menggunakan regresi logaritmik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Persamaan model regresi logaritma berbentuk sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>y = a + b*ln(x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>y :<\/strong> variabel respon<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x:<\/strong> variabel prediktif<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>a, b:<\/strong> koefisien regresi yang menggambarkan hubungan antara <em>x<\/em> dan <em>y<\/em><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara melakukan regresi logaritmik di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari buat data palsu untuk dua variabel: <em>x<\/em> dan <em>y<\/em> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14376 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logregexcel1.png\" alt=\"\" width=\"410\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Ambil log natural dari variabel prediktor<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu membuat kolom baru yang mewakili logaritma natural dari variabel prediktor <em>x<\/em> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14377 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logregexcel2.png\" alt=\"\" width=\"462\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan model regresi logaritma<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyesuaikan model regresi logaritmik. Untuk melakukannya, klik tab <strong>Data<\/strong> di pita atas, lalu klik <strong>Analisis Data<\/strong> di grup <strong>Analisis<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-5292 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"\" width=\"472\" height=\"180\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Jika Anda tidak melihat Analisis Data sebagai opsi, Anda harus <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">memuat Analysis ToolPak<\/a> terlebih dahulu.<\/em><\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela yang muncul, klik <strong>Regresi<\/strong> . Di jendela baru yang muncul, berikan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14378 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logregexcel3.png\" alt=\"\" width=\"583\" height=\"497\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , keluaran model regresi logaritmik akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14379 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logregexcel4.png\" alt=\"Keluaran regresi logaritmik di Excel\" width=\"492\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/panduan-sederhana-untuk-memahami-uji-f-untuk-signifikansi-keseluruhan-dalam-regresi\/\" target=\"_blank\" rel=\"noopener\">Nilai F keseluruhan<\/a> model adalah 828,18 dan nilai p yang sesuai sangat rendah (3,70174E-13), menunjukkan bahwa model secara keseluruhan berguna.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan koefisien dari tabel keluaran, kita dapat melihat bahwa persamaan regresi logaritmik yang sesuai adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 63,0686 \u2013 20,1987 * ln(x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan persamaan ini untuk memprediksi variabel respon <em>y<\/em> , berdasarkan nilai variabel prediktor <em>x<\/em> . Misalnya, jika <em>x<\/em> = 12, maka kita prediksi <em>y<\/em> adalah <strong>12.87<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\">y = 63,0686 \u2013 20,1987 * ln(12) = <strong>12,87<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Bonus:<\/strong> Jangan ragu untuk menggunakan kalkulator regresi logaritma online ini untuk secara otomatis menghitung persamaan regresi logaritma untuk variabel prediktor dan respons tertentu.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/excel-regresi-linier-sederhana\/\">Cara melakukan regresi linier sederhana di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi linier berganda di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Polinomial di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Eksponensial di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regresi logaritmik adalah jenis regresi yang digunakan untuk memodelkan situasi di mana pertumbuhan atau penurunan pada awalnya meningkat dengan cepat dan kemudian melambat seiring berjalannya waktu. Misalnya, grafik berikut menunjukkan contoh peluruhan logaritmik: Untuk situasi seperti ini, hubungan antara variabel prediktor dan variabel respon dapat dimodelkan dengan baik menggunakan regresi logaritmik. Persamaan model regresi logaritma [&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>Regresi Logaritma di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan regresi 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\/regresi-logaritmik-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Regresi Logaritma di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan regresi logaritma di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T08:14:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel2.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\/regresi-logaritmik-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/\",\"name\":\"Regresi Logaritma di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T08:14:51+00:00\",\"dateModified\":\"2023-07-26T08:14:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan regresi logaritma di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Regresi logaritma di excel (langkah demi langkah)\"}]},{\"@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":"Regresi Logaritma di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara melakukan regresi 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\/regresi-logaritmik-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Regresi Logaritma di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara melakukan regresi logaritma di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-26T08:14:51+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel2.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\/regresi-logaritmik-unggul\/","url":"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/","name":"Regresi Logaritma di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T08:14:51+00:00","dateModified":"2023-07-26T08:14:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan regresi logaritma di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/regresi-logaritmik-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Regresi logaritma di excel (langkah demi langkah)"}]},{"@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\/1453"}],"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=1453"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1453\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}