{"id":441,"date":"2023-07-29T22:35:10","date_gmt":"2023-07-29T22:35:10","guid":{"rendered":"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/"},"modified":"2023-07-29T22:35:10","modified_gmt":"2023-07-29T22:35:10","slug":"tek-yonlu-anova-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/","title":{"rendered":"Excel'de tek y\u00f6nl\u00fc anova nas\u0131l ger\u00e7ekle\u015ftirilir"},"content":{"rendered":"

<\/p>\n

\n

\u00dc\u00e7 veya daha fazla ba\u011f\u0131ms\u0131z grubun ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in tek y\u00f6nl\u00fc ANOVA<\/a> (“varyans analizi”) kullan\u0131l\u0131r.<\/span><\/p>\n

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

\u00d6rnek: Excel’de Tek Y\u00f6nl\u00fc ANOVA<\/span><\/strong><\/h3>\n

Bir ara\u015ft\u0131rmac\u0131n\u0131n bir \u00e7al\u0131\u015fmaya kat\u0131lmak \u00fczere 30 \u00f6\u011frenciyi i\u015fe ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. \u00d6\u011frenciler, bir s\u0131nava haz\u0131rlanmak i\u00e7in \u00f6n\u00fcm\u00fczdeki \u00fc\u00e7 hafta boyunca \u00fc\u00e7 \u00e7al\u0131\u015fma tekni\u011finden birini kullanmak \u00fczere rastgele atan\u0131r. \u00dc\u00e7 haftan\u0131n sonunda t\u00fcm \u00f6\u011frenciler ayn\u0131 s\u0131nava girerler.<\/span><\/p>\n

\u00d6\u011frenci test sonu\u00e7lar\u0131 a\u015fa\u011f\u0131da g\u00f6sterilmektedir:<\/span> <\/p>\n

\"Excel'deki
Ara\u015ft\u0131rmac\u0131, ortalama puanlar\u0131n \u00fc\u00e7 grup aras\u0131nda ayn\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in tek y\u00f6nl\u00fc bir ANOVA ger\u00e7ekle\u015ftirmek istiyor.<\/span><\/p>\n

Excel’de tek y\u00f6nl\u00fc ANOVA ger\u00e7ekle\u015ftirmek i\u00e7in Veri<\/strong> sekmesine gidin ve ard\u0131ndan Analiz<\/strong> grubundaki Veri Analizi<\/strong> se\u00e7ene\u011fine t\u0131klay\u0131n.<\/span><\/p>\n

Veri Analizi<\/strong> se\u00e7ene\u011fini g\u00f6remiyorsan\u0131z<\/span> ,<\/span><\/strong> \u00f6ncelikle \u00fccretsiz Analiz Ara\u00e7 Paketi<\/a> yaz\u0131l\u0131m\u0131n\u0131 y\u00fcklemelisiniz<\/strong> .<\/span><\/em> <\/p>\n

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

\u00dczerine t\u0131klad\u0131\u011f\u0131n\u0131zda, farkl\u0131 tarama arac\u0131 se\u00e7eneklerinin bulundu\u011fu bir pencere a\u00e7\u0131lacakt\u0131r. Anova: Tek Fakt\u00f6r’\u00fc<\/strong> se\u00e7in ve ard\u0131ndan Tamam’a<\/strong> t\u0131klay\u0131n.<\/span> <\/p>\n

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

Giri\u015f aral\u0131\u011f\u0131n\u0131<\/strong> soran yeni bir pencere a\u00e7\u0131l\u0131r. Verilerinizin etraf\u0131na bir kutu s\u00fcr\u00fckleyebilir veya veri aral\u0131\u011f\u0131n\u0131 manuel olarak girebilirsiniz. Bu durumda verilerimiz C4:E13<\/strong> h\u00fccrelerindedir.<\/span><\/p>\n

Daha sonra test i\u00e7in bir Alfa<\/strong> d\u00fczeyi se\u00e7in. Varsay\u0131lan olarak bu say\u0131 0,05’tir. Bu durumda 0,05’te b\u0131rakaca\u011f\u0131m.<\/span><\/p>\n

Son olarak, tek y\u00f6nl\u00fc ANOVA sonu\u00e7lar\u0131n\u0131n g\u00f6r\u00fcnece\u011fi \u00c7\u0131k\u0131\u015f Aral\u0131\u011f\u0131<\/strong> i\u00e7in bir h\u00fccre se\u00e7in. Bu durumda G4<\/strong> h\u00fccresini se\u00e7iyorum.<\/span> <\/p>\n

\"Excel'de
Tamam’a<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda tek y\u00f6nl\u00fc ANOVA sonucu g\u00f6r\u00fcnecektir:<\/span> <\/p>\n

\"Excel'de
Sonucun yorumlanmas\u0131<\/span><\/strong><\/h2>\n

\u00c7\u0131kt\u0131da iki tablo g\u00f6r\u00fcnt\u00fclenir. Birincisi, her gruptaki test puanlar\u0131n\u0131n say\u0131s\u0131n\u0131, test puanlar\u0131n\u0131n toplam\u0131n\u0131, test puanlar\u0131n\u0131n ortalamas\u0131n\u0131 ve test puanlar\u0131n\u0131n varyans\u0131n\u0131 g\u00f6steren bir \u00f6zet tablodur.<\/span> <\/p>\n

\"Excel<\/p>\n

\u00dc\u00e7 veya daha fazla grubun ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in tek y\u00f6nl\u00fc ANOVA’n\u0131n kullan\u0131ld\u0131\u011f\u0131n\u0131 hat\u0131rlay\u0131n.<\/span><\/p>\n

Bu ilk tablodan \u00fc\u00e7 grubun her birinin ortalama puan\u0131n\u0131n farkl\u0131 oldu\u011funu g\u00f6rebiliriz ancak bu farkl\u0131l\u0131klar\u0131n istatistiksel olarak anlaml\u0131 olup olmad\u0131\u011f\u0131n\u0131 bilmek i\u00e7in ikinci tabloya bakmam\u0131z gerekir.<\/span><\/p>\n

\u0130kinci tablo F testi istatisti\u011fini, kritik F de\u011ferini ve p de\u011ferini g\u00f6sterir:<\/span> <\/p>\n

\"Excel'de
Bu durumda F test istatisti\u011fi<\/strong> 2,3575<\/strong> ve F’nin kritik de\u011feri<\/strong> 3,3541<\/strong> olur. F testi istatisti\u011fi, F’nin kritik de\u011ferinden k\u00fc\u00e7\u00fck oldu\u011fundan, \u00fc\u00e7 grubun ortalamalar\u0131n\u0131n e\u015fit oldu\u011funu belirten s\u0131f\u0131r hipotezini reddetmek i\u00e7in yeterli kan\u0131t\u0131m\u0131z yok.<\/span><\/p>\n

Bu, \u00fc\u00e7 \u00e7al\u0131\u015fma tekni\u011fi aras\u0131nda test sonu\u00e7lar\u0131nda farkl\u0131l\u0131k oldu\u011funu s\u00f6ylemek i\u00e7in yeterli kan\u0131ta sahip olmad\u0131\u011f\u0131m\u0131z anlam\u0131na gelir.<\/span><\/p>\n

Ayn\u0131 sonuca ula\u015fmak i\u00e7in p de\u011ferini<\/a> de kullanabiliriz. Bu durumda p de\u011feri<\/strong> 0,1138<\/strong> olup alfa d\u00fczeyi olan 0,05’ten<\/strong> y\u00fcksektir.<\/span><\/p>\n

Bu, \u00fc\u00e7 grubun ortalamalar\u0131n\u0131n e\u015fit oldu\u011funu belirten s\u0131f\u0131r hipotezini reddetmek i\u00e7in yeterli kan\u0131t\u0131m\u0131z olmad\u0131\u011f\u0131 anlam\u0131na gelir.<\/span><\/p>\n

Not:<\/strong> S\u0131f\u0131r hipotezini reddetti\u011finiz durumlarda, tam olarak hangi grup ortalamalar\u0131n\u0131n farkl\u0131 oldu\u011funu belirlemek i\u00e7in bir Tukey-Kramer post hoc testi<\/a> ger\u00e7ekle\u015ftirebilirsiniz.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u00dc\u00e7 veya daha fazla ba\u011f\u0131ms\u0131z grubun ortalamalar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in tek y\u00f6nl\u00fc ANOVA (“varyans analizi”) kullan\u0131l\u0131r. Bu e\u011fitimde Excel’de tek y\u00f6nl\u00fc ANOVA’n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r. \u00d6rnek: Excel’de Tek Y\u00f6nl\u00fc ANOVA Bir ara\u015ft\u0131rmac\u0131n\u0131n bir \u00e7al\u0131\u015fmaya kat\u0131lmak \u00fczere 30 \u00f6\u011frenciyi i\u015fe ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. \u00d6\u011frenciler, bir s\u0131nava haz\u0131rlanmak i\u00e7in \u00f6n\u00fcm\u00fczdeki \u00fc\u00e7 […]<\/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-441","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde Excel'de tek y\u00f6nl\u00fc ANOVA'n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tek-yonlu-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 Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde Excel'de tek y\u00f6nl\u00fc ANOVA'n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T22:35:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/anova1.jpg\" \/>\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\/tek-yonlu-anova-excel\/\",\"url\":\"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/\",\"name\":\"Excel'de Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T22:35:10+00:00\",\"dateModified\":\"2023-07-29T22:35:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde Excel'de tek y\u00f6nl\u00fc ANOVA'n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de tek y\u00f6nl\u00fc 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 Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials","description":"Bu e\u011fitimde Excel'de tek y\u00f6nl\u00fc ANOVA'n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","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\/tek-yonlu-anova-excel\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials","og_description":"Bu e\u011fitimde Excel'de tek y\u00f6nl\u00fc ANOVA'n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-29T22:35:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/anova1.jpg"}],"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\/tek-yonlu-anova-excel\/","url":"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/","name":"Excel'de Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T22:35:10+00:00","dateModified":"2023-07-29T22:35:10+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde Excel'de tek y\u00f6nl\u00fc ANOVA'n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/tek-yonlu-anova-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de tek y\u00f6nl\u00fc 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\/441","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=441"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/441\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}