{"id":1675,"date":"2023-07-25T10:32:48","date_gmt":"2023-07-25T10:32:48","guid":{"rendered":"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/"},"modified":"2023-07-25T10:32:48","modified_gmt":"2023-07-25T10:32:48","slug":"varp-vs-vars-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/","title":{"rendered":"Var.p vs var.s di excel: apa bedanya?"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada tiga fungsi berbeda yang bisa Anda gunakan untuk menghitung varians di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1. VAR.P:<\/strong> Fungsi ini menghitung varians 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: center;\"> <span style=\"color: #000000;\">Varians populasi = \u03a3( <sub>xi<\/sub> \u2013 \u03bc) <sup>2<\/sup> \/ 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-i<\/sup> dari kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc:<\/strong> rata-rata populasi<\/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. VAR.S:<\/strong> Fungsi ini menghitung varians 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: center;\"> <span style=\"color: #000000;\">Varians sampel = \u03a3( <sub>xi<\/sub> \u2013 <span style=\"border-top: 1px solid black;\">x<\/span> ) <sup>2<\/sup> \/ (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-i<\/sup> dari kumpulan data<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong><span style=\"text-decoration: overline;\">x<\/span> :<\/strong> Maksud sampel<\/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>3. VAR:<\/strong> Fungsi ini juga menghitung varians sampel. Ini akan mengembalikan nilai yang persis sama dengan fungsi <strong>VAR.S.<\/strong><\/span><\/p>\n<blockquote>\n<p> <span style=\"color: #000000;\"><strong>Catatan teknis:<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena rumus varians populasi habis dibagi <em>N<\/em> dan bukan <em>n-1<\/em> , varians populasi akan selalu lebih kecil dari varians sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Alasan varians populasi akan semakin kecil adalah jika kita mengetahui nilai setiap populasi, maka kita mengetahui varians pastinya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, jika kita hanya mempunyai sampel dari suatu populasi, kita mempunyai lebih banyak ketidakpastian mengenai varian pasti dari keseluruhan populasi, sehingga estimasi varians kita harus lebih besar.<\/span><\/p>\n<\/blockquote>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi-fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <strong>Contoh: VAR.P vs VAR.S di Excel<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16498 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varp1.png\" alt=\"\" width=\"447\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menghitung varians kumpulan data menggunakan tiga rumus varians yang berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16499 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varp2.png\" alt=\"VAR.P vs VAR.S di Excel\" width=\"474\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Varians sampelnya menjadi <strong>76,99<\/strong> dan varians populasinya menjadi <strong>73,14<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Seperti disebutkan sebelumnya, varians populasi akan selalu lebih kecil dari varians sampel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Kapan menggunakan VAR.P vs VAR.S<\/strong><\/span><\/h3>\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>VAR.S<\/strong> untuk menghitung varians suatu kumpulan data karena kumpulan data kami umumnya mewakili sampel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa <strong>VAR<\/strong> dan <strong>VAR.S<\/strong> mengembalikan nilai yang persis sama, sehingga kita dapat menggunakan salah satu fungsi tersebut untuk menghitung varians sampel dari kumpulan data tertentu.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/rentang-interkuartil-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rentang Interkuartil (IQR) di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kisaran-menengah-yang-sangat-baik\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Midrange di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada tiga fungsi berbeda yang bisa Anda gunakan untuk menghitung varians di Excel: 1. VAR.P: Fungsi ini menghitung varians populasi. Gunakan fungsi ini bila rentang nilai mewakili seluruh populasi. Fungsi ini menggunakan rumus berikut: Varians populasi = \u03a3( xi \u2013 \u03bc) 2 \/ N Emas: \u03a3: Simbol Yunani yang berarti \u201cjumlah\u201d x i : nilai [&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>VAR.P vs VAR.S di Excel: apa bedanya?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan perbedaan fungsi VAR.P dan VAR.S di Excel, 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\/varp-vs-vars-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VAR.P vs VAR.S di Excel: apa bedanya?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan perbedaan fungsi VAR.P dan VAR.S di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T10:32:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varp1.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\/varp-vs-vars-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/\",\"name\":\"VAR.P vs VAR.S di Excel: apa bedanya?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T10:32:48+00:00\",\"dateModified\":\"2023-07-25T10:32:48+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan perbedaan fungsi VAR.P dan VAR.S di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Var.p vs var.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":"VAR.P vs VAR.S di Excel: apa bedanya?","description":"Tutorial ini menjelaskan perbedaan fungsi VAR.P dan VAR.S di Excel, 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\/varp-vs-vars-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"VAR.P vs VAR.S di Excel: apa bedanya?","og_description":"Tutorial ini menjelaskan perbedaan fungsi VAR.P dan VAR.S di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-25T10:32:48+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varp1.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\/varp-vs-vars-di-excel\/","url":"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/","name":"VAR.P vs VAR.S di Excel: apa bedanya?","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T10:32:48+00:00","dateModified":"2023-07-25T10:32:48+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan perbedaan fungsi VAR.P dan VAR.S di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/varp-vs-vars-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Var.p vs var.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\/1675"}],"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=1675"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1675\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}