{"id":4611,"date":"2023-07-09T15:51:23","date_gmt":"2023-07-09T15:51:23","guid":{"rendered":"https:\/\/statorials.org\/id\/keluaran-baris-excel\/"},"modified":"2023-07-09T15:51:23","modified_gmt":"2023-07-09T15:51:23","slug":"keluaran-baris-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/keluaran-baris-excel\/","title":{"rendered":"Excel: cara menginterpretasikan output dari fungsi linest"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>LINEST<\/strong> untuk menyesuaikan model regresi di Excel.<\/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(known_y's, known_x's, const, stats)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>unknown_y&#8217;s<\/strong> : kolom nilai untuk variabel respon<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>unknown_x&#8217;s<\/strong> : satu atau lebih kolom nilai untuk variabel prediktor<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>const<\/strong> : TRUE = hitung intersepsi secara normal, FALSE = paksa intersepsi ke nol<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>stats<\/strong> : TRUE = menghitung statistik regresi tambahan, FALSE = menghitung koefisien saja<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana menafsirkan keluaran fungsi <strong>LINEST<\/strong> dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menginterpretasikan keluaran LINEST di Excel<\/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 bisa mengetikkan rumus berikut di sel <strong>D1<\/strong> untuk melakukan regresi linier sederhana dengan kumpulan data ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=LINEST( <span style=\"color: #3366ff;\">A2:A15<\/span> , <span style=\"color: #ff0000;\">B2:B15<\/span> , TRUE, TRUE)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Output dari fungsi <strong>LINEST<\/strong> berisi koefisien model regresi serta beberapa statistik tambahan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35987 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne2.png\" alt=\"\" width=\"485\" height=\"430\" 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=\"aligncenter wp-image-35988\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ligne3.png\" alt=\"Keluaran LINEST Excel\" width=\"475\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/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;\">Kita juga dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai R-squared model adalah <strong>0,888<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hal ini kami artikan bahwa variabel prediktor mampu menjelaskan <strong>88,8%<\/strong> variasi variabel respon model.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/nilai-r-kuadrat-yang-bagus\/\" target=\"_blank\" rel=\"noopener\">Berapa nilai R-kuadrat yang bagus?<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut memberikan informasi tambahan tentang regresi di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/nilai-p-regresi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menginterpretasikan nilai P dalam keluaran regresi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-garis-regresi-ke-scatterplot-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan garis regresi ke scatterplot 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>Anda dapat menggunakan fungsi LINEST untuk menyesuaikan model regresi di Excel. Fungsi ini menggunakan sintaks dasar berikut: LINEST(known_y&#8217;s, known_x&#8217;s, const, stats) Emas: unknown_y&#8217;s : kolom nilai untuk variabel respon unknown_x&#8217;s : satu atau lebih kolom nilai untuk variabel prediktor const : TRUE = hitung intersepsi secara normal, FALSE = paksa intersepsi ke nol stats : [&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>Excel: Cara menginterpretasikan keluaran fungsi LINEST - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menginterpretasikan output fungsi LINEST di Excel, dengan sebuah contoh.\" \/>\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\/keluaran-baris-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menginterpretasikan keluaran fungsi LINEST - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menginterpretasikan output fungsi LINEST di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/keluaran-baris-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T15:51:23+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\/keluaran-baris-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/keluaran-baris-excel\/\",\"name\":\"Excel: Cara menginterpretasikan keluaran fungsi LINEST - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-09T15:51:23+00:00\",\"dateModified\":\"2023-07-09T15:51:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menginterpretasikan output fungsi LINEST di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/keluaran-baris-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/keluaran-baris-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/keluaran-baris-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menginterpretasikan output dari fungsi linest\"}]},{\"@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":"Excel: Cara menginterpretasikan keluaran fungsi LINEST - Statorials","description":"Tutorial ini menjelaskan cara menginterpretasikan output fungsi LINEST di Excel, dengan sebuah contoh.","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\/keluaran-baris-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menginterpretasikan keluaran fungsi LINEST - Statorials","og_description":"Tutorial ini menjelaskan cara menginterpretasikan output fungsi LINEST di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/keluaran-baris-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-09T15:51:23+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\/keluaran-baris-excel\/","url":"https:\/\/statorials.org\/id\/keluaran-baris-excel\/","name":"Excel: Cara menginterpretasikan keluaran fungsi LINEST - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-09T15:51:23+00:00","dateModified":"2023-07-09T15:51:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menginterpretasikan output fungsi LINEST di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/keluaran-baris-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/keluaran-baris-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/keluaran-baris-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menginterpretasikan output dari fungsi linest"}]},{"@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\/4611"}],"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=4611"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4611\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}