{"id":1218,"date":"2023-07-27T06:19:26","date_gmt":"2023-07-27T06:19:26","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/"},"modified":"2023-07-27T06:19:26","modified_gmt":"2023-07-27T06:19:26","slug":"lembar-google-anova-satu-arah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/","title":{"rendered":"Anova satu arah di google spreadsheet (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/anova-satu-arah\/\" target=\"_blank\" rel=\"noopener noreferrer\">ANOVA satu arah<\/a> digunakan untuk menentukan apakah terdapat perbedaan yang signifikan secara statistik antara rata-rata tiga atau lebih kelompok independen.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan ANOVA satu arah di Google Spreadsheet.<\/span><\/p>\n<h3> <strong>Langkah 1: Instal XLMiner Analysis ToolPak<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Untuk melakukan ANOVA satu arah di Google Sheets, pertama-tama kita perlu menginstal XLMiner Analysis Toolpak gratis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik <strong>Add-on &gt; Dapatkan Add-on<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12048 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles0.png\" alt=\"\" width=\"472\" height=\"249\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketik <strong>XLMiner Analysis ToolPak<\/strong> di bilah pencarian dan klik ikon yang muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12049 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles1.png\" alt=\"Instal Paket Alat Analisis XLMiner di Google Spreadsheet\" width=\"524\" height=\"329\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik tombol <strong>Instal<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12050 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles2.png\" alt=\"Alat Analisis XLMiner di Google Spreadsheet\" width=\"524\" height=\"307\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan datanya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu memasukkan data yang akan digunakan untuk ANOVA satu arah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, katakanlah seorang peneliti merekrut 30 siswa untuk berpartisipasi dalam sebuah penelitian. Siswa ditugaskan secara acak untuk menggunakan salah satu dari tiga metode belajar untuk mempersiapkan ujian. Hasil ujian untuk setiap siswa ditunjukkan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12051 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles3.png\" alt=\"\" width=\"455\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Lakukan ANOVA Satu Arah<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk melakukan ANOVA satu arah pada kumpulan data ini, klik <strong>Add-on &gt; XLMiner Analysis ToolPak &gt; Start<\/strong> . Analysis ToolPak akan muncul di sisi kanan layar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik <strong>Anova: Faktor tunggal<\/strong> dan isi informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12052\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles4.png\" alt=\"ANOVA satu arah di Google Spreadsheet\" width=\"672\" height=\"330\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 4: Interpretasikan hasilnya<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , hasil ANOVA satu arah akan muncul mulai dari sel yang Anda tentukan di <strong>Output Range<\/strong> . Dalam kasus kami, kami memilih untuk menampilkan hasil yang dimulai di sel E1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12053 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles5.png\" alt=\"Output ANOVA satu arah di Google Spreadsheet\" width=\"574\" height=\"333\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dua tabel ditampilkan di output.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel pertama menunjukkan jumlah, jumlah, mean, dan varians nilai tes untuk masing-masing ketiga kelompok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel kedua menampilkan hasil ANOVA satu arah, antara lain:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>F-statistik:<\/strong> 2,3575<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>F<\/strong> <strong>Nilai<\/strong> kritis : 3,3541<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Nilai P:<\/strong> 0,1138<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Ingatlah bahwa ANOVA satu arah memiliki hipotesis nol dan hipotesis alternatif berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>H <sub>0<\/sub> (hipotesis nol):<\/strong> semua mean kelompok adalah sama.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>H <sub>A<\/sub> (hipotesis alternatif):<\/strong> Setidaknya satu mean kelompok berbeda <sub>&nbsp;<\/sub> istirahat.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Karena nilai p pada tabel ANOVA (0,1138) tidak kurang dari 0,05, kami tidak memiliki cukup bukti untuk menolak hipotesis nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan demikian, kami tidak memiliki bukti bahwa ketiga metode penelitian yang berbeda menghasilkan hasil pemeriksaan yang berbeda.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/anova-satu-arah-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Bagaimana Melakukan ANOVA Satu Arah di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/one-way-anova-ala-main\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara melakukan ANOVA satu arah secara manual<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kalkulator-danova-satu-arah\/\" target=\"_blank\" rel=\"noopener noreferrer\">Kalkulator ANOVA satu arah<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ANOVA satu arah digunakan untuk menentukan apakah terdapat perbedaan yang signifikan secara statistik antara rata-rata tiga atau lebih kelompok independen. Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan ANOVA satu arah di Google Spreadsheet. Langkah 1: Instal XLMiner Analysis ToolPak Untuk melakukan ANOVA satu arah di Google Sheets, pertama-tama kita perlu menginstal XLMiner [&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>ANOVA satu arah di Google Spreadsheet (langkah demi langkah) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan ANOVA satu arah di Google Spreadsheet, 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\/lembar-google-anova-satu-arah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ANOVA satu arah di Google Spreadsheet (langkah demi langkah) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan ANOVA satu arah di Google Spreadsheet, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T06:19:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles0.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\/lembar-google-anova-satu-arah\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/\",\"name\":\"ANOVA satu arah di Google Spreadsheet (langkah demi langkah) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T06:19:26+00:00\",\"dateModified\":\"2023-07-27T06:19:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan ANOVA satu arah di Google Spreadsheet, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Anova satu arah di google spreadsheet (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":"ANOVA satu arah di Google Spreadsheet (langkah demi langkah) \u2013 Statologi","description":"Tutorial ini menjelaskan cara melakukan ANOVA satu arah di Google Spreadsheet, 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\/lembar-google-anova-satu-arah\/","og_locale":"id_ID","og_type":"article","og_title":"ANOVA satu arah di Google Spreadsheet (langkah demi langkah) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara melakukan ANOVA satu arah di Google Spreadsheet, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/","og_site_name":"Statorials","article_published_time":"2023-07-27T06:19:26+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/onewayanovafeuilles0.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\/lembar-google-anova-satu-arah\/","url":"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/","name":"ANOVA satu arah di Google Spreadsheet (langkah demi langkah) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T06:19:26+00:00","dateModified":"2023-07-27T06:19:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan ANOVA satu arah di Google Spreadsheet, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-google-anova-satu-arah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Anova satu arah di google spreadsheet (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\/1218"}],"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=1218"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1218\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}