{"id":787,"date":"2023-07-28T18:28:57","date_gmt":"2023-07-28T18:28:57","guid":{"rendered":"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/"},"modified":"2023-07-28T18:28:57","modified_gmt":"2023-07-28T18:28:57","slug":"korelasi-parsial-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/","title":{"rendered":"Cara menghitung korelasi parsial di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, kita sering menggunakan<\/span> <a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-pearson-1\/\" target=\"_blank\" rel=\"noopener\">koefisien korelasi Pearson<\/a> <span style=\"color: #000000;\">untuk mengukur hubungan linier antara dua variabel. Namun, terkadang kita ingin memahami hubungan antara dua variabel <strong>sambil mengendalikan variabel ketiga<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita ingin mengukur hubungan antara jumlah jam belajar siswa dan nilai ujian akhir, sambil mengontrol nilai siswa saat ini di kelas. Dalam hal ini, kita dapat menggunakan <strong>korelasi parsial<\/strong> untuk mengukur hubungan antara jam belajar dan nilai ujian akhir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menghitung korelasi parsial di Excel.<\/span><\/p>\n<h3> <strong>Contoh: korelasi parsial di Excel<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data yang menampilkan informasi berikut untuk 10 siswa:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai saat ini di kelas<\/span><\/li>\n<li> <span style=\"color: #000000;\">Berjam-jam dihabiskan untuk belajar untuk ujian akhir<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai ujian akhir<\/span> <\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8660 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel1.png\" alt=\"\" width=\"359\" height=\"338\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Gunakan langkah-langkah berikut untuk menemukan korelasi parsial antara jam belajar dan nilai ujian sambil mengontrol nilai saat ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Hitung setiap korelasi berpasangan.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita akan menghitung korelasi antara setiap kombinasi variabel berpasangan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8661 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel2.png\" alt=\"\" width=\"589\" height=\"348\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung korelasi parsial antara jam kerja dan nilai ujian.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung korelasi parsial antara variabel A dan variabel B sekaligus mengendalikan variabel C adalah sebagai berikut:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\">Korelasi parsial = (r <sub>A,B<\/sub> \u2013 r <sub>A,C<\/sub> *r <sub>B,C<\/sub> ) \/ \u221a((1-r <sup>2<\/sup> <sub>A,B<\/sub> )(1-r <sup>2<\/sup> <sub>B,C<\/sub> ))<\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini untuk menghitung korelasi parsial antara jam kerja dan nilai ujian, dengan mengontrol nilai saat ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8662 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel3.png\" alt=\"Cara menghitung korelasi parsial di excel\" width=\"641\" height=\"279\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Korelasi parsial sebesar <strong>0,190626<\/strong> . Untuk menentukan apakah korelasi ini signifikan secara statistik, kita dapat menemukan nilai p yang sesuai.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai p dari korelasi parsial.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Statistik uji <em>-t<\/em> dapat dihitung sebagai berikut:<\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\">t = r\u221a(n-3) \/ \u221a(1-r <sup>2<\/sup> )<\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini untuk menghitung statistik uji dan nilai p yang sesuai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8663 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel4.png\" alt=\"Uji Korelasi Parsial untuk Signifikansi di Excel\" width=\"672\" height=\"312\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Statistik uji <em>-t<\/em> sebesar <strong>0,51377<\/strong> . Jumlah derajat kebebasannya adalah n-3 = 10-3 = <strong>7<\/strong> . Nilai p yang sesuai adalah <strong>0,623228<\/strong> . Karena nilai ini tidak kurang dari 0,05, berarti korelasi parsial antara jam kerja dan hasil ujian tidak signifikan secara statistik.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, kita sering menggunakan koefisien korelasi Pearson untuk mengukur hubungan linier antara dua variabel. Namun, terkadang kita ingin memahami hubungan antara dua variabel sambil mengendalikan variabel ketiga . Misalnya, kita ingin mengukur hubungan antara jumlah jam belajar siswa dan nilai ujian akhir, sambil mengontrol nilai siswa saat ini di kelas. Dalam hal ini, kita [&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 Korelasi Parsial di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara menghitung korelasi parsial di Excel, termasuk 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\/korelasi-parsial-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Korelasi Parsial di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara menghitung korelasi parsial di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T18:28:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel1.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\/korelasi-parsial-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/\",\"name\":\"Cara Menghitung Korelasi Parsial di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T18:28:57+00:00\",\"dateModified\":\"2023-07-28T18:28:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara menghitung korelasi parsial di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung korelasi 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 Menghitung Korelasi Parsial di Excel - Statologi","description":"Penjelasan sederhana cara menghitung korelasi parsial di Excel, termasuk 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\/korelasi-parsial-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Korelasi Parsial di Excel - Statologi","og_description":"Penjelasan sederhana cara menghitung korelasi parsial di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T18:28:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/correction-partielleexcel1.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\/korelasi-parsial-unggul\/","url":"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/","name":"Cara Menghitung Korelasi Parsial di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T18:28:57+00:00","dateModified":"2023-07-28T18:28:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara menghitung korelasi parsial di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/korelasi-parsial-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung korelasi 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\/787"}],"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=787"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/787\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}