{"id":446,"date":"2023-07-29T22:04:47","date_gmt":"2023-07-29T22:04:47","guid":{"rendered":"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/"},"modified":"2023-07-29T22:04:47","modified_gmt":"2023-07-29T22:04:47","slug":"matriks-kovarians-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/","title":{"rendered":"Cara membuat matriks kovariansi di excel"},"content":{"rendered":"<hr><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><!-- \/wp:paragraph --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Rumus untuk menghitung kovarians antara dua variabel <em>X<\/em> dan <em>Y<\/em> adalah: <\/p><!-- \/wp:paragraph --><!-- wp:paragraph {\"align\":\"center\",\"customTextColor\":\"#000000\"} --><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><!-- \/wp:paragraph --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><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 sederhana dan berguna untuk memahami bagaimana berbagai variabel saling terkait dalam kumpulan data. <\/p><!-- \/wp:paragraph --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Contoh berikut memperlihatkan cara membuat matriks kovarians di Excel menggunakan kumpulan data sederhana.<\/p><!-- \/wp:paragraph --><!-- wp:heading {\"level\":3} --><h3> <strong>Cara Membuat Matriks Kovariansi di Excel<\/strong> <\/h3><!-- \/wp:heading --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Katakanlah kita memiliki kumpulan data berikut yang menunjukkan nilai ujian 10 siswa berbeda dalam tiga mata pelajaran: matematika, sains, dan sejarah. <\/p><!-- \/wp:paragraph --><!-- wp:image {\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><figcaption><\/figcaption><\/figure><\/div><!-- \/wp:image --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Untuk membuat matriks kovarians untuk kumpulan data ini, klik opsi <strong>Analisis Data<\/strong> di kanan atas Excel di bawah tab <em>Data<\/em> .<\/p><!-- \/wp:paragraph --><!-- wp:image {\"id\":1698,\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" loading=\"lazy\" width=\"415\" height=\"98\" class=\"wp-image-1698\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pack-doutils3.jpg\" alt=\"Perangkat analisis di Excel\" srcset=\"\" sizes=\"\"><\/figure><\/div><!-- \/wp:image --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p> <em><span style=\"color: #000000;\"><strong>Catatan:<\/strong> Jika Anda tidak melihat opsi Analisis Data, Anda harus<\/span> <a href=\"https:\/\/statorials.org\/id\/cara-memuat-toolpak-analisis-di-excel\/\" target=\"_blank\" rel=\"noopener\">memuat Toolpak Analisis Data<\/a> terlebih dahulu <span style=\"color: #000000;\">.<\/span><\/em> <\/p><!-- \/wp:paragraph --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Setelah Anda mengklik opsi ini, jendela baru akan muncul. Klik <strong>Kovarians<\/strong> . <\/p><!-- \/wp:paragraph --><!-- wp:image {\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><\/figure><\/div><!-- \/wp:image --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Di kotak <em>Input Range<\/em> , ketik &#8220;$A$1:$C$11&#8221; karena ini adalah rentang sel tempat dataset kita berada. Centang kotak <em>Labels in first row<\/em> untuk memberi tahu Excel bahwa label untuk variabel kita ada di baris pertama. Lalu, dalam kotak <em>Rentang Output<\/em> , ketikkan sel mana pun yang Anda inginkan untuk menampilkan matriks kovarians. Saya pikir sel $E$2. Lalu klik <em>oke<\/em> . <\/p><!-- \/wp:paragraph --><!-- wp:image {\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><\/figure><\/div><!-- \/wp:image --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Matriks kovarians dibuat secara otomatis dan muncul di sel $E$2: <\/p><!-- \/wp:paragraph --><!-- wp:image {\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><\/figure><\/div><!-- \/wp:image --><!-- wp:heading {\"level\":3} --><h3> <strong>Bagaimana menafsirkan matriks kovarians<\/strong> <\/h3><!-- \/wp:heading --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Setelah kita memiliki matriks kovarians, cukup mudah untuk menginterpretasikan nilai-nilai matriks tersebut. <\/p><!-- \/wp:paragraph --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Nilai-nilai sepanjang diagonal matriks hanyalah varian dari setiap subjek. Misalnya: <\/p><!-- \/wp:paragraph --><!-- wp:list {\"className\":\"has-text-color\"} --><ul class=\"has-text-color\" style=\"color: #000000;\"><li> Varians skor matematika sebesar 64,96<\/li><li> Varians skor sains adalah 56,4<\/li><li> Varians skor historis adalah 75,56 <\/li><\/ul><!-- \/wp:list --><!-- wp:image {\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><\/figure><\/div><!-- \/wp:image --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><p class=\"has-text-color\" style=\"color: #000000;\"> Nilai-nilai lain dari matriks mewakili kovarians antara subjek yang berbeda. Misalnya: <\/p><!-- \/wp:paragraph --><!-- wp:list {\"className\":\"has-text-color\"} --><ul class=\"has-text-color\" style=\"color: #000000;\"><li> Kovariansi antara nilai matematika dan sains adalah 33,2.<\/li><li> Kovariansi antara nilai matematika dan sejarah adalah -24,44.<\/li><li> Kovariansi antara skor sains dan sejarah adalah -24,1. <\/li><\/ul><!-- \/wp:list --><!-- wp:image {\"align\":\"center\"} --><div class=\"wp-block-image\"><figure class=\"aligncenter\"><\/figure><\/div><!-- \/wp:image --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><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><!-- \/wp:paragraph --><!-- wp:paragraph {\"customTextColor\":\"#000000\"} --><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><!-- \/wp:paragraph -->","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 Kovariansi di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat matriks kovarians di Excel.\" \/>\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-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membuat Matriks Kovariansi di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat matriks kovarians di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T22:04:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pack-doutils3.jpg\" \/>\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-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/\",\"name\":\"Cara Membuat Matriks Kovariansi di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T22:04:47+00:00\",\"dateModified\":\"2023-07-29T22:04:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat matriks kovarians di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat matriks kovariansi 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 Membuat Matriks Kovariansi di Excel \u2013 Statologi","description":"Penjelasan sederhana cara membuat matriks kovarians di Excel.","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-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membuat Matriks Kovariansi di Excel \u2013 Statologi","og_description":"Penjelasan sederhana cara membuat matriks kovarians di Excel.","og_url":"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-29T22:04:47+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pack-doutils3.jpg"}],"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-unggul\/","url":"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/","name":"Cara Membuat Matriks Kovariansi di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T22:04:47+00:00","dateModified":"2023-07-29T22:04:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat matriks kovarians di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/matriks-kovarians-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat matriks kovariansi 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\/446"}],"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=446"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/446\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}