{"id":1066,"date":"2023-07-27T19:15:54","date_gmt":"2023-07-27T19:15:54","guid":{"rendered":"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/"},"modified":"2023-07-27T19:15:54","modified_gmt":"2023-07-27T19:15:54","slug":"matriks-kovarians-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/","title":{"rendered":"Cara membuat matriks kovarian di google spreadsheet"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><strong style=\"color: #000000;\">Kovarian<\/strong> <span style=\"color: #000000;\">adalah ukuran bagaimana perubahan pada satu variabel dikaitkan dengan perubahan pada variabel kedua. Lebih khusus lagi, ini adalah ukuran sejauh mana dua variabel terkait secara linier.<\/span><\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Rumus untuk menghitung kovarians antara dua variabel <em>X<\/em> dan <em>Y<\/em> adalah:<\/p>\n<p class=\"has-text-color\" style=\"color: #000000; text-align: center;\"> <strong>COV(<\/strong> <em><strong>X<\/strong><\/em> <strong>,<\/strong> <em><strong>Y<\/strong><\/em> <strong>)<\/strong> = \u03a3(x- <span style=\"text-decoration: overline;\">x<\/span> )(y- <span style=\"text-decoration: overline;\">y<\/span> ) \/ n<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>Matriks kovarians<\/strong> adalah matriks persegi yang menunjukkan kovarians antara banyak variabel yang berbeda. Ini bisa menjadi cara yang berguna untuk memahami bagaimana berbagai variabel saling terkait dalam kumpulan data.<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Contoh berikut menunjukkan cara membuat matriks kovarians di Google Spreadsheet untuk kumpulan data tertentu.<\/p>\n<h3> <strong>Cara Membuat Matriks Kovarian di Google Spreadsheet<\/strong><\/h3>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut yang menunjukkan nilai ujian 10 siswa berbeda dalam tiga mata pelajaran: matematika, sains, dan sejarah.<\/span> <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10975 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covmatrixfeuilles1.png\" alt=\"\" width=\"425\" height=\"389\" srcset=\"\" sizes=\"\"><figcaption><\/figcaption><\/figure>\n<\/div>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <span style=\"color: #000000;\">Untuk membuat matriks kovarians pada dataset ini, kita dapat menggunakan fungsi <strong>COVAR()<\/strong> dengan sintaks berikut:<\/span><\/p>\n<blockquote>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <span style=\"color: #000000;\"><strong>COVAR(data_y, data_x)<\/strong><\/span><\/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-10976 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covmatrixfeuilles2.png\" alt=\"Matriks kovarians di Google Spreadsheet\" width=\"628\" height=\"504\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <strong>Bagaimana menafsirkan matriks kovarians<\/strong><\/h3>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Setelah kita memiliki matriks kovarians, mudah untuk menginterpretasikan nilai matriks.<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Nilai-nilai sepanjang diagonal matriks hanyalah varian dari setiap subjek. Misalnya:<\/p>\n<ul class=\"has-text-color\" style=\"color: #000000;\">\n<li> Varians skor matematika sebesar 64,96<\/li>\n<li> Varians skor sains adalah 56,4<\/li>\n<li> Varians skor historis adalah 75,56 <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10977 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covmatrixfeuilles3.png\" alt=\"\" width=\"602\" height=\"116\" srcset=\"\" sizes=\"\"><\/figure>\n<\/div>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Nilai-nilai lain dari matriks mewakili kovarians antara subjek yang berbeda. Misalnya:<\/p>\n<ul class=\"has-text-color\" style=\"color: #000000;\">\n<li> Kovariansi antara nilai matematika dan sains adalah 33,2.<\/li>\n<li> Kovariansi antara nilai matematika dan sejarah adalah -24,44.<\/li>\n<li> Kovariansi antara skor sains dan sejarah adalah -24,1. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-10978 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covmatrixfeuilles4.png\" alt=\"\" width=\"622\" height=\"118\" srcset=\"\" sizes=\"\"><\/figure>\n<\/div>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>Angka positif<\/strong> untuk kovarians menunjukkan bahwa dua variabel cenderung meningkat atau menurun secara bersamaan. Misalnya, matematika dan sains memiliki kovarian positif (33,2), yang menunjukkan bahwa siswa yang mendapat nilai tinggi dalam matematika juga cenderung mendapat nilai tinggi dalam sains. Demikian pula, siswa yang mempunyai prestasi buruk dalam matematika juga cenderung mempunyai prestasi buruk dalam sains.<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>Angka negatif<\/strong> untuk kovarians menunjukkan bahwa ketika satu variabel meningkat, variabel kedua cenderung menurun. Misalnya, matematika dan sejarah memiliki kovarians negatif (-24,44), yang menunjukkan bahwa siswa yang mendapat nilai matematika tinggi cenderung mendapat nilai rendah dalam sejarah. Demikian pula, siswa yang mendapat nilai rendah dalam matematika cenderung mendapat nilai tinggi dalam sejarah.<\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Membuat Matriks Kovariansi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/matriks-kovarians-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara membuat matriks kovarians di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/matriks-kovarians-python\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Membuat Matriks Kovariansi dengan Python<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/matriks-kovarians-spss\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Membuat Matriks Kovariansi di SPSS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kovarian adalah ukuran bagaimana perubahan pada satu variabel dikaitkan dengan perubahan pada variabel kedua. Lebih khusus lagi, ini adalah ukuran sejauh mana dua variabel terkait secara linier. Rumus untuk menghitung kovarians antara dua variabel X dan Y adalah: COV( X , Y ) = \u03a3(x- x )(y- y ) \/ n Matriks kovarians adalah matriks [&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 Kovarian di Google Spreadsheet \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat matriks kovarians di Google Sheets.\" \/>\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-kovarians-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Matriks Kovarian di Google Spreadsheet \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat matriks kovarians di Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T19:15:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covmatrixfeuilles1.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-kovarians-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/\",\"name\":\"Cara Membuat Matriks Kovarian di Google Spreadsheet \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T19:15:54+00:00\",\"dateModified\":\"2023-07-27T19:15:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat matriks kovarians di Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat matriks kovarian di google spreadsheet\"}]},{\"@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 Kovarian di Google Spreadsheet \u2013 Statologi","description":"Penjelasan sederhana cara membuat matriks kovarians di Google Sheets.","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-kovarians-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Matriks Kovarian di Google Spreadsheet \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat matriks kovarians di Google Sheets.","og_url":"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-27T19:15:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covmatrixfeuilles1.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-kovarians-lembar-google\/","url":"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/","name":"Cara Membuat Matriks Kovarian di Google Spreadsheet \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T19:15:54+00:00","dateModified":"2023-07-27T19:15:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat matriks kovarians di Google Sheets.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/matriks-kovarians-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat matriks kovarian di google spreadsheet"}]},{"@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\/1066"}],"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=1066"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1066\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}