{"id":666,"date":"2023-07-29T04:08:39","date_gmt":"2023-07-29T04:08:39","guid":{"rendered":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/"},"modified":"2023-07-29T04:08:39","modified_gmt":"2023-07-29T04:08:39","slug":"tekrarlanan-olcumler-anova-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/","title":{"rendered":"Excel'de tekrarlanan \u00f6l\u00e7\u00fcmler anova nas\u0131l ger\u00e7ekle\u015ftirilir"},"content":{"rendered":"

<\/p>\n

\n

Tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA,<\/a> her grupta ayn\u0131 deneklerin yer ald\u0131\u011f\u0131 \u00fc\u00e7 veya daha fazla grubun ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in kullan\u0131l\u0131r.<\/span><\/p>\n

Bu e\u011fitimde, Excel’de tek y\u00f6nl\u00fc tekrarlanan \u00f6l\u00e7\u00fcm ANOVA’s\u0131n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n

\u00d6rnek: Excel’de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA<\/strong><\/h3>\n

Ara\u015ft\u0131rmac\u0131lar d\u00f6rt farkl\u0131 ilac\u0131n farkl\u0131 reaksiyon s\u00fcrelerine neden olup olmad\u0131\u011f\u0131n\u0131 bilmek istiyorlar. Bunu test etmek i\u00e7in be\u015f hastan\u0131n d\u00f6rt farkl\u0131 ilaca reaksiyon s\u00fcrelerini \u00f6l\u00e7t\u00fcler. Her hasta d\u00f6rt ilac\u0131n her birinde \u00f6l\u00e7\u00fcld\u00fc\u011f\u00fc i\u00e7in, ortalama reaksiyon s\u00fcresinin ila\u00e7lar aras\u0131nda farkl\u0131l\u0131k g\u00f6sterip g\u00f6stermedi\u011fini belirlemek i\u00e7in tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA’s\u0131n\u0131 kullanaca\u011f\u0131z.<\/span><\/p>\n

Excel’de tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA’y\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 tamamlay\u0131n.<\/span><\/p>\n

Ad\u0131m 1: Verileri girin.<\/strong><\/span><\/p>\n

Be\u015f hastan\u0131n d\u00f6rt ilaca yan\u0131t verme s\u00fcresini (saniye cinsinden) g\u00f6steren a\u015fa\u011f\u0131daki verileri girin:<\/span> <\/p>\n

\"Excel'deki<\/p>\n

Ad\u0131m 2: Tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA’y\u0131 ger\u00e7ekle\u015ftirin.<\/strong><\/span><\/p>\n

Tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA’y\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in Veri<\/strong> sekmesine gidin ve Veri Analizi’ne<\/strong> t\u0131klay\u0131n. Bu se\u00e7ene\u011fi g\u00f6rm\u00fcyorsan\u0131z, \u00f6ncelikle<\/span> \u00fccretsiz Analysis ToolPak yaz\u0131l\u0131m\u0131n\u0131 y\u00fcklemelisiniz<\/a> .<\/span> <\/p>\n

\"\"<\/p>\n

Veri Analizi’ne<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda yeni bir pencere a\u00e7\u0131lacakt\u0131r. Anova: \u00e7o\u011faltma olmadan iki fakt\u00f6rl\u00fc<\/strong> se\u00e7ene\u011fini se\u00e7in ve Tamam’a t\u0131klay\u0131n.<\/span> <\/p>\n

\"Excel'de<\/p>\n

\n

Not:<\/strong><\/span><\/p>\n

Analiz Ara\u00e7 Paketi’nin tekrarlanan \u00f6l\u00e7\u00fcm ANOVA’s\u0131n\u0131 ger\u00e7ekle\u015ftirmek i\u00e7in a\u00e7\u0131k bir i\u015flevi yoktur, ancak Anova: \u00e7o\u011faltma olmadan iki y\u00f6nl\u00fc,<\/strong> sonu\u00e7ta g\u00f6rece\u011fimiz gibi arad\u0131\u011f\u0131m\u0131z sonu\u00e7lar\u0131 \u00fcretecektir.<\/span><\/p>\n<\/blockquote>\n

Giri\u015f Aral\u0131\u011f\u0131<\/strong> i\u00e7in hasta yan\u0131t s\u00fcrelerini i\u00e7eren h\u00fccre aral\u0131\u011f\u0131n\u0131 girin. Farkl\u0131 bir \u00f6nem d\u00fczeyi kullanmak istemedi\u011finiz s\u00fcrece Alfa’y\u0131<\/strong> 0,05’te b\u0131rakmaktan \u00e7ekinmeyin. \u00c7\u0131kt\u0131 Aral\u0131\u011f\u0131<\/strong> i\u00e7in sonu\u00e7lar\u0131n g\u00f6r\u00fcnmesini istedi\u011finiz h\u00fccreyi se\u00e7in. Daha sonra Tamam’\u0131<\/strong> t\u0131klay\u0131n.<\/span> <\/p>\n

\"Excel'de<\/p>\n

Sonu\u00e7lar otomatik olarak g\u00f6r\u00fcnecektir:<\/span> <\/p>\n

\"Excel'de<\/p>\n

Bu durumda sat\u0131r sonu\u00e7lar\u0131yla de\u011fil, yaln\u0131zca ilaca ba\u011fl\u0131 olarak tepki s\u00fcresindeki de\u011fi\u015fimi bize anlatan s\u00fctunlarla ilgileniyoruz.<\/span><\/p>\n

F testi istatisti\u011fi 24,75887’dir<\/strong> ve kar\u015f\u0131l\u0131k gelen p de\u011feri 0,0000199’dur<\/strong> . Bu p de\u011feri 0,05’ten k\u00fc\u00e7\u00fck oldu\u011fundan s\u0131f\u0131r hipotezini reddediyoruz ve d\u00f6rt ila\u00e7 aras\u0131ndaki ortalama yan\u0131t s\u00fcrelerinde istatistiksel olarak anlaml\u0131 bir fark oldu\u011fu sonucuna var\u0131yoruz.<\/span><\/p>\n

Ad\u0131m 3: Sonu\u00e7lar\u0131 rapor edin.<\/strong><\/span><\/p>\n

Son olarak tekrarlanan \u00f6l\u00e7\u00fcmlerimizin sonu\u00e7lar\u0131n\u0131 ANOVA olarak raporlayaca\u011f\u0131z. \u0130\u015fte bunun nas\u0131l yap\u0131laca\u011f\u0131na dair bir \u00f6rnek:<\/span><\/p>\n

\n

D\u00f6rt farkl\u0131 ilac\u0131n tepki s\u00fcresi \u00fczerindeki etkisini incelemek i\u00e7in 5 ki\u015fiye tek y\u00f6nl\u00fc tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA uyguland\u0131.<\/span><\/p>\n

Sonu\u00e7lar, kullan\u0131lan ila\u00e7 t\u00fcr\u00fcn\u00fcn yan\u0131t s\u00fcresinde istatistiksel olarak anlaml\u0131 farkl\u0131l\u0131klara yol a\u00e7t\u0131\u011f\u0131n\u0131 g\u00f6sterdi (F(3, 12) = 24,75887, p < 0,001).<\/span><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Tekrarlanan \u00f6l\u00e7\u00fcmler ANOVA, her grupta ayn\u0131 deneklerin yer ald\u0131\u011f\u0131 \u00fc\u00e7 veya daha fazla grubun ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in kullan\u0131l\u0131r. Bu e\u011fitimde, Excel’de tek y\u00f6nl\u00fc tekrarlanan \u00f6l\u00e7\u00fcm ANOVA’s\u0131n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r. \u00d6rnek: Excel’de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Ara\u015ft\u0131rmac\u0131lar d\u00f6rt farkl\u0131 ilac\u0131n farkl\u0131 reaksiyon s\u00fcrelerine neden olup olmad\u0131\u011f\u0131n\u0131 bilmek istiyorlar. Bunu […]<\/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-666","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials<\/title>\n<meta name=\"description\" content=\"Excel'de tekrarlanan \u00f6l\u00e7\u00fcm ANOVA's\u0131n\u0131n 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\/tekrarlanan-olcumler-anova-excel\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials\" \/>\n<meta property=\"og:description\" content=\"Excel'de tekrarlanan \u00f6l\u00e7\u00fcm ANOVA's\u0131n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T04:08:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/repeteanovaexcel1.png\" \/>\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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/\",\"name\":\"Excel'de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T04:08:39+00:00\",\"dateModified\":\"2023-07-29T04:08:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Excel'de tekrarlanan \u00f6l\u00e7\u00fcm ANOVA's\u0131n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de tekrarlanan \u00f6l\u00e7\u00fcmler anova 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 Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials","description":"Excel'de tekrarlanan \u00f6l\u00e7\u00fcm ANOVA's\u0131n\u0131n 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\/tekrarlanan-olcumler-anova-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials","og_description":"Excel'de tekrarlanan \u00f6l\u00e7\u00fcm ANOVA's\u0131n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T04:08:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/repeteanovaexcel1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/","url":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/","name":"Excel'de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T04:08:39+00:00","dateModified":"2023-07-29T04:08:39+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Excel'de tekrarlanan \u00f6l\u00e7\u00fcm ANOVA's\u0131n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine dair basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/tekrarlanan-olcumler-anova-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de tekrarlanan \u00f6l\u00e7\u00fcmler anova 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\/666","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=666"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/666\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}