{"id":3600,"date":"2023-07-16T14:58:19","date_gmt":"2023-07-16T14:58:19","guid":{"rendered":"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/"},"modified":"2023-07-16T14:58:19","modified_gmt":"2023-07-16T14:58:19","slug":"laporan-varians-uji-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/","title":{"rendered":"Cara melakukan uji rasio varians di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Uji rasio varians<\/strong> digunakan untuk menguji apakah varians dua populasi sama atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pengujian ini menggunakan hipotesis nol dan hipotesis alternatif berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub><\/strong> : Varians populasi sama<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H <sub>A<\/sub><\/strong> : Varians populasi tidak sama<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukan pengujian ini, kami menghitung statistik pengujian berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>F<\/strong> = s <sub>1<\/sub> <sup>2<\/sup> \/ s <sub>2<\/sub> <sup>2<\/sup><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>s <sub>1<\/sub> <sup>2<\/sup><\/strong> : Varians sampel kelompok pertama<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>s <sub>2<\/sub> <sup>2<\/sup><\/strong> : Varians sampel kelompok kedua<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Jika <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> yang sesuai dengan statistik uji F ini berada di bawah ambang batas tertentu (misalnya 0,05), maka kita menolak hipotesis nol dan menyimpulkan bahwa varians populasi tidak sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara melakukan uji rasio varians di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengetahui apakah dua spesies tumbuhan berbeda mempunyai variasi tinggi yang sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengujinya, kami mengumpulkan <a href=\"https:\/\/statorials.org\/id\/metode-pengambilan-sampel\/\" target=\"_blank\" rel=\"noopener noreferrer\">sampel acak sederhana<\/a> yang terdiri dari 15 tanaman dari setiap spesies.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan ketinggian masing-masing spesies:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29670 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vartest1.jpg\" alt=\"\" width=\"426\" height=\"483\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung statistik uji F<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengetikkan rumus berikut di sel <strong>E1<\/strong> untuk menghitung statistik uji F:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=VAR.S( <span style=\"color: #3366ff;\">A2:A16<\/span> )\/VAR.S( <span style=\"color: #ff0000;\">B2:B16<\/span> )<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-29671 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vartest2.jpg\" alt=\"\" width=\"501\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Statistik uji F ternyata sebesar <strong>0,437178<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung nilai P<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan mengetikkan rumus berikut di sel <strong>E2<\/strong> untuk menghitung nilai p yang sesuai dengan statistik uji F:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=F.DIST( <span style=\"color: #3366ff;\">E1<\/span> , COUNT( <span style=\"color: #ff0000;\">A2:A16<\/span> )-1, COUNT( <span style=\"color: #800080;\">B2:B16<\/span> )-1, TRUE)*2<\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-29672\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vartest3.jpg\" alt=\"menguji rasio varians di Excel\" width=\"644\" height=\"540\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam rumusnya, kita mengalikan dengan 2 di akhir untuk menghasilkan nilai p dua sisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai pnya ternyata <strong>0,133596<\/strong> .<\/span><\/p>\n<p data-slot-rendered-dynamic=\"true\"> <span style=\"color: #000000;\">Mari kita mengingat kembali hipotesis nol dan hipotesis alternatif dari pengujian ini:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub><\/strong> : Varians populasi sama<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H <sub>A<\/sub><\/strong> : Varians populasi tidak sama<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Karena nilai p pengujian kami <strong>(0,133596)<\/strong> tidak kurang dari 0,05, kami gagal menolak hipotesis nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya, kita tidak mempunyai cukup bukti untuk menyimpulkan bahwa keragaman tinggi tanaman antara kedua spesies tersebut tidak sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tes-korelasi-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan tes korelasi di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/selamat-datang-untuk-menguji-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana melakukan uji-t Welch di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tes-excel-kolmogorov-smirnov\/\" target=\"_blank\" rel=\"noopener\">Cara Melakukan Tes Kolmogorov-Smirnov di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uji rasio varians digunakan untuk menguji apakah varians dua populasi sama atau tidak. Pengujian ini menggunakan hipotesis nol dan hipotesis alternatif berikut: H 0 : Varians populasi sama H A : Varians populasi tidak sama Untuk melakukan pengujian ini, kami menghitung statistik pengujian berikut: F = s 1 2 \/ s 2 2 Emas: s [&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 Melakukan Uji Rasio Varians di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan uji rasio varians di Excel, dengan 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\/laporan-varians-uji-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Uji Rasio Varians di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan uji rasio varians di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T14:58:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vartest1.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\/laporan-varians-uji-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/\",\"name\":\"Cara Melakukan Uji Rasio Varians di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T14:58:19+00:00\",\"dateModified\":\"2023-07-16T14:58:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan uji rasio varians di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan uji rasio varians 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 Melakukan Uji Rasio Varians di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan uji rasio varians di Excel, dengan 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\/laporan-varians-uji-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Uji Rasio Varians di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan uji rasio varians di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-16T14:58:19+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vartest1.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\/laporan-varians-uji-excel\/","url":"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/","name":"Cara Melakukan Uji Rasio Varians di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T14:58:19+00:00","dateModified":"2023-07-16T14:58:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan uji rasio varians di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/laporan-varians-uji-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan uji rasio varians 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\/3600"}],"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=3600"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3600\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}