{"id":2783,"date":"2023-07-20T17:37:37","date_gmt":"2023-07-20T17:37:37","guid":{"rendered":"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/"},"modified":"2023-07-20T17:37:37","modified_gmt":"2023-07-20T17:37:37","slug":"sisa-jejak-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/","title":{"rendered":"Cara membuat plot sisa di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Plot sisa<\/strong> adalah jenis plot yang menampilkan nilai yang disesuaikan dengan sisa untuk model regresi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jenis plot ini sering digunakan untuk mengevaluasi apakah model regresi linier sesuai atau tidak untuk kumpulan data tertentu dan untuk memeriksa residu untuk <a href=\"https:\/\/statorials.org\/id\/regresi-heteroskedastisitas\/\" target=\"_blank\" rel=\"noopener\">heteroskedastisitas<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara membuat plot sisa untuk model regresi linier sederhana di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai berikut untuk kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24432 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle1.jpg\" alt=\"\" width=\"447\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung persamaan model regresi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>SLOPE<\/strong> dan <strong>INTERCEPT<\/strong> untuk menghitung persamaan model regresi linier sederhana untuk dataset ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24433 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle2.jpg\" alt=\"\" width=\"478\" height=\"435\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan nilai-nilai ini, kita dapat menulis persamaan regresi linier sederhana berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">kamu = 29,631 + 0,755x<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai prediksi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kemudian kita dapat menggunakan persamaan regresi untuk menghitung nilai prediksi setiap observasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami akan mengetikkan rumus berikut di sel <strong>C2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">$B$16<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">+<\/span> <span dir=\"auto\" style=\"color: #800080;\">$B$15<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">*<\/span> <span dir=\"auto\" style=\"color: #3366ff;\">A2\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom <strong>C<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24434 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle3.jpg\" alt=\"\" width=\"471\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Hitung residu<\/strong><\/span><\/h3>\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;\"><strong>Sisa = Nilai yang diamati \u2013 Nilai yang diprediksi<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghitung sisa tiap observasi pada dataset kita, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">-<\/span> <span dir=\"auto\" style=\"color: #800080;\">C2<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menyalin dan menempelkan rumus ini ke setiap sel yang tersisa di kolom <strong>D<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24435 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle4.jpg\" alt=\"\" width=\"546\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 5: Buat plot sisa<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk membuat plot sisa, kita dapat menyorot nilai dalam rentang <strong>A2:A13<\/strong> , lalu tahan tombol &#8220;Ctrl&#8221; dan sorot nilai dalam rentang <strong>D2:D13<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24436 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle5.jpg\" alt=\"\" width=\"512\" height=\"464\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Lalu klik tab <strong>Sisipkan<\/strong> , lalu klik <strong>Bagan<\/strong> di menu tarik-turun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di panel <strong>Chart Editor<\/strong> yang muncul di sisi kanan layar, pilih <strong>Scatter Plot<\/strong> sebagai tipe grafik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24437 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle6.jpg\" alt=\"\" width=\"279\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Plot sisa berikut akan otomatis muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-24438\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle7.jpg\" alt=\"plot sisa Google Spreadsheet\" width=\"572\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sumbu x menampilkan nilai variabel prediktor dalam model regresi kita dan sumbu y menampilkan residu.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/asumsi-regresi-linier\/\" target=\"_blank\" rel=\"noopener\">Asumsi utama<\/a> regresi linier adalah bahwa residu memiliki varian konstan pada setiap tingkat x, sehingga kita sering menggunakan plot residu untuk menentukan apakah asumsi ini terpenuhi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika residu kira-kira terdistribusi secara merata di sekitar nol pada grafik tanpa tren yang jelas, maka secara umum asumsi varians konstan terpenuhi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada plot residu di atas, kita dapat melihat bahwa titik-titik dalam plot tersebut tampak tersebar secara acak di sekitar nol tanpa pola yang jelas. Oleh karena itu kami menyimpulkan bahwa asumsi varians konstan terpenuhi untuk model regresi khusus ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/regresi-linier-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi linier di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-regresi-polinomial\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan regresi polinomial di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Plot sisa adalah jenis plot yang menampilkan nilai yang disesuaikan dengan sisa untuk model regresi. Jenis plot ini sering digunakan untuk mengevaluasi apakah model regresi linier sesuai atau tidak untuk kumpulan data tertentu dan untuk memeriksa residu untuk heteroskedastisitas . Contoh langkah demi langkah berikut menunjukkan cara membuat plot sisa untuk model regresi linier sederhana [&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 Membuat Plot Sisa di Google Sheets \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat plot sisa di Google Spreadsheet, 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\/sisa-jejak-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Plot Sisa di Google Sheets \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat plot sisa di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T17:37:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle1.jpg\" \/>\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\/sisa-jejak-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/\",\"name\":\"Cara Membuat Plot Sisa di Google Sheets \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T17:37:37+00:00\",\"dateModified\":\"2023-07-20T17:37:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat plot sisa di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat plot sisa di google sheets\"}]},{\"@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 Membuat Plot Sisa di Google Sheets \u2013 Statorial","description":"Tutorial ini menjelaskan cara membuat plot sisa di Google Spreadsheet, 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\/sisa-jejak-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Plot Sisa di Google Sheets \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara membuat plot sisa di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-20T17:37:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/residentgoogle1.jpg"}],"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\/sisa-jejak-google-sheet\/","url":"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/","name":"Cara Membuat Plot Sisa di Google Sheets \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T17:37:37+00:00","dateModified":"2023-07-20T17:37:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat plot sisa di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sisa-jejak-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat plot sisa di google sheets"}]},{"@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\/2783"}],"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=2783"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2783\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}