{"id":445,"date":"2023-07-29T22:11:10","date_gmt":"2023-07-29T22:11:10","guid":{"rendered":"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/"},"modified":"2023-07-29T22:11:10","modified_gmt":"2023-07-29T22:11:10","slug":"tes-mcnemars-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/","title":{"rendered":"Cara melakukan tes mcnemar di excel"},"content":{"rendered":"<p class=\"has-text-color\" style=\"color: #000000;\"><strong>Catatan:<\/strong> Tes ini dapat digunakan ketika subjek yang <em>sama<\/em> muncul pada kelompok kontrol dan kelompok perlakuan.<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Tutorial ini memperlihatkan cara melakukan tes McNemar di Excel.<\/p>\n<h3 class=\"wp-block-heading\"> <strong>Tes Mcnemar di Excel<\/strong><\/h3>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Misalkan peneliti mensurvei 100 orang tentang suatu undang-undang tertentu dan menemukan bahwa 30 di antara mereka mendukung undang-undang tersebut sementara 70 orang menentangnya. Para peneliti kemudian menunjukkan kepada kelompok yang terdiri dari 100 orang ini sebuah video tentang manfaat finansial dari undang-undang tersebut dan mengulangi surveinya. Kali ini, 12 orang beralih dari mendukung menjadi menentang undang-undang, dan 14 orang beralih dari menentang menjadi mendukung undang-undang.<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>Lakukan tes McNemar untuk menentukan apakah video ini berdampak signifikan terhadap opini orang.<\/strong><\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Pertama, nyatakan hipotesis nol dan hipotesis alternatif dari pengujian tersebut:<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>H<\/strong> <sub><strong>0<\/strong><\/sub> (hipotesis nol) = Video tidak berdampak pada opini orang<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>H<\/strong> <sub><strong>A<\/strong><\/sub> (hipotesis alternatif) = Video mempunyai pengaruh yang signifikan terhadap opini masyarakat<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Selanjutnya, identifikasi hal-hal berikut:<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>A<\/strong> = #Orang yang tadinya mendukung menjadi menentang hukum : 12<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <strong>B<\/strong> = # Orang yang berpindah dari oposisi menjadi mendukung hukum: 14<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> <sup><strong>Statistik<\/strong><\/sup> <strong>pengujian<\/strong> <strong>_<\/strong><\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Statistik uji ini mengikuti distribusi X <sup>2<\/sup> dengan satu derajat kebebasan. Berdasarkan tabel distribusi chi-kuadrat, X <sup>2<\/sup> <sub>(0,05, 1)<\/sub> = <strong>3,841<\/strong> .<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Karena statistik pengujian kami kurang dari 3.841, kami gagal menolak hipotesis nol. Kami tidak memiliki cukup bukti untuk mengatakan bahwa video tersebut berdampak signifikan terhadap opini masyarakat.<\/p>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Untuk melakukan tes McNemar ini di Excel, cukup gunakan rumus berikut: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><\/figure>\n<\/div>\n<p class=\"has-text-color\" style=\"color: #000000;\"> Ini memberikan jawaban yang sama seperti di atas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Catatan: Tes ini dapat digunakan ketika subjek yang sama muncul pada kelompok kontrol dan kelompok perlakuan. Tutorial ini memperlihatkan cara melakukan tes McNemar di Excel. Tes Mcnemar di Excel Misalkan peneliti mensurvei 100 orang tentang suatu undang-undang tertentu dan menemukan bahwa 30 di antara mereka mendukung undang-undang tersebut sementara 70 orang menentangnya. Para peneliti kemudian [&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 Tes McNemar di Excel \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara melakukan tes McNemar di Excel.\" \/>\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\/tes-mcnemars-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Tes McNemar di Excel \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara melakukan tes McNemar di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T22:11:10+00:00\" \/>\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\/tes-mcnemars-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/\",\"name\":\"Cara Melakukan Tes McNemar di Excel \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-29T22:11:10+00:00\",\"dateModified\":\"2023-07-29T22:11:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara melakukan tes McNemar di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan tes mcnemar 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 Tes McNemar di Excel \u2013 Statorials","description":"Penjelasan sederhana tentang cara melakukan tes McNemar di Excel.","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\/tes-mcnemars-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Tes McNemar di Excel \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara melakukan tes McNemar di Excel.","og_url":"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T22:11:10+00:00","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\/tes-mcnemars-excel\/","url":"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/","name":"Cara Melakukan Tes McNemar di Excel \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-29T22:11:10+00:00","dateModified":"2023-07-29T22:11:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara melakukan tes McNemar di Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tes-mcnemars-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tes-mcnemars-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan tes mcnemar 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\/445"}],"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=445"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/445\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}