{"id":1219,"date":"2023-07-27T06:13:55","date_gmt":"2023-07-27T06:13:55","guid":{"rendered":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/"},"modified":"2023-07-27T06:13:55","modified_gmt":"2023-07-27T06:13:55","slug":"pengukuran-berulang-anova-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/","title":{"rendered":"Pengukuran berulang anova 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-pengukuran-berulang\/\" target=\"_blank\" rel=\"noopener noreferrer\">ANOVA pengukuran berulang<\/a> digunakan untuk menentukan apakah terdapat perbedaan yang signifikan secara statistik antara rata-rata tiga kelompok atau lebih di mana subjek yang sama muncul di setiap kelompok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan ANOVA pengukuran berulang 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 pengukuran berulang ANOVA.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, katakanlah peneliti ingin mengetahui apakah empat obat berbeda menyebabkan waktu reaksi berbeda. Untuk mengujinya, mereka mengukur waktu reaksi lima pasien terhadap empat obat berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Waktu reaksi ditunjukkan di bawah ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12059 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/repete1.png\" alt=\"\" width=\"522\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 3: Lakukan tindakan berulang ANOVA<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk melakukan pengukuran ANOVA berulang 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: dua faktor tanpa replikasi<\/strong> dan isi informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12060 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/repete2.png\" alt=\"Pengukuran Berulang ANOVA di Google Spreadsheet\" width=\"671\" height=\"317\" 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 pengukuran ANOVA yang diulang akan muncul mulai dari sel yang Anda tentukan di <strong>Rentang Output<\/strong> . Dalam kasus kami, kami memilih untuk menampilkan hasilnya mulai dari sel A8:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-12061 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/repete3.png\" alt=\"Pengukuran berulang keluaran ANOVA di Google Spreadsheet\" width=\"668\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dalam hal ini, kami tidak tertarik pada hasil baris, namun hanya pada kolom, yang menunjukkan variasi waktu respons bergantung pada obat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya, kita dapat melihat bahwa statistik uji F adalah <strong>24,75887<\/strong> dan nilai p yang sesuai adalah <strong>0,0000199<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena nilai p ini kurang dari 0,05, kami menolak hipotesis nol dan menyimpulkan bahwa terdapat perbedaan yang signifikan secara statistik dalam waktu respons rata-rata antara keempat obat.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Melakukan ANOVA Pengukuran Berulang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/anova-mengulangi-pengukuran-dengan-tangan\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Melakukan ANOVA Pengukuran Berulang Secara Manual<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kalkulator-pengukuran-berulang-satu-arah-anova\/\" target=\"_blank\" rel=\"noopener noreferrer\">Kalkulator ANOVA Pengukuran Berulang Satu Arah<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ANOVA pengukuran berulang digunakan untuk menentukan apakah terdapat perbedaan yang signifikan secara statistik antara rata-rata tiga kelompok atau lebih di mana subjek yang sama muncul di setiap kelompok. Tutorial ini memberikan contoh langkah demi langkah tentang cara melakukan ANOVA pengukuran berulang di Google Spreadsheet. Langkah 1: Instal XLMiner Analysis ToolPak Untuk melakukan ANOVA satu arah [&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>Pengukuran Berulang ANOVA di Google Spreadsheet (Langkah demi Langkah)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan ANOVA pengukuran berulang di Google Spreadsheet, 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\/pengukuran-berulang-anova-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pengukuran Berulang ANOVA di Google Spreadsheet (Langkah demi Langkah)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan ANOVA pengukuran berulang di Google Spreadsheet, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T06:13:55+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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/\",\"name\":\"Pengukuran Berulang ANOVA di Google Spreadsheet (Langkah demi Langkah)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T06:13:55+00:00\",\"dateModified\":\"2023-07-27T06:13:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan ANOVA pengukuran berulang di Google Spreadsheet, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pengukuran berulang anova 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":"Pengukuran Berulang ANOVA di Google Spreadsheet (Langkah demi Langkah)","description":"Tutorial ini menjelaskan cara melakukan ANOVA pengukuran berulang di Google Spreadsheet, 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\/pengukuran-berulang-anova-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Pengukuran Berulang ANOVA di Google Spreadsheet (Langkah demi Langkah)","og_description":"Tutorial ini menjelaskan cara melakukan ANOVA pengukuran berulang di Google Spreadsheet, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-27T06:13:55+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":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/","url":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/","name":"Pengukuran Berulang ANOVA di Google Spreadsheet (Langkah demi Langkah)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T06:13:55+00:00","dateModified":"2023-07-27T06:13:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan ANOVA pengukuran berulang di Google Spreadsheet, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pengukuran-berulang-anova-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pengukuran berulang anova 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\/1219"}],"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=1219"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1219\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}