{"id":779,"date":"2023-07-28T19:10:45","date_gmt":"2023-07-28T19:10:45","guid":{"rendered":"https:\/\/statorials.org\/id\/ancova-unggul\/"},"modified":"2023-07-28T19:10:45","modified_gmt":"2023-07-28T19:10:45","slug":"ancova-unggul","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ancova-unggul\/","title":{"rendered":"Cara melakukan ancova di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/teluk\/\" target=\"_blank\" rel=\"noopener noreferrer\">ANCOVA<\/a> (\u201canalisis kovarians\u201d) digunakan untuk menentukan apakah terdapat perbedaan yang signifikan secara statistik antara rata-rata tiga atau lebih kelompok independen, setelah mengendalikan satu atau lebih <a href=\"https:\/\/statorials.org\/id\/kovariat-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">kovariat<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukan ANCOVA di Excel.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: ANCOVA di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Seorang guru ingin mengetahui apakah tiga teknik belajar yang berbeda berdampak pada nilai ujian, namun dia ingin memperhitungkan nilai siswa saat ini di kelas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini akan melakukan ANCOVA menggunakan variabel berikut:<\/span><\/p>\n<ul data-slot-rendered-dynamic=\"true\">\n<li> <span style=\"color: #000000;\"><strong>Variabel faktor:<\/strong> teknis kajian<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kovariat:<\/strong> skor saat ini<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Variabel respon:<\/strong> nilai ujian<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tabel berikut menyajikan kumpulan data dari 15 siswa yang direkrut untuk berpartisipasi dalam penelitian ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8542 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/anova1.png\" alt=\"Kumpulan data ANCOVA di Excel\" width=\"460\" height=\"307\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ikuti langkah-langkah berikut untuk melakukan ANCOVA pada kumpulan data ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan data dengan format berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8548 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ancovaexcel1.png\" alt=\"Format ANCOVA di Excel\" width=\"630\" height=\"280\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung mean dan varians untuk setiap kolom.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, hitung mean dan varians untuk setiap kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8549 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ancovaexcel2.png\" alt=\"\" width=\"620\" height=\"252\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung kemiringan garis regresi.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan menghitung kemiringan garis regresi nilai ujian untuk setiap teknik pembelajaran.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em><strong>Catatan:<\/strong> Sel B21:E28 memperlihatkan rumus yang digunakan untuk memperoleh nilai di sel B13:E19.<\/em><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8553 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ancovaexcel3.png\" alt=\"\" width=\"661\" height=\"437\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 4: Lakukan ANOVA satu arah pada nilai ujian dan nilai saat ini secara terpisah.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan melakukan ANOVA satu arah pada hasil ujian:<\/span><\/p>\n<p> <em><span style=\"color: #000000;\"><b>Referensi:<\/b> <a href=\"https:\/\/statorials.org\/id\/anova-satu-arah-unggul\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara Melakukan ANOVA Satu Arah di Excel<\/a><\/span><\/em> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8554 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ancovaexcel4.png\" alt=\"\" width=\"558\" height=\"143\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, kami akan melakukan ANOVA satu arah pada peringkat saat ini:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8555 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ancovaexcel5.png\" alt=\"\" width=\"554\" height=\"111\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 5: Lengkapi tabel ANCOVA.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya kita akan mengisi tabel ANCOVA.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><em><strong>Catatan:<\/strong> Sel H39:M43 memperlihatkan rumus yang digunakan untuk memperoleh nilai di sel B39:F43.<\/em><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-8558 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ancovaexcel6-1.png\" alt=\"\" width=\"675\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Langkah 6: Interpretasikan hasilnya.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Dari tabel ANCOVA, kita melihat bahwa nilai p untuk teknik penelitian adalah <strong>0,032<\/strong> . Karena nilai ini kurang dari 0,05, kita dapat menolak hipotesis nol yang menyatakan bahwa masing-masing teknik pembelajaran menghasilkan nilai ujian rata-rata yang sama, <em>bahkan setelah memperhitungkan nilai siswa saat ini di kelas<\/em> .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ANCOVA (\u201canalisis kovarians\u201d) digunakan untuk menentukan apakah terdapat perbedaan yang signifikan secara statistik antara rata-rata tiga atau lebih kelompok independen, setelah mengendalikan satu atau lebih kovariat . Tutorial ini menjelaskan cara melakukan ANCOVA di Excel. Contoh: ANCOVA di Excel Seorang guru ingin mengetahui apakah tiga teknik belajar yang berbeda berdampak pada nilai ujian, namun dia [&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 ANCOVA di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara melakukan ANCOVA 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\/ancova-unggul\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan ANCOVA di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara melakukan ANCOVA di Excel, termasuk contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ancova-unggul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T19:10:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/anova1.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\/ancova-unggul\/\",\"url\":\"https:\/\/statorials.org\/id\/ancova-unggul\/\",\"name\":\"Cara melakukan ANCOVA di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T19:10:45+00:00\",\"dateModified\":\"2023-07-28T19:10:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara melakukan ANCOVA di Excel, termasuk contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ancova-unggul\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ancova-unggul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ancova-unggul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan ancova 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 ANCOVA di Excel - Statologi","description":"Penjelasan sederhana tentang cara melakukan ANCOVA 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\/ancova-unggul\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan ANCOVA di Excel - Statologi","og_description":"Penjelasan sederhana tentang cara melakukan ANCOVA di Excel, termasuk contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/ancova-unggul\/","og_site_name":"Statorials","article_published_time":"2023-07-28T19:10:45+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/anova1.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\/ancova-unggul\/","url":"https:\/\/statorials.org\/id\/ancova-unggul\/","name":"Cara melakukan ANCOVA di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T19:10:45+00:00","dateModified":"2023-07-28T19:10:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara melakukan ANCOVA di Excel, termasuk contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ancova-unggul\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ancova-unggul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ancova-unggul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan ancova 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\/779"}],"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=779"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/779\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=779"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=779"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}