{"id":1337,"date":"2023-07-26T20:02:37","date_gmt":"2023-07-26T20:02:37","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/"},"modified":"2023-07-26T20:02:37","modified_gmt":"2023-07-26T20:02:37","slug":"jumlah-sisa-kuadrat-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/","title":{"rendered":"Cara menghitung jumlah sisa kuadrat di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/residu\/\" target=\"_blank\" rel=\"noopener\">Residual<\/a> adalah selisih antara nilai observasi dan nilai prediksi dalam model regresi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sisa = Nilai yang diamati \u2013 Nilai yang diprediksi<\/span><\/p>\n<p> <span style=\"color: #000000;\">Salah satu cara untuk memahami seberapa cocok model regresi dengan kumpulan data adalah dengan menghitung <strong>jumlah sisa kuadrat<\/strong> , yang dihitung sebagai berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jumlah sisa kuadrat = \u03a3( <sub>ei<\/sub> ) <sup>2<\/sup><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3<\/strong> : Simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>e <sub>i<\/sub><\/strong> : Residu <sup>ke<\/sup> -i<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Semakin rendah nilainya, semakin baik model tersebut cocok dengan kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh penghitungan jumlah sisa kuadrat untuk model regresi linier sederhana dan model regresi linier berganda di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Jumlah sisa kuadrat untuk regresi linier sederhana<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13053 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rssexcel2.png\" alt=\"\" width=\"421\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung jumlah sisa kuadrat pada model regresi linier sederhana yang menggunakan x sebagai variabel prediktor dan y sebagai variabel respon, kita dapat menggunakan fungsi <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/linest-function-84d7d0d9-6e50-4101-977a-fa7abf772b6d\" target=\"_blank\" rel=\"noopener\">LINEST()<\/a> yang menggunakan sintaksis berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>LINEST(diketahui_ys, [diketahui_xs], [const], [statistik])<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>unknown_ys:<\/strong> rentang nilai y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>unknown_sx:<\/strong> kisaran nilai x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>const:<\/strong> apakah akan memaksa konstanta b menjadi nol. Kami akan membiarkan bidang ini kosong.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>statistik:<\/strong> Daftar statistik regresi. Kami akan mengklarifikasi bahwa ini BENAR.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13052 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rssexcel1.png\" alt=\"Jumlah sisa kuadrat di Excel\" width=\"574\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah sisa kuadrat dari model regresi ditampilkan di sel terakhir kolom kedua keluaran. Dalam contoh ini, jumlah sisa kuadratnya adalah <strong>50,75<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Jumlah sisa kuadrat untuk regresi linier berganda<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13054 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rssexcel3.png\" alt=\"\" width=\"452\" height=\"522\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sekali lagi, kita dapat menggunakan fungsi LINEST() untuk menghitung jumlah sisa kuadrat model.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya perbedaan adalah kita akan menentukan dua kolom nilai untuk argumen <strong>unknown_xs<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-13055 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rssexcel4.png\" alt=\"Contoh penghitungan jumlah sisa kuadrat di Excel\" width=\"656\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jumlah sisa kuadrat untuk model regresi linier berganda ini adalah <strong>49,83<\/strong> .<\/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 \/> Kalkulator Jumlah Sisa Kuadrat<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Residual adalah selisih antara nilai observasi dan nilai prediksi dalam model regresi. Ini dihitung sebagai berikut: Sisa = Nilai yang diamati \u2013 Nilai yang diprediksi Salah satu cara untuk memahami seberapa cocok model regresi dengan kumpulan data adalah dengan menghitung jumlah sisa kuadrat , yang dihitung sebagai berikut: Jumlah sisa kuadrat = \u03a3( ei ) [&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 Menghitung Jumlah Sisa Kuadrat di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah sisa kuadrat 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\/jumlah-sisa-kuadrat-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Jumlah Sisa Kuadrat di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah sisa kuadrat di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T20:02:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rssexcel2.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\/jumlah-sisa-kuadrat-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/\",\"name\":\"Cara Menghitung Jumlah Sisa Kuadrat di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T20:02:37+00:00\",\"dateModified\":\"2023-07-26T20:02:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah sisa kuadrat di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung jumlah sisa kuadrat 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 Menghitung Jumlah Sisa Kuadrat di Excel","description":"Tutorial ini menjelaskan cara menghitung jumlah sisa kuadrat 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\/jumlah-sisa-kuadrat-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Jumlah Sisa Kuadrat di Excel","og_description":"Tutorial ini menjelaskan cara menghitung jumlah sisa kuadrat di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T20:02:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rssexcel2.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\/jumlah-sisa-kuadrat-di-excel\/","url":"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/","name":"Cara Menghitung Jumlah Sisa Kuadrat di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T20:02:37+00:00","dateModified":"2023-07-26T20:02:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah sisa kuadrat di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-sisa-kuadrat-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung jumlah sisa kuadrat 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\/1337"}],"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=1337"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1337\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}