Tek y\u00f6nl\u00fc ANOVA’n\u0131n sonu\u00e7lar\u0131n\u0131 yorumlarken grup ortalamalar\u0131 aras\u0131ndaki fark\u0131 g\u00f6rselle\u015ftirmek i\u00e7in bir grafik olu\u015fturmak yararl\u0131 olabilir.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, tek y\u00f6nl\u00fc ANOVA’n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ve sonu\u00e7lar\u0131n Excel’de grafi\u011finin nas\u0131l \u00e7izilece\u011fini g\u00f6sterir.<\/span><\/p>\n Bir profes\u00f6r\u00fcn s\u0131n\u0131f\u0131ndaki 30 \u00f6\u011frenciden rastgele bir s\u0131nava haz\u0131rlanmak i\u00e7in \u00fc\u00e7 \u00e7al\u0131\u015fma y\u00f6nteminden birini kullanmalar\u0131n\u0131 istedi\u011fini<\/a> varsayal\u0131m.<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc \u00f6\u011frencilerin kulland\u0131klar\u0131 y\u00f6nteme g\u00f6re ald\u0131klar\u0131 puanlar\u0131 g\u00f6stermektedir:<\/span> <\/p>\n Profes\u00f6r\u00fcn 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 yapmak istedi\u011fini varsayal\u0131m.<\/span><\/p>\n Excel’de tek y\u00f6nl\u00fc ANOVA ger\u00e7ekle\u015ftirmek i\u00e7in \u00fcst \u015feritteki Veri<\/strong> sekmesine t\u0131klay\u0131n ve ard\u0131ndan Analiz<\/strong> grubunda Veri Analizi’ne<\/strong> 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><\/p>\n G\u00f6r\u00fcnt\u00fclenen yeni panelde Anova: Single Factor’a<\/strong> ve ard\u0131ndan Tamam’a<\/strong> t\u0131klay\u0131n.<\/span><\/p>\n A\u00e7\u0131lan yeni pencerede a\u015fa\u011f\u0131daki bilgileri girin:<\/span> <\/p>\n Tamam’a<\/strong> t\u0131klad\u0131\u011f\u0131n\u0131zda tek y\u00f6nl\u00fc ANOVA sonu\u00e7lar\u0131 g\u00f6r\u00fcnecektir:<\/span> <\/p>\n \u00c7\u0131kt\u0131daki en b\u00fcy\u00fck de\u011fer, 0,002266<\/strong> olarak ortaya \u00e7\u0131kan p de\u011feridir<\/a> .<\/span><\/p>\n Tek y\u00f6nl\u00fc bir ANOVA’n\u0131n a\u015fa\u011f\u0131daki bo\u015f ve alternatif hipotezleri kulland\u0131\u011f\u0131n\u0131 hat\u0131rlay\u0131n:<\/span><\/p>\n P de\u011feri \u03b1 = 0,05’ten k\u00fc\u00e7\u00fck oldu\u011fundan s\u0131f\u0131r hipotezini reddediyoruz ve t\u00fcm grup ortalamalar\u0131n\u0131n e\u015fit olmad\u0131\u011f\u0131 sonucuna var\u0131yoruz.<\/span><\/p>\n Bu, \u00fc\u00e7 \u00e7al\u0131\u015fma y\u00f6nteminin hepsinin ayn\u0131 ortalama s\u0131nav notlar\u0131na yol a\u00e7mad\u0131\u011f\u0131 anlam\u0131na gelir.<\/span><\/p>\n Bu ANOVA sonu\u00e7lar\u0131n\u0131 g\u00f6rselle\u015ftirmek i\u00e7in her \u00e7al\u0131\u015fma y\u00f6ntemi i\u00e7in s\u0131nav sonu\u00e7lar\u0131n\u0131n da\u011f\u0131l\u0131m\u0131n\u0131 g\u00f6steren grupland\u0131r\u0131lm\u0131\u015f kutu grafikleri olu\u015fturabiliriz.<\/span><\/p>\n Bunu yapmak i\u00e7in A2:C11<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n, ard\u0131ndan \u00fcst \u015feritteki Ekle<\/strong> sekmesine t\u0131klay\u0131n, ard\u0131ndan Grafikler<\/strong> grubundaki Kutu ve B\u0131y\u0131k<\/strong> simgesine t\u0131klay\u0131n:<\/span><\/p>\n A\u015fa\u011f\u0131daki tablo g\u00f6r\u00fcnecektir:<\/span><\/p>\n Bu grafi\u011fin okunmas\u0131n\u0131 kolayla\u015ft\u0131rmak i\u00e7in Y ekseni aral\u0131\u011f\u0131n\u0131 de\u011fi\u015ftirmekten ve bir a\u00e7\u0131klama eklemekten \u00e7ekinmeyin:<\/span><\/p>\n Kutu grafiklerinin her biri, her \u00e7al\u0131\u015fma y\u00f6ntemi i\u00e7in inceleme sonu\u00e7lar\u0131n\u0131n da\u011f\u0131l\u0131m\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Her kutu grafi\u011finin ortas\u0131ndaki \u00e7izgi, her \u00e7al\u0131\u015fma y\u00f6ntemi i\u00e7in medyan s\u0131nav puan\u0131n\u0131 temsil eder ve k\u00fc\u00e7\u00fck “x” ortalama s\u0131nav puan\u0131n\u0131 temsil eder.<\/span><\/p>\n ANOVA tablosunun sonu\u00e7lar\u0131na bakmadan bile, \u00e7al\u0131\u015fma y\u00f6ntemi 3’\u00fcn ortalama s\u0131nav puan\u0131n\u0131n di\u011fer iki \u00e7al\u0131\u015fma y\u00f6ntemine g\u00f6re \u00f6nemli \u00f6l\u00e7\u00fcde daha y\u00fcksek oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n ANOVA tablosundaki p de\u011ferinin istatistiksel olarak neden anlaml\u0131 oldu\u011funu da g\u00f6rebiliriz: \u00fc\u00e7 \u00e7al\u0131\u015fma y\u00f6nteminin ayn\u0131 ortalama de\u011fere sahip olmad\u0131\u011f\u0131 a\u00e7\u0131kt\u0131r.<\/span><\/p>\n Bu \u00fc\u00e7 kutu grafi\u011fini olu\u015fturarak tek y\u00f6nl\u00fc ANOVA’m\u0131z\u0131n sonu\u00e7lar\u0131n\u0131 daha iyi anlayabiliyoruz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel’de Tek Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir<\/a> \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 kullan\u0131l\u0131r. Tek y\u00f6nl\u00fc ANOVA’n\u0131n sonu\u00e7lar\u0131n\u0131 yorumlarken grup ortalamalar\u0131 aras\u0131ndaki fark\u0131 g\u00f6rselle\u015ftirmek i\u00e7in bir grafik olu\u015fturmak yararl\u0131 olabilir. A\u015fa\u011f\u0131daki \u00f6rnek, tek y\u00f6nl\u00fc ANOVA’n\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ve sonu\u00e7lar\u0131n Excel’de grafi\u011finin nas\u0131l \u00e7izilece\u011fini g\u00f6sterir. \u00d6rnek: Excel’de ANOVA Sonu\u00e7lar\u0131n\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-5133","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n \u00d6rnek: Excel’de ANOVA Sonu\u00e7lar\u0131n\u0131n Grafi\u011fi Nas\u0131l \u00c7izilir?<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpreteranova0.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/boite-a-outils.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpreteranova1.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/interpreteranova2.png\")
<\/p>\n\n
Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel’de \u0130ki Y\u00f6nl\u00fc ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir<\/a>
Excel’de Tekrarlanan \u00d6l\u00e7\u00fcmler ANOVA Nas\u0131l Ger\u00e7ekle\u015ftirilir<\/a>
Excel’de Tukey-Kramer Post Hoc Testi Nas\u0131l Ger\u00e7ekle\u015ftirilir<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"