{"id":4777,"date":"2023-07-08T01:38:48","date_gmt":"2023-07-08T01:38:48","guid":{"rendered":"https:\/\/statorials.org\/id\/fungsi-baris-vba\/"},"modified":"2023-07-08T01:38:48","modified_gmt":"2023-07-08T01:38:48","slug":"fungsi-baris-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/fungsi-baris-vba\/","title":{"rendered":"Cara menggunakan fungsi linest di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode <b>LinEst<\/b> di VBA agar sesuai dengan model regresi linier.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>LinEst(Arg1, Arg2, Arg3, Arg4)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Arg1<\/strong> : Kumpulan nilai y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Arg2<\/strong> : Kumpulan nilai x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Arg3 (opsional)<\/strong> : TRUE = menghitung intersepsi secara normal, FALSE = memaksa intersepsi ke nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Arg4 (opsional)<\/strong> : TRUE = menghitung statistik regresi tambahan, FALSE = menghitung koefisien saja<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan metode <strong>LinEst<\/strong> agar sesuai dengan model regresi di VBA.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: cara menggunakan fungsi LinEst di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang berisi variabel prediktor (x) dan variabel respon (y):<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35986 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne1-1.png\" alt=\"\" width=\"482\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut yang menggunakan metode <strong>LinEst<\/strong> agar sesuai dengan model regresi linier sederhana ke kumpulan data ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> UseLinEst()\nRange(\" <span style=\"color: #ff0000;\">D1:E1<\/span> \") = WorksheetFunction.LinEst(Range(\" <span style=\"color: #ff0000;\">B2:B15<\/span> \"), Range(\" <span style=\"color: #ff0000;\">A2:A15<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignestvba1.png\" alt=\"\" width=\"482\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai hasil mewakili koefisien model regresi:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Koefisien untuk \u03b2 <sub>0<\/sub> adalah <strong>3,52169<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Koefisien untuk <sub>\u03b21<\/sub> adalah <strong>0,693717<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dengan menggunakan nilai-nilai ini, kita dapat menulis persamaan untuk model regresi sederhana ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>kamu = 3,52169 + 0,693717(x)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami menafsirkan hal ini berarti bahwa setiap kenaikan satu unit tambahan pada variabel prediktor x dikaitkan dengan peningkatan rata-rata sebesar <strong>0,693717<\/strong> pada variabel respons y.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita mengartikan istilah aslinya bahwa ketika x sama dengan nol, nilai rata-rata y adalah <strong>3,52169<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita ingin menggunakan metode <strong>LinEst<\/strong> untuk menghasilkan statistik regresi tambahan, kita dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> UseLinEst()\nRange(\" <span style=\"color: #ff0000;\">D1:E5<\/span> \") = WorksheetFunction.LinEst(Range(\" <span style=\"color: #ff0000;\">B2:B15<\/span> \"), Range(\" <span style=\"color: #ff0000;\">A2:A15<\/span> \"), True, True)\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37298 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/lignestvba2.png\" alt=\"\" width=\"507\" height=\"431\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memberikan penjelasan setiap nilai pada hasilnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35988 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne3.png\" alt=\"\" width=\"531\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan memberikan <strong>True<\/strong> pada argumen terakhir metode <strong>LinEst<\/strong> , kita dapat menghitung beberapa statistik regresi tambahan.<\/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 VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/klasifikasi-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengklasifikasikan daftar nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/deviasi-standar-vba-dari-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung deviasi standar rentang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-rata-rata-tertimbang\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung rata-rata tertimbang<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode LinEst di VBA agar sesuai dengan model regresi linier. Fungsi ini menggunakan sintaks dasar berikut: LinEst(Arg1, Arg2, Arg3, Arg4) Emas: Arg1 : Kumpulan nilai y Arg2 : Kumpulan nilai x Arg3 (opsional) : TRUE = menghitung intersepsi secara normal, FALSE = memaksa intersepsi ke nol Arg4 (opsional) : TRUE = menghitung [&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 menggunakan fungsi LinEst di VBA (dengan contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi LINEST di VBA agar sesuai dengan model regresi, 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\/fungsi-baris-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan fungsi LinEst di VBA (dengan contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi LINEST di VBA agar sesuai dengan model regresi, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/fungsi-baris-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T01:38:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne1-1.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\/fungsi-baris-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/fungsi-baris-vba\/\",\"name\":\"Cara menggunakan fungsi LinEst di VBA (dengan contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T01:38:48+00:00\",\"dateModified\":\"2023-07-08T01:38:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi LINEST di VBA agar sesuai dengan model regresi, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/fungsi-baris-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/fungsi-baris-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/fungsi-baris-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi linest di vba (dengan contoh)\"}]},{\"@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 menggunakan fungsi LinEst di VBA (dengan contoh) - Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi LINEST di VBA agar sesuai dengan model regresi, 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\/fungsi-baris-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan fungsi LinEst di VBA (dengan contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi LINEST di VBA agar sesuai dengan model regresi, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/fungsi-baris-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-08T01:38:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne1-1.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\/fungsi-baris-vba\/","url":"https:\/\/statorials.org\/id\/fungsi-baris-vba\/","name":"Cara menggunakan fungsi LinEst di VBA (dengan contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T01:38:48+00:00","dateModified":"2023-07-08T01:38:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi LINEST di VBA agar sesuai dengan model regresi, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/fungsi-baris-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/fungsi-baris-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/fungsi-baris-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi linest di vba (dengan contoh)"}]},{"@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\/4777"}],"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=4777"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4777\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}