{"id":1685,"date":"2023-07-25T09:34:28","date_gmt":"2023-07-25T09:34:28","guid":{"rendered":"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/"},"modified":"2023-07-25T09:34:28","modified_gmt":"2023-07-25T09:34:28","slug":"f-menguji-lembar-google","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/","title":{"rendered":"Tes f di google sheets (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Uji F<\/strong> digunakan untuk mengetahui apakah varian dua populasi sama atau tidak.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Uji-F menggunakan hipotesis nol dan hipotesis alternatif berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">H <sub>0<\/sub> : Varians populasinya sama (\u03c3 <sub>1<\/sub> <sup>2<\/sup> = \u03c3 <sub>2<\/sub> <sup>2<\/sup> )<\/span><\/li>\n<li> <span style=\"color: #000000;\">H <sub>A<\/sub> : Varians populasi tidak sama (\u03c3 <sub>1<\/sub> <sup>2<\/sup> \u2260 \u03c3 <sub>2<\/sub> <sup>2<\/sup> )<\/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\">p-value<\/a> pengujian berada di bawah tingkat signifikansi tertentu (misalnya \u03b1 = 0,05), maka kita dapat menolak hipotesis nol dan menyimpulkan bahwa varians populasi tidak sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan uji F di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai data untuk dua sampel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-16611 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ffeuilles1.png\" alt=\"\" width=\"523\" height=\"409\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Ukuran sampel antara kedua kelompok tidak perlu sama untuk melakukan uji F.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Lakukan Uji F<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menggunakan fungsi <strong>=FTEST(sample1, sample2)<\/strong> untuk melakukan uji F:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-16612\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ffeuilles2.png\" alt=\"Tes F di Google Spreadsheet\" width=\"515\" height=\"403\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Nilai p dari tes tersebut ternyata <strong>0,0367<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena nilai p ini kurang dari \u03b1 = 0,05, kami akan menolak hipotesis nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Artinya kita mempunyai cukup bukti untuk mengatakan bahwa perbedaan antara dua populasi yang dijadikan sampel tidaklah sama.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan:<\/strong> Nilai p yang dikembalikan oleh fungsi <strong>FTEST()<\/strong> mewakili nilai p dua sisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, jika Anda melakukan uji satu sisi ( <sub>HA<\/sub> : \u03c3 <sub>1<\/sub> <sup>2<\/sup> &lt; \u03c3 <sub>2<\/sub> <sup>2<\/sup> atau <sub>HA<\/sub> : \u03c3 <sub>1<\/sub> <sup>2<\/sup> &gt; \u03c3 <sub>2<\/sub> <sup>2<\/sup> ), Anda cukup mengalikan nilai p yang dihasilkan dengan dua untuk mendapatkan nilai satu sisi nilai p.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/tidak-menguji-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan uji-t di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/nilai-kritis-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai kritis di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/p-nilai-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menemukan nilai P di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uji F digunakan untuk mengetahui apakah varian dua populasi sama atau tidak. Uji-F menggunakan hipotesis nol dan hipotesis alternatif berikut: H 0 : Varians populasinya sama (\u03c3 1 2 = \u03c3 2 2 ) H A : Varians populasi tidak sama (\u03c3 1 2 \u2260 \u03c3 2 2 ) Jika p-value pengujian berada di bawah [&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>Tes F di Google Sheets (langkah demi langkah) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan uji F di Google Sheets, 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\/f-menguji-lembar-google\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tes F di Google Sheets (langkah demi langkah) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan uji F di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T09:34:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ffeuilles1.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\/f-menguji-lembar-google\/\",\"url\":\"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/\",\"name\":\"Tes F di Google Sheets (langkah demi langkah) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T09:34:28+00:00\",\"dateModified\":\"2023-07-25T09:34:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan uji F di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tes f di google sheets (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":"Tes F di Google Sheets (langkah demi langkah) \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan uji F di Google Sheets, 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\/f-menguji-lembar-google\/","og_locale":"id_ID","og_type":"article","og_title":"Tes F di Google Sheets (langkah demi langkah) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan uji F di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/","og_site_name":"Statorials","article_published_time":"2023-07-25T09:34:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ffeuilles1.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\/f-menguji-lembar-google\/","url":"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/","name":"Tes F di Google Sheets (langkah demi langkah) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T09:34:28+00:00","dateModified":"2023-07-25T09:34:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan uji F di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/f-menguji-lembar-google\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/f-menguji-lembar-google\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Tes f di google sheets (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\/1685"}],"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=1685"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1685\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}