{"id":723,"date":"2023-07-28T23:42:23","date_gmt":"2023-07-28T23:42:23","guid":{"rendered":"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/"},"modified":"2023-07-28T23:42:23","modified_gmt":"2023-07-28T23:42:23","slug":"regresi-logistik-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/","title":{"rendered":"Cara melakukan regresi logistik di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Regresi logistik<\/strong> adalah metode yang kami gunakan untuk menyesuaikan model regresi ketika variabel responsnya adalah biner.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukan regresi logistik di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: regresi logistik di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Gunakan langkah-langkah berikut untuk melakukan regresi logistik di Excel untuk kumpulan data yang menunjukkan apakah pemain bola basket perguruan tinggi direkrut ke NBA atau tidak (draft: 0 = tidak, 1 = ya) berdasarkan IPK mereka. poin, rebound, dan assist di masa lalu. musim.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7270 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logistiqueexcel1.png\" alt=\"Data mentah di Excel\" width=\"445\" height=\"454\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan sel untuk koefisien regresi.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena kita memiliki tiga variabel penjelas dalam model (pts, rebs, ast), kita akan membuat sel untuk tiga koefisien regresi ditambah satu untuk titik asal dalam model. Kami akan menetapkan nilai untuk masing-masingnya menjadi 0,001, tetapi kami akan mengoptimalkannya nanti.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7271 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logistiqueexcel2.png\" alt=\"Regresi Logistik di Excel\" width=\"420\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu membuat beberapa kolom baru yang akan kita gunakan untuk mengoptimalkan koefisien regresi ini, termasuk logit, e <sup>logit<\/sup> , probabilitas, dan kemungkinan log.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Buat nilai untuk logit.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat kolom logit menggunakan rumus berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7272 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logistiqueexcel3.png\" alt=\"Persamaan Regresi Logistik di Excel\" width=\"583\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Buat nilai untuk e <sup>logit<\/sup> .<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat nilai e <sup>logit<\/sup> menggunakan rumus berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-7273 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logistiqueexcel4.png\" alt=\"Perhitungan regresi logistik di Excel\" width=\"463\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 5: Buat Nilai Probabilitas.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat nilai probabilitas menggunakan rumus berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34053 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logexcel1.jpg\" alt=\"\" width=\"657\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 6: Buat nilai untuk kemungkinan log.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan membuat nilai kemungkinan log menggunakan rumus berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Log kemungkinan = LN (Probabilitas)<\/strong><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34055 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logexcel2-1.jpg\" alt=\"\" width=\"636\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 7: Temukan jumlah probabilitas log.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kita akan mencari jumlah log-likelihood, yaitu angka yang akan kita coba maksimalkan untuk menyelesaikan koefisien regresi.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34056 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logexcel3.jpg\" alt=\"\" width=\"658\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 8: Gunakan solver untuk menyelesaikan koefisien regresi.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda belum menginstal pemecah di Excel, ikuti langkah-langkah berikut untuk melakukannya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Klik <strong>Mengajukan<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik <strong>Opsi<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik <strong>Add-in<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Klik <strong>Add-in Solver<\/strong> , lalu klik <strong>Buka<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Di jendela baru yang muncul, centang kotak di samping <strong>Solver Add-In<\/strong> , lalu klik <strong>Go<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Setelah solver diinstal, buka grup <strong>Analisis<\/strong> pada tab <strong>Data<\/strong> dan klik <strong>Solver<\/strong> . Masukkan informasi berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Tetapkan tujuan:<\/strong> Pilih sel H14 yang berisi jumlah probabilitas log.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Dengan memodifikasi sel variabel:<\/strong> pilih rentang sel B15:B18 yang berisi koefisien regresi.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Jadikan variabel yang tidak dibatasi menjadi non-negatif:<\/strong> hapus centang pada kotak ini.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Pilih metode solusi:<\/strong> pilih GRG nonlinier.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Lalu klik <strong>Selesaikan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Solver secara otomatis menghitung perkiraan koefisien regresi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34057 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logexcel4.jpg\" alt=\"\" width=\"601\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Secara default, koefisien regresi dapat digunakan untuk mencari probabilitas proyek = 0.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, secara umum dalam regresi logistik kita tertarik pada probabilitas bahwa variabel respon = 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, kita cukup membalik tanda pada masing-masing koefisien regresi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-34058\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logexcel5.jpg\" alt=\"regresi logistik di Excel\" width=\"641\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koefisien regresi ini sekarang dapat digunakan untuk mencari probabilitas proyek = 1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, seorang pemain rata-rata mencetak 14 poin per game, 4 rebound per game, dan 5 assist per game. Probabilitas pemain ini untuk masuk ke NBA dapat dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">P(proyek = 1) = e <sup>3,681193 + 0,112827*(14) -0,39568*(4) \u2013 0,67954*(5)<\/sup> \/ (1+e <sup>3,681193 + 0,112827*(14 ) -0,39568*(4) \u2013 0,67954*(5 )<\/sup> ) = <strong>0,57<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena probabilitas ini lebih besar dari 0,5, kami memperkirakan pemain ini <em>&nbsp;<\/em> sedang direkrut ke NBA.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong><\/span> <a href=\"https:\/\/statorials.org\/id\/kurva-batuan-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Kurva KOP di Excel (Langkah demi Langkah)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Regresi logistik adalah metode yang kami gunakan untuk menyesuaikan model regresi ketika variabel responsnya adalah biner. Tutorial ini menjelaskan cara melakukan regresi logistik di Excel. Contoh: regresi logistik di Excel Gunakan langkah-langkah berikut untuk melakukan regresi logistik di Excel untuk kumpulan data yang menunjukkan apakah pemain bola basket perguruan tinggi direkrut ke NBA atau tidak [&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 Logistik di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara melakukan regresi logistik di Excel, termasuk 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-logistik-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Regresi Logistik di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara melakukan regresi logistik di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T23:42:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logistiqueexcel1.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-logistik-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/\",\"name\":\"Cara Melakukan Regresi Logistik di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T23:42:23+00:00\",\"dateModified\":\"2023-07-28T23:42:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara melakukan regresi logistik di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan regresi logistik 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 Melakukan Regresi Logistik di Excel - Statologi","description":"Penjelasan sederhana tentang cara melakukan regresi logistik di Excel, termasuk 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-logistik-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Regresi Logistik di Excel - Statologi","og_description":"Penjelasan sederhana tentang cara melakukan regresi logistik di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T23:42:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/logistiqueexcel1.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-logistik-unggul\/","url":"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/","name":"Cara Melakukan Regresi Logistik di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T23:42:23+00:00","dateModified":"2023-07-28T23:42:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara melakukan regresi logistik di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/regresi-logistik-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/regresi-logistik-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan regresi logistik 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\/723"}],"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=723"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/723\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}