{"id":3250,"date":"2023-07-18T11:30:17","date_gmt":"2023-07-18T11:30:17","guid":{"rendered":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/"},"modified":"2023-07-18T11:30:17","modified_gmt":"2023-07-18T11:30:17","slug":"regresi-logaritmik-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/","title":{"rendered":"Cara melakukan regresi logaritma di google sheets"},"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 <a href=\"https:\/\/statorials.org\/id\/variabel-tanggapan-penjelas\/\" target=\"_blank\" rel=\"noopener\">variabel respon<\/a> 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 menunjukkan cara melakukan regresi logaritmik di Google Spreadsheet.<\/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=\" wp-image-27553 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logreg11.jpg\" alt=\"\" width=\"480\" height=\"501\" 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=\" wp-image-27552 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logreg12.jpg\" alt=\"\" width=\"490\" height=\"495\" 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.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, ketik rumus berikut di sel <strong>E2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">LINEST<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2:B16<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #993366;\">C2:C16<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Setelah Anda menekan <strong>Enter<\/strong> , koefisien dari<\/span> <span style=\"color: #000000;\">model regresi logaritmik akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-27551\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logreg13.jpg\" alt=\"regresi logaritmik di Google Spreadsheet\" width=\"658\" height=\"550\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan koefisien dari hasil tersebut, kita dapat melihat bahwa persamaan regresi logaritma 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> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">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<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/regresi-linier-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi linier di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi polinomial di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Sisa di Google Sheets<\/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>Cara Melakukan Regresi Logaritma di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan regresi logaritmik di Google Sheets, dengan contoh lengkap.\" \/>\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-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Regresi Logaritma di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan regresi logaritmik di Google Sheets, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T11:30:17+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=\"1 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-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/\",\"name\":\"Cara Melakukan Regresi Logaritma di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T11:30:17+00:00\",\"dateModified\":\"2023-07-18T11:30:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan regresi logaritmik di Google Sheets, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan regresi logaritma di google sheets\"}]},{\"@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 Melakukan Regresi Logaritma di Google Sheets \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan regresi logaritmik di Google Sheets, dengan contoh lengkap.","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-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Regresi Logaritma di Google Sheets \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan regresi logaritmik di Google Sheets, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-18T11:30:17+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":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/","url":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/","name":"Cara Melakukan Regresi Logaritma di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T11:30:17+00:00","dateModified":"2023-07-18T11:30:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan regresi logaritmik di Google Sheets, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/regresi-logaritmik-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan regresi logaritma di google sheets"}]},{"@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\/3250"}],"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=3250"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3250\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}