{"id":1510,"date":"2023-07-26T02:29:58","date_gmt":"2023-07-26T02:29:58","guid":{"rendered":"https:\/\/statorials.org\/id\/varians-grup-excel\/"},"modified":"2023-07-26T02:29:58","modified_gmt":"2023-07-26T02:29:58","slug":"varians-grup-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/varians-grup-excel\/","title":{"rendered":"Cara menghitung pooled variance di excel (langkah demi langkah)"},"content":{"rendered":"

<\/p>\n

\n

Dalam statistik, varian klaster<\/a> mengacu pada rata-rata dari dua atau lebih varian klaster.<\/span><\/p>\n

Kita menggunakan kata “dikumpulkan” untuk menunjukkan bahwa kita “menggabungkan” dua atau lebih varian kelompok untuk mendapatkan satu angka untuk varian umum antar kelompok.<\/span><\/p>\n

Dalam praktiknya, varians yang dikumpulkan paling sering digunakan dalam uji-t dua sampel<\/a> , yang digunakan untuk menentukan apakah rata-rata dua populasi sama atau tidak.<\/span><\/p>\n

Varians yang dikumpulkan antara dua sampel umumnya dilambangkan sp<\/sub> 2<\/sup> dan dihitung sebagai berikut:<\/span><\/p>\n

s p<\/sub> 2<\/sup> = ( (n 1<\/sub> -1)s 1<\/sub> 2<\/sup> + (n 2<\/sub> -1)s 2<\/sub> 2<\/sup> ) \/ (n 1<\/sub> +n 2<\/sub> -2)<\/span><\/p>\n

Tutorial ini memberikan contoh langkah demi langkah tentang cara menghitung varians gabungan antara dua grup di Excel.<\/span><\/p>\n

Langkah 1: Buat datanya<\/strong><\/span><\/h3>\n

Pertama, mari buat dua kumpulan data:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 2: Hitung ukuran sampel dan varians sampel<\/strong><\/span><\/h3>\n

Selanjutnya, mari kita hitung ukuran sampel dan varians sampel untuk setiap kumpulan data.<\/span><\/p>\n

Sel E17:F18 menunjukkan rumus yang kami gunakan:<\/span> <\/p>\n

\"\"<\/p>\n

Langkah 3: Hitung Kesenjangan Terkelompok<\/strong><\/span><\/h3>\n

Terakhir, kita dapat menggunakan rumus berikut untuk menghitung varians gabungan:<\/span> <\/p>\n

 =(( B17<\/span> -1)* B18<\/span> + ( C17<\/span> -1)* C18<\/span> ) \/ ( B17<\/span> + C17<\/span> -2)\n<\/strong><\/pre>\n
\"Variasi<\/p>\n
 Varians yang dikumpulkan antara kedua kelompok ini adalah 46,97<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara melakukan uji-t satu sampel di Excel<\/a>
 Cara melakukan uji-t dua sampel di Excel<\/a>
 Bagaimana melakukan uji-t Welch di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Dalam statistik, varian klaster mengacu pada rata-rata dari dua atau lebih varian klaster. Kita menggunakan kata “dikumpulkan” untuk menunjukkan bahwa kita “menggabungkan” dua atau lebih varian kelompok untuk mendapatkan satu angka untuk varian umum antar kelompok. Dalam praktiknya, varians yang dikumpulkan paling sering digunakan dalam uji-t dua sampel , yang digunakan untuk menentukan apakah rata-rata […]<\/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":"\nCara Menghitung Pooled Variance di Excel (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung varians gabungan di Excel, termasuk contoh langkah demi langkah.\" \/>\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-grup-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung Pooled Variance di Excel (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung varians gabungan di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/varians-grup-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T02:29:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pooledvarexcel1.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-grup-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/varians-grup-excel\/\",\"name\":\"Cara Menghitung Pooled Variance di Excel (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-26T02:29:58+00:00\",\"dateModified\":\"2023-07-26T02:29:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung varians gabungan di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/varians-grup-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/varians-grup-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/varians-grup-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung pooled variance di excel (langkah demi langkah)\"}]},{\"@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 Pooled Variance di Excel (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara menghitung varians gabungan di Excel, termasuk contoh langkah demi langkah.","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-grup-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung Pooled Variance di Excel (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara menghitung varians gabungan di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/varians-grup-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-26T02:29:58+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pooledvarexcel1.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-grup-excel\/","url":"https:\/\/statorials.org\/id\/varians-grup-excel\/","name":"Cara Menghitung Pooled Variance di Excel (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-26T02:29:58+00:00","dateModified":"2023-07-26T02:29:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung varians gabungan di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/varians-grup-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/varians-grup-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/varians-grup-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung pooled variance di excel (langkah demi langkah)"}]},{"@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\/1510"}],"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=1510"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1510\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
 Bonus:<\/strong> Anda dapat menggunakan kalkulator varians gabungan<\/a> ini untuk secara otomatis menghitung varians gabungan antara dua kelompok.<\/span><\/p>\n