{"id":445,"date":"2023-07-29T22:11:10","date_gmt":"2023-07-29T22:11:10","guid":{"rendered":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/"},"modified":"2023-07-29T22:11:10","modified_gmt":"2023-07-29T22:11:10","slug":"mcnemars-excel-testi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/","title":{"rendered":"Excel'de mcnemar testi nas\u0131l ger\u00e7ekle\u015ftirilir"},"content":{"rendered":"

Not:<\/strong> Bu test, ayn\u0131 deneklerin hem<\/em> kontrol grubunda hem de tedavi grubunda yer almas\u0131 durumunda kullan\u0131labilir.<\/p>\n

Bu e\u011fitimde McNemar testinin Excel’de nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi g\u00f6sterilmektedir.<\/p>\n

Excel’de Mcnemar testi<\/strong><\/h3>\n

Ara\u015ft\u0131rmac\u0131lar\u0131n belirli bir yasa hakk\u0131nda 100 ki\u015fiyle anket yapt\u0131\u011f\u0131n\u0131 ve bunlardan 30’unun yasay\u0131 destekledi\u011fini, 70’inin ise kar\u015f\u0131 \u00e7\u0131kt\u0131\u011f\u0131n\u0131 buldu\u011funu varsayal\u0131m. Ara\u015ft\u0131rmac\u0131lar daha sonra 100 ki\u015filik bu gruba yasan\u0131n mali faydalar\u0131n\u0131 anlatan bir video izletiyor ve anketi tekrarl\u0131yor. Bu kez 12 ki\u015fi yasay\u0131 desteklemekten kar\u015f\u0131 \u00e7\u0131kmaya, 14 ki\u015fi ise yasaya kar\u015f\u0131 \u00e7\u0131kmaktan destek vermeye gidiyor.<\/p>\n

Bu videonun insanlar\u0131n g\u00f6r\u00fc\u015fleri \u00fczerinde \u00f6nemli bir etkisi olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in bir McNemar testi yap\u0131n.<\/strong><\/p>\n

\u00d6ncelikle testin s\u0131f\u0131r ve alternatif hipotezini belirtin:<\/p>\n

H<\/strong> 0<\/strong><\/sub> (s\u0131f\u0131r hipotezi) = Videonun insanlar\u0131n g\u00f6r\u00fc\u015fleri \u00fczerinde hi\u00e7bir etkisi yok<\/p>\n

H<\/strong> A<\/strong><\/sub> (alternatif hipotez) = Videonun insanlar\u0131n g\u00f6r\u00fc\u015fleri \u00fczerinde \u00f6nemli bir etkisi var<\/p>\n

Daha sonra a\u015fa\u011f\u0131dakileri tan\u0131mlay\u0131n:<\/p>\n

A<\/strong> = # Kanun taraftar\u0131ndan kanuna kar\u015f\u0131 \u00e7\u0131kanlar: 12<\/p>\n

B<\/strong> = # Muhalefetten yasay\u0131 desteklemeye ge\u00e7en ki\u015filer: 14<\/p>\n

Test<\/strong> istatisti\u011fi<\/strong><\/sup> _<\/strong><\/p>\n

Bu test istatisti\u011fi bir serbestlik derecesine sahip bir X2<\/sup> da\u011f\u0131l\u0131m\u0131n\u0131 takip etmektedir. Ki-kare da\u011f\u0131l\u0131m tablosuna g\u00f6re X 2<\/sup> (0,05, 1)<\/sub> = 3,841<\/strong> .<\/p>\n

Test istatisti\u011fimiz 3.841’den k\u00fc\u00e7\u00fck oldu\u011fundan s\u0131f\u0131r hipotezini reddedemiyoruz. Videonun insanlar\u0131n g\u00f6r\u00fc\u015fleri \u00fczerinde \u00f6nemli bir etki yaratt\u0131\u011f\u0131n\u0131 s\u00f6yleyecek yeterli kan\u0131t\u0131m\u0131z yok.<\/p>\n

Bu McNemar testini Excel’de ger\u00e7ekle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fclleri kullanman\u0131z yeterlidir: <\/p>\n

\n
<\/figure>\n<\/div>\n

Bu yukar\u0131dakiyle ayn\u0131 cevaplar\u0131 verir.<\/p>\n","protected":false},"excerpt":{"rendered":"

Not: Bu test, ayn\u0131 deneklerin hem kontrol grubunda hem de tedavi grubunda yer almas\u0131 durumunda kullan\u0131labilir. Bu e\u011fitimde McNemar testinin Excel’de nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi g\u00f6sterilmektedir. Excel’de Mcnemar testi Ara\u015ft\u0131rmac\u0131lar\u0131n belirli bir yasa hakk\u0131nda 100 ki\u015fiyle anket yapt\u0131\u011f\u0131n\u0131 ve bunlardan 30’unun yasay\u0131 destekledi\u011fini, 70’inin ise kar\u015f\u0131 \u00e7\u0131kt\u0131\u011f\u0131n\u0131 buldu\u011funu varsayal\u0131m. Ara\u015ft\u0131rmac\u0131lar daha sonra 100 ki\u015filik bu gruba yasan\u0131n […]<\/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":[],"class_list":["post-445","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de McNemar Testi Nas\u0131l Yap\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Excel'de McNemar testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.\" \/>\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\/tr\/mcnemars-excel-testi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de McNemar Testi Nas\u0131l Yap\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Excel'de McNemar testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/\" \/>\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=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/\",\"url\":\"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/\",\"name\":\"Excel'de McNemar Testi Nas\u0131l Yap\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T22:11:10+00:00\",\"dateModified\":\"2023-07-29T22:11:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Excel'de McNemar testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de mcnemar testi nas\u0131l ger\u00e7ekle\u015ftirilir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de McNemar Testi Nas\u0131l Yap\u0131l\u0131r?","description":"Excel'de McNemar testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.","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\/tr\/mcnemars-excel-testi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de McNemar Testi Nas\u0131l Yap\u0131l\u0131r?","og_description":"Excel'de McNemar testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/","og_site_name":"Statorials","article_published_time":"2023-07-29T22:11:10+00:00","author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/","url":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/","name":"Excel'de McNemar Testi Nas\u0131l Yap\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T22:11:10+00:00","dateModified":"2023-07-29T22:11:10+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Excel'de McNemar testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/mcnemars-excel-testi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de mcnemar testi nas\u0131l ger\u00e7ekle\u015ftirilir"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=445"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/445\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}