{"id":1470,"date":"2023-07-26T06:31:43","date_gmt":"2023-07-26T06:31:43","guid":{"rendered":"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/"},"modified":"2023-07-26T06:31:43","modified_gmt":"2023-07-26T06:31:43","slug":"sst-ssr-sse-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/","title":{"rendered":"Cara menghitung sst, ssr dan sse di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Kita sering menggunakan tiga <a href=\"https:\/\/statorials.org\/id\/sst-ssr-sse\/\" target=\"_blank\" rel=\"noopener\">jumlah nilai kuadrat<\/a> yang berbeda untuk mengukur seberapa cocok <a href=\"https:\/\/statorials.org\/id\/regresi-linier-1\/\" target=\"_blank\" rel=\"noopener\">garis regresi<\/a> dengan kumpulan data:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. Jumlah Kuadrat Total (SST) \u2013<\/strong> Jumlah kuadrat selisih antara masing-masing titik data ( <sub>yi<\/sub> ) dan rata-rata variabel respons ( <span style=\"border-top: 1px solid black;\">y<\/span> ).<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">SST = \u03a3( <sub>kamu<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">kamu<\/span> ) <sup>2<\/sup><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>2. Regresi Jumlah Kuadrat (SSR)<\/strong> \u2013 Jumlah kuadrat selisih antara titik data prediksi (\u0177 <sub>i<\/sub> ) dan rata-rata variabel respons ( <span style=\"border-top: 1px solid black;\">y<\/span> ).<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">SSR = \u03a3(\u0177 <sub>saya<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">kamu<\/span> ) <sup>2<\/sup><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>3. Sum of Squares Error (SSE)<\/strong> \u2013 Jumlah kuadrat selisih antara titik data prediksi (\u0177 <sub>i<\/sub> ) dan titik data observasi (y <sub>i<\/sub> ).<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">SSE = \u03a3(\u0177 <sub>saya<\/sub> \u2013 y <sub>saya<\/sub> ) <sup>2<\/sup><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut memperlihatkan cara menghitung masing-masing metrik ini untuk model regresi tertentu di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita buat kumpulan data yang berisi jumlah jam belajar dan nilai ujian yang diperoleh untuk 20 siswa berbeda di sekolah tertentu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14559 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommecarreexcel1.png\" alt=\"\" width=\"470\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Sesuaikan model regresi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Di pita atas Excel, klik tab <strong>Data<\/strong> dan klik <strong>Analisis Data<\/strong> . Jika Anda tidak melihat opsi ini, Anda harus <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">menginstal perangkat lunak Analysis ToolPak gratis<\/a> terlebih dahulu.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/deuxsampexcel3.png\" alt=\"Opsi Analisis Data di Excel\" width=\"522\" height=\"199\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>Analisis Data,<\/strong> jendela baru akan muncul. Pilih <strong>Regresi<\/strong> dan klik OK.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, berikan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14560 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommecarreexcel2.png\" alt=\"\" width=\"520\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , keluaran regresi akan muncul.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14561 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommecarreexcel3.png\" alt=\"\" width=\"458\" height=\"415\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Analisis hasilnya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tiga jumlah metrik kuadrat \u2013 SST, SSR dan SSE \u2013 dapat dilihat pada kolom <strong>SS<\/strong> pada tabel <strong>ANOVA<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-14562 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommecarreexcel4.png\" alt=\"SST, SSR dan SSE di Excel\" width=\"428\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Metriknya ternyata adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Jumlah total kuadrat (SST):<\/strong> 1248,55<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Regresi Jumlah Kuadrat (SSR):<\/strong> 917.4751<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kesalahan jumlah kuadrat (SSE):<\/strong> 331.0749<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kami dapat memverifikasi bahwa SST = SSR + SSE:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">SST = SSR + SSE<\/span><\/li>\n<li> <span style=\"color: #000000;\">1248,55 = 917,4751 + 331,0749<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita juga dapat menghitung <a href=\"https:\/\/statorials.org\/id\/nilai-r-kuadrat-yang-bagus\/\" target=\"_blank\" rel=\"noopener\">R kuadrat<\/a> model regresi secara manual:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">R kuadrat = SSR \/ SST<\/span><\/li>\n<li> <span style=\"color: #000000;\">R kuadrat = 917,4751 \/ 1248,55<\/span><\/li>\n<li> <span style=\"color: #000000;\">R kuadrat = 0,7348<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Hal ini menunjukkan bahwa <strong>73,48%<\/strong> variasi nilai ujian dapat dijelaskan oleh jumlah jam belajar.<\/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 \/> <a href=\"https:\/\/statorials.org\/id\/regresi-polinomial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Polinomial di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/regresi-eksponensial-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Regresi Eksponensial di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kita sering menggunakan tiga jumlah nilai kuadrat yang berbeda untuk mengukur seberapa cocok garis regresi dengan kumpulan data: 1. Jumlah Kuadrat Total (SST) \u2013 Jumlah kuadrat selisih antara masing-masing titik data ( yi ) dan rata-rata variabel respons ( y ). SST = \u03a3( kamu \u2013 kamu ) 2 2. Regresi Jumlah Kuadrat (SSR) \u2013 [&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 SST, SSR dan SSE di Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung SST, SSR dan SSE untuk model regresi tertentu 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\/sst-ssr-sse-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 SST, SSR dan SSE di Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung SST, SSR dan SSE untuk model regresi tertentu di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T06:31:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommecarreexcel1.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\/sst-ssr-sse-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/\",\"name\":\"Cara menghitung SST, SSR dan SSE di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T06:31:43+00:00\",\"dateModified\":\"2023-07-26T06:31:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung SST, SSR dan SSE untuk model regresi tertentu di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung sst, ssr dan sse 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 SST, SSR dan SSE di Excel","description":"Tutorial ini menjelaskan cara menghitung SST, SSR dan SSE untuk model regresi tertentu 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\/sst-ssr-sse-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung SST, SSR dan SSE di Excel","og_description":"Tutorial ini menjelaskan cara menghitung SST, SSR dan SSE untuk model regresi tertentu di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T06:31:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sommecarreexcel1.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\/sst-ssr-sse-di-excel\/","url":"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/","name":"Cara menghitung SST, SSR dan SSE di Excel","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T06:31:43+00:00","dateModified":"2023-07-26T06:31:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung SST, SSR dan SSE untuk model regresi tertentu di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/sst-ssr-sse-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung sst, ssr dan sse 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\/1470"}],"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=1470"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1470\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}