{"id":1445,"date":"2023-07-26T08:59:31","date_gmt":"2023-07-26T08:59:31","guid":{"rendered":"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/"},"modified":"2023-07-26T08:59:31","modified_gmt":"2023-07-26T08:59:31","slug":"regresi-eksponensial-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/","title":{"rendered":"Regresi eksponensial di excel (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Regresi eksponensial<\/strong> adalah jenis model regresi yang dapat digunakan untuk memodelkan situasi berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Pertumbuhan Eksponensial:<\/strong> Pertumbuhan dimulai secara perlahan dan kemudian meningkat dengan cepat dan tanpa batas.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14288 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel1.png\" alt=\"\" width=\"396\" height=\"295\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>2. Peluruhan eksponensial:<\/strong> Peluruhan dimulai dengan cepat dan kemudian melambat hingga mendekati nol.<\/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=\"411\" height=\"311\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Persamaan model regresi eksponensial berbentuk sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = <sup>abx<\/sup><\/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 eksponensial 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 kita buat kumpulan data palsu yang berisi 20 <a href=\"https:\/\/statorials.org\/id\/pengamatan-dalam-statistik\/\" target=\"_blank\" rel=\"noopener\">observasi<\/a> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14290 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel3.png\" alt=\"\" width=\"348\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Ambil log natural dari variabel respon<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu membuat kolom baru yang mewakili logaritma natural dari variabel respon <em>y<\/em> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14291 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel4.png\" alt=\"\" width=\"370\" height=\"487\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Sesuaikan model regresi eksponensial<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menyesuaikan model regresi eksponensial. 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-14292 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel5.png\" alt=\"\" width=\"533\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , keluaran model regresi eksponensial akan ditampilkan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14293 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel6.png\" alt=\"Regresi Eksponensial di Excel\" width=\"463\" height=\"441\" 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 204,006 dan nilai p yang sesuai sangat rendah, menunjukkan bahwa model secara keseluruhan bermanfaat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan koefisien dari tabel keluaran, kita dapat melihat bahwa persamaan regresi eksponensial yang sesuai adalah:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>ln(y) = 0,9817 + 0,2041(x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Menerapkan <em>e<\/em> pada kedua ruas, kita dapat menulis ulang persamaannya sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 2,6689 * <sup>1,2264x<\/sup><\/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> = 14, maka kita prediksi <em>y<\/em> adalah <strong>46.47<\/strong> :<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = 2,6689 * 1,2264 <sup>14<\/sup> = 46,47<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Bonus:<\/strong> Jangan ragu untuk menggunakan kalkulator regresi eksponensial online ini untuk secara otomatis menghitung persamaan regresi eksponensial 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\/\" target=\"_blank\" rel=\"noopener\">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-kuadrat-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi kuadrat di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Polinomial di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regresi eksponensial adalah jenis model regresi yang dapat digunakan untuk memodelkan situasi berikut: 1. Pertumbuhan Eksponensial: Pertumbuhan dimulai secara perlahan dan kemudian meningkat dengan cepat dan tanpa batas. 2. Peluruhan eksponensial: Peluruhan dimulai dengan cepat dan kemudian melambat hingga mendekati nol. Persamaan model regresi eksponensial berbentuk sebagai berikut: kamu = abx Emas: y : variabel [&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 Eksponensial di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan regresi eksponensial 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-eksponensial-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Regresi Eksponensial di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan regresi eksponensial di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T08:59:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel1.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-eksponensial-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/\",\"name\":\"Regresi Eksponensial di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T08:59:31+00:00\",\"dateModified\":\"2023-07-26T08:59:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan regresi eksponensial di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Regresi eksponensial 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 Eksponensial di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara melakukan regresi eksponensial 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-eksponensial-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Regresi Eksponensial di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara melakukan regresi eksponensial di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-26T08:59:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/expregexcel1.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-eksponensial-unggul\/","url":"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/","name":"Regresi Eksponensial di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T08:59:31+00:00","dateModified":"2023-07-26T08:59:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan regresi eksponensial di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Regresi eksponensial 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\/1445"}],"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=1445"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1445\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}