{"id":1645,"date":"2023-07-25T13:13:44","date_gmt":"2023-07-25T13:13:44","guid":{"rendered":"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/"},"modified":"2023-07-25T13:13:44","modified_gmt":"2023-07-25T13:13:44","slug":"tes-parsial-f-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/","title":{"rendered":"Cara melakukan tes f parsial di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/uji-f-parsial\/\" target=\"_blank\" rel=\"noopener\">Uji F parsial<\/a> digunakan untuk menentukan ada atau tidaknya perbedaan yang signifikan secara statistik antara <a href=\"https:\/\/statorials.org\/id\/regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener noreferrer\">model regresi<\/a> dan versi tersarang dari model yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Model <em>bersarang<\/em> hanyalah model yang berisi subkumpulan variabel prediktor dalam model regresi keseluruhan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita memiliki model regresi berikut dengan empat variabel prediktor:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Y = \u03b2 <sub>0<\/sub> + \u03b2 <sub>1<\/sub> x <sub>1<\/sub> + \u03b2 <sub>2<\/sub> x <sub>2<\/sub> + \u03b2 <sub>3<\/sub> x <sub>3<\/sub> + \u03b2 <sub>4<\/sub> x <sub>4<\/sub> + \u03b5<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh model bertingkat adalah model berikut yang hanya memiliki dua variabel prediktor asli:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Y = \u03b2 <sub>0<\/sub> + \u03b2 <sub>1<\/sub> x <sub>1<\/sub> + \u03b2 <sub>2<\/sub> x <sub>2<\/sub> + \u03b5<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengetahui apakah kedua model ini berbeda secara signifikan, kita dapat melakukan uji F parsial, yang menghitung statistik uji F berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\">F = (( RSS <sub>yang Dikurangi<\/sub> \u2013 RSS <sub>Penuh<\/sub> )\/p) \/ ( RSS <sub>Penuh<\/sub> \/nk)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>RSS <sub>yang Dikurangi<\/sub><\/strong> : Jumlah sisa kuadrat dari model yang dikurangi (yaitu \u201cbersarang\u201d).<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>RSS <sub>penuh<\/sub><\/strong> : Jumlah sisa kuadrat dari model lengkap.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>p :<\/strong> jumlah prediktor yang dihapus dari model lengkap.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n:<\/strong> jumlah total observasi dalam kumpulan data.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>k :<\/strong> Jumlah koefisien (termasuk intersep) dalam model lengkap.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Pengujian ini menggunakan hipotesis nol dan <a href=\"https:\/\/statorials.org\/id\/pengujian-hipotesis-1\/\" target=\"_blank\" rel=\"noopener\">hipotesis<\/a> alternatif berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub> :<\/strong> Semua koefisien yang dihilangkan dari model penuh adalah nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>H <sub>A<\/sub> :<\/strong> Setidaknya salah satu koefisien yang dikeluarkan dari model lengkap adalah bukan nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> yang sesuai dengan statistik uji F berada di bawah tingkat signifikansi tertentu (misalnya 0,05), maka kita dapat menolak hipotesis nol dan menyimpulkan bahwa setidaknya salah satu koefisien yang dikeluarkan dari model lengkap adalah signifikan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara melakukan uji F parsial di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: uji F parsial di Excel<\/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=\" wp-image-16218 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/partielfexcel1.png\" alt=\"\" width=\"414\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengetahui apakah terdapat perbedaan antara dua model regresi berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Model lengkap:<\/strong> y = \u03b2 <sub>0<\/sub> + \u03b2 <sub>1<\/sub> x <sub>1<\/sub> + \u03b2 <sub>2<\/sub> x <sub>2<\/sub> + \u03b2 <sub>3<\/sub> x <sub>3<\/sub> + \u03b2 <sub>4<\/sub> x <sub>4<\/sub><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Model tereduksi:<\/strong> y = \u03b2 <sub>0<\/sub> + \u03b2 <sub>1<\/sub> x <sub>1<\/sub> + \u03b2 <sub>2<\/sub> x <sub>2<\/sub><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melakukan <a href=\"https:\/\/statorials.org\/id\/excel-regresi-linier-berganda\/\" target=\"_blank\" rel=\"noopener\">regresi linier berganda di Excel<\/a> untuk setiap model untuk mendapatkan hasil sebagai berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16219 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/partielfexcel2.png\" alt=\"\" width=\"510\" height=\"650\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan rumus berikut untuk menghitung statistik uji F untuk uji F parsial:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16220 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/partielfexcel3.png\" alt=\"\" width=\"676\" height=\"419\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Statistik pengujiannya ternyata <strong>2.064<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan rumus berikut untuk menghitung nilai p yang sesuai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16221 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/partielfexcel4.png\" alt=\"\" width=\"663\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Nilai pnya ternyata <strong>0,1974<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena nilai p ini tidak kurang dari 0,05, kita akan gagal menolak hipotesis nol. Artinya kita tidak mempunyai cukup bukti untuk menyatakan bahwa salah satu variabel prediktor <em>x3<\/em> atau <em>x4<\/em> signifikan secara statistik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, menambahkan <em>x3<\/em> dan <em>x4<\/em> ke model regresi tidak meningkatkan kecocokan model secara signifikan.<\/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\/kesalahan-standar-regresi-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Standard Error Regresi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uji F parsial digunakan untuk menentukan ada atau tidaknya perbedaan yang signifikan secara statistik antara model regresi dan versi tersarang dari model yang sama. Model bersarang hanyalah model yang berisi subkumpulan variabel prediktor dalam model regresi keseluruhan. Misalnya, kita memiliki model regresi berikut dengan empat variabel prediktor: Y = \u03b2 0 + \u03b2 1 x [&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 Melakukan Tes F Parsial di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan uji F parsial 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\/tes-parsial-f-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Tes F Parsial di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan uji F parsial di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T13:13:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/partielfexcel1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/\",\"name\":\"Cara Melakukan Tes F Parsial di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T13:13:44+00:00\",\"dateModified\":\"2023-07-25T13:13:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan uji F parsial di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan tes f parsial 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 Melakukan Tes F Parsial di Excel - Statorials","description":"Tutorial ini menjelaskan cara melakukan uji F parsial 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\/tes-parsial-f-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Tes F Parsial di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan uji F parsial di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T13:13:44+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/partielfexcel1.png"}],"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\/tes-parsial-f-excel\/","url":"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/","name":"Cara Melakukan Tes F Parsial di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T13:13:44+00:00","dateModified":"2023-07-25T13:13:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan uji F parsial di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tes-parsial-f-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tes-parsial-f-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan tes f parsial 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\/1645"}],"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=1645"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1645\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}