{"id":2159,"date":"2023-07-23T11:06:08","date_gmt":"2023-07-23T11:06:08","guid":{"rendered":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/"},"modified":"2023-07-23T11:06:08","modified_gmt":"2023-07-23T11:06:08","slug":"varians-populasi-sampel-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/","title":{"rendered":"Cara menghitung variasi sampel &amp; populasi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Varians<\/strong> adalah cara untuk mengukur sebaran nilai dalam suatu kumpulan data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung <strong>varians populasi<\/strong> adalah:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\"><strong>\u03c3 <sup>2<\/sup><\/strong> = \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 yang berarti \u201cjumlah\u201d<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>\u03bc<\/strong> : Rata-rata populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> : Elemen ke- <sup>i<\/sup> dari populasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>N<\/strong> : Ukuran populasi<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Rumus untuk menghitung <strong>varians sampel<\/strong> adalah:<\/span><\/p>\n<p style=\"text-align: left;\"> <span style=\"color: #000000;\"><strong>s <sup>2<\/sup><\/strong> = \u03a3 ( <sub>xi<\/sub> \u2013 <span style=\"text-decoration: overline;\">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><span style=\"text-decoration: overline;\">x<\/span><\/strong> : mean sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>x <sub>i<\/sub><\/strong> : Elemen ke- <sup>i<\/sup> dari sampel<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>n<\/strong> : Ukuran sampel<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan rumus <strong>VAR.S()<\/strong> dan <b>VAR.P()<\/b> di Excel untuk menghitung dengan cepat varians sampel dan varians populasi (masing-masing) untuk kumpulan data tertentu.<\/span> <strong>&nbsp;<\/strong><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap fungsi dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Menghitung Varians Sampel di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut memperlihatkan cara menggunakan fungsi <strong>VAR.S()<\/strong> untuk menghitung varians sampel nilai di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19986 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varexcel2.png\" alt=\"\" width=\"511\" height=\"544\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Varians sampelnya ternyata <strong>35.2079<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Menghitung Varians Populasi di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan fungsi <strong>VAR.P()<\/strong> untuk menghitung varians populasi dari nilai di kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19987 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varexcel3.png\" alt=\"\" width=\"517\" height=\"544\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Varians populasinya ternyata <strong>33.4475<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Catatan tentang penghitungan varians sampel dan populasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Ingatlah hal berikut saat menghitung varians sampel dan populasi:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Anda harus menghitung <strong>varians populasi<\/strong> ketika kumpulan data yang Anda gunakan mewakili seluruh populasi, yaitu setiap nilai yang Anda minati.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Anda harus menghitung <strong>varians sampel<\/strong> ketika kumpulan data yang Anda gunakan mewakili sampel yang diambil dari populasi yang lebih besar.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Varians sampel suatu kumpulan data akan selalu lebih besar daripada varians populasi untuk kumpulan data yang sama karena terdapat lebih banyak ketidakpastian saat menghitung varians sampel, sehingga estimasi varians kita akan lebih besar.<\/span><\/li>\n<\/ul>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menghitung metrik spread lainnya di Excel:<\/span><\/p>\n<p> <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\/deviasi-standar-tertimbang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Deviasi Standar Tertimbang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/koefisien-variasi-unggul\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Koefisien Variasi di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Varians adalah cara untuk mengukur sebaran nilai dalam suatu kumpulan data. Rumus untuk menghitung varians populasi adalah: \u03c3 2 = \u03a3 ( xi \u2013 \u03bc) 2 \/ N Emas: \u03a3 : Simbol yang berarti \u201cjumlah\u201d \u03bc : Rata-rata populasi x i : Elemen ke- i dari populasi N : Ukuran populasi Rumus untuk menghitung varians [&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 Menghitung Varians Sampel dan Populasi di Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung varians sampel dan populasi 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\/varians-populasi-sampel-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Varians Sampel dan Populasi di Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung varians sampel dan populasi di Excel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T11:06:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varexcel2.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/\",\"name\":\"Cara Menghitung Varians Sampel dan Populasi di Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T11:06:08+00:00\",\"dateModified\":\"2023-07-23T11:06:08+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung varians sampel dan populasi di Excel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung variasi sampel &amp; populasi 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 Menghitung Varians Sampel dan Populasi di Excel - Statorials","description":"Tutorial ini menjelaskan cara menghitung varians sampel dan populasi 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\/varians-populasi-sampel-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Varians Sampel dan Populasi di Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung varians sampel dan populasi di Excel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-23T11:06:08+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/varexcel2.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/","url":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/","name":"Cara Menghitung Varians Sampel dan Populasi di Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T11:06:08+00:00","dateModified":"2023-07-23T11:06:08+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung varians sampel dan populasi di Excel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/varians-populasi-sampel-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung variasi sampel &amp; populasi 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\/2159"}],"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=2159"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2159\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}