{"id":1075,"date":"2023-07-27T18:30:49","date_gmt":"2023-07-27T18:30:49","guid":{"rendered":"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/"},"modified":"2023-07-27T18:30:49","modified_gmt":"2023-07-27T18:30:49","slug":"matriks-korelasi-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/","title":{"rendered":"Cara membuat matriks korelasi di google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Salah satu cara untuk mengukur hubungan antara dua variabel adalah dengan menggunakan<\/span> <a href=\"https:\/\/statorials.org\/id\/koefisien-korelasi-pearson-1\/\" target=\"_blank\" rel=\"noopener noreferrer\">koefisien korelasi Pearson<\/a> <span style=\"color: #000000;\">, yang merupakan ukuran hubungan linier antara dua variabel <em>.<\/em> Ini memiliki nilai antara -1 dan 1 di mana:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">-1 menunjukkan korelasi linier negatif sempurna antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\">0 menunjukkan tidak ada korelasi linier antara dua variabel<\/span><\/li>\n<li> <span style=\"color: #000000;\">Angka 1 menunjukkan korelasi linier positif sempurna antara dua variabel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Semakin jauh koefisien korelasi dari nol maka semakin kuat hubungan kedua variabel tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun dalam beberapa kasus, kami ingin memahami korelasi antara beberapa pasangan variabel. Dalam kasus ini, kita dapat membuat <a href=\"https:\/\/statorials.org\/id\/cara-membaca-matriks-korelasi\/\" target=\"_blank\" rel=\"noopener noreferrer\">matriks korelasi<\/a> , yaitu tabel persegi yang menunjukkan koefisien korelasi antara beberapa kombinasi variabel berpasangan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara membuat dan menafsirkan matriks korelasi di Google Sheets.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Cara Membuat Matriks Korelasi di Google Sheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut yang menunjukkan jumlah rata-rata poin, rebound, dan assist untuk 10 pemain bola basket:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk membuat matriks korelasi pada dataset ini, kita dapat menggunakan fungsi <strong>CORREL()<\/strong> dengan sintaks berikut:<\/span> <\/p>\n<blockquote>\n<p class=\"has-text-color\"><span style=\"color: #000000;\">&nbsp;<\/span> <strong><span style=\"color: #000000;\">COVAR(data_y, data_x)<\/span><\/strong><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Matriks kovarians untuk kumpulan data ini ditampilkan di sel <strong>B15:D17<\/strong> sedangkan rumus yang digunakan untuk membuat matriks kovarians ditampilkan di sel <strong>B21:D23<\/strong> di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11042 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cormatrixsheets1.png\" alt=\"Matriks Korelasi di Google Sheets\" width=\"634\" height=\"515\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Bagaimana menafsirkan matriks korelasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Nilai-nilai dalam sel individual matriks korelasi memberi tahu kita koefisien korelasi Pearson antara setiap kombinasi variabel berpasangan. Misalnya:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Korelasi antara poin dan rebound:<\/strong> -0,0464. Poin dan rebound sedikit berkorelasi negatif, namun nilai ini sangat mendekati nol sehingga tidak ada bukti kuat mengenai hubungan signifikan antara kedua variabel ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Korelasi antara poin dan assist:<\/strong> 0,1219. Poin dan assist berkorelasi sedikit positif, namun nilai ini juga cukup mendekati nol, sehingga tidak ada bukti kuat mengenai hubungan signifikan antara kedua variabel ini.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Korelasi antara rebound dan assist:<\/strong> 0,7137. Rebound dan assist berkorelasi sangat positif. Artinya, pemain yang punya rebound lebih banyak juga cenderung punya assist lebih banyak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai diagonal matriks korelasi semuanya 1 karena korelasi antara suatu variabel dengan variabel itu sendiri selalu 1. Dalam praktiknya, angka ini tidak berguna untuk diinterpretasikan.<\/span><\/p>\n<h3> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/cara-membaca-matriks-korelasi\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara membaca matriks korelasi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/matriks-korelasi-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Membuat Matriks Korelasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Salah satu cara untuk mengukur hubungan antara dua variabel adalah dengan menggunakan koefisien korelasi Pearson , yang merupakan ukuran hubungan linier antara dua variabel . Ini memiliki nilai antara -1 dan 1 di mana: -1 menunjukkan korelasi linier negatif sempurna antara dua variabel 0 menunjukkan tidak ada korelasi linier antara dua variabel Angka 1 menunjukkan [&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 Matriks Korelasi di Google Sheets \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat matriks korelasi di Google Sheets beserta contohnya.\" \/>\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\/matriks-korelasi-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 Matriks Korelasi di Google Sheets \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat matriks korelasi di Google Sheets beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T18:30:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cormatrixsheets1.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\/matriks-korelasi-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/\",\"name\":\"Cara Membuat Matriks Korelasi di Google Sheets \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T18:30:49+00:00\",\"dateModified\":\"2023-07-27T18:30:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat matriks korelasi di Google Sheets beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat matriks korelasi 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 Matriks Korelasi di Google Sheets \u2013 Statologi","description":"Penjelasan sederhana cara membuat matriks korelasi di Google Sheets beserta contohnya.","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\/matriks-korelasi-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Matriks Korelasi di Google Sheets \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat matriks korelasi di Google Sheets beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T18:30:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cormatrixsheets1.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\/matriks-korelasi-google-sheet\/","url":"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/","name":"Cara Membuat Matriks Korelasi di Google Sheets \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T18:30:49+00:00","dateModified":"2023-07-27T18:30:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat matriks korelasi di Google Sheets beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/matriks-korelasi-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat matriks korelasi 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\/1075"}],"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=1075"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1075\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}