{"id":3601,"date":"2023-07-16T14:50:05","date_gmt":"2023-07-16T14:50:05","guid":{"rendered":"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/"},"modified":"2023-07-16T14:50:05","modified_gmt":"2023-07-16T14:50:05","slug":"kovarians-p-vs-kovarians-s-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/","title":{"rendered":"Covariance.p vs covariance.s di excel: apa bedanya?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Dalam statistik, <strong>kovarians<\/strong> adalah cara mengukur bagaimana perubahan pada satu variabel dikaitkan dengan perubahan pada variabel lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai kovarians yang positif menunjukkan bahwa peningkatan suatu variabel berhubungan dengan peningkatan variabel lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai negatif menunjukkan bahwa peningkatan suatu variabel dikaitkan dengan penurunan variabel lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua fungsi berbeda yang bisa Anda gunakan untuk menghitung kovarians di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. COVARIANCE.P:<\/strong> Fungsi ini menghitung kovarians populasi. Gunakan fungsi ini bila rentang nilai mewakili seluruh populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan rumus berikut:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\">Kovariansi populasi = \u03a3( <sub>xi<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> )(y <sub>i<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">y<\/span> ) \/ n<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> Nilai <sup>ke<\/sup> i dari variabel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">x<\/span><\/strong> : Nilai rata-rata variabel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>y <sub>i<\/sub> :<\/strong> nilai <sup>ke-i<\/sup> dari variabel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">y<\/span><\/strong> : Nilai rata-rata variabel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n :<\/strong> Jumlah total observasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>2. COVARIANCE.S:<\/strong> Fungsi ini menghitung kovarians sampel. Gunakan fungsi ini ketika rentang nilai mewakili sampel nilai, bukan keseluruhan populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan rumus berikut:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\">Kovariansi sampel = \u03a3( <sub>xi<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> )(y <sub>i<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">y<\/span> ) \/ (n-1)<\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>\u03a3:<\/strong> Simbol Yunani yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub> :<\/strong> Nilai <sup>ke<\/sup> i dari variabel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">x<\/span><\/strong> : Nilai rata-rata variabel x<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>y <sub>i<\/sub> :<\/strong> nilai <sup>ke-i<\/sup> dari variabel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"border-top: 1px solid black;\">y<\/span><\/strong> : Nilai rata-rata variabel y<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n :<\/strong> Jumlah total observasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan perbedaan halus antara kedua rumus: <strong>COVARIANCE.P<\/strong> membagi dengan <strong>n<\/strong> sedangkan <strong>COVARIANCE.S<\/strong> membagi dengan <strong>n-1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Oleh karena itu rumus <strong>COVARIANCE.S<\/strong> akan selalu menghasilkan nilai yang lebih besar karena dibagi dengan nilai yang lebih kecil.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dalam praktik.<\/span><\/p>\n<h2> <strong>Contoh: COVARIANCE.P vs COVARIANCE.S di Excel<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kumpulan data berikut di Excel yang memperlihatkan poin dan assist dari 15 pemain bola basket yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29676 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar1.jpg\" alt=\"\" width=\"455\" height=\"459\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung kovarians antara titik dan bantuan menggunakan dua rumus kovarians yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29677 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar2.jpg\" alt=\"\" width=\"627\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kovariansi sampel menjadi <b>15,69<\/b> dan kovarian populasi menjadi <strong>14,64<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seperti disebutkan sebelumnya, kovarians sampel akan selalu lebih besar daripada kovarians populasi.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Kapan menggunakan COVARIANCE.P atau COVARIANCE.S<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Dalam kebanyakan kasus, kami tidak dapat mengumpulkan data untuk seluruh populasi. Oleh karena itu kami mengumpulkan data hanya untuk <a href=\"https:\/\/statorials.org\/id\/populasi-vs.-sampel\/\" target=\"_blank\" rel=\"noopener\">sampel<\/a> dari populasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, kami hampir selalu menggunakan <strong>COVARIANCE.S<\/strong> untuk menghitung kovarians suatu kumpulan data karena kumpulan data kami umumnya mewakili sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Dalam kasus yang jarang terjadi ketika data Anda mewakili keseluruhan populasi, Anda dapat menggunakan fungsi <strong>COVARIANCE.P<\/strong> .<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan perbedaan antara fungsi Excel lainnya yang umum digunakan:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/stdevp-vs-stdevs-di-excel\/\" target=\"_blank\" rel=\"noopener\">STDEV.P vs STDEV.S di Excel: Apa bedanya?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/persentil-exc-vs-persentil-inc-excel\/\" target=\"_blank\" rel=\"noopener\">PERCENTILE.EXC vs PERCENTILE.INC di Excel: Apa bedanya?<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kuartil-exc-vs-kuartil-inc-excel\/\">QUARTILE.EXC vs QUARTILE.INC di Excel: Apa bedanya?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dalam statistik, kovarians adalah cara mengukur bagaimana perubahan pada satu variabel dikaitkan dengan perubahan pada variabel lain. Nilai kovarians yang positif menunjukkan bahwa peningkatan suatu variabel berhubungan dengan peningkatan variabel lainnya. Nilai negatif menunjukkan bahwa peningkatan suatu variabel dikaitkan dengan penurunan variabel lainnya. Ada dua fungsi berbeda yang bisa Anda gunakan untuk menghitung kovarians di [&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>COVARIANCE.P vs COVARIANCE.S di Excel: apa bedanya? - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan antara COVARIANCE.P dan COVARIANCE.S di Excel, beserta sebuah contoh.\" \/>\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\/kovarians-p-vs-kovarians-s-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"COVARIANCE.P vs COVARIANCE.S di Excel: apa bedanya? - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan antara COVARIANCE.P dan COVARIANCE.S di Excel, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T14:50:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar1.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\/kovarians-p-vs-kovarians-s-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/\",\"name\":\"COVARIANCE.P vs COVARIANCE.S di Excel: apa bedanya? - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T14:50:05+00:00\",\"dateModified\":\"2023-07-16T14:50:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan antara COVARIANCE.P dan COVARIANCE.S di Excel, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Covariance.p vs covariance.s di excel: apa bedanya?\"}]},{\"@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":"COVARIANCE.P vs COVARIANCE.S di Excel: apa bedanya? - Statorial","description":"Tutorial ini menjelaskan perbedaan antara COVARIANCE.P dan COVARIANCE.S di Excel, beserta sebuah contoh.","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\/kovarians-p-vs-kovarians-s-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"COVARIANCE.P vs COVARIANCE.S di Excel: apa bedanya? - Statorial","og_description":"Tutorial ini menjelaskan perbedaan antara COVARIANCE.P dan COVARIANCE.S di Excel, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-16T14:50:05+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/covar1.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\/kovarians-p-vs-kovarians-s-di-excel\/","url":"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/","name":"COVARIANCE.P vs COVARIANCE.S di Excel: apa bedanya? - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T14:50:05+00:00","dateModified":"2023-07-16T14:50:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan antara COVARIANCE.P dan COVARIANCE.S di Excel, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kovarians-p-vs-kovarians-s-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Covariance.p vs covariance.s di excel: apa bedanya?"}]},{"@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\/3601"}],"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=3601"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3601\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}