{"id":664,"date":"2023-07-29T04:15:54","date_gmt":"2023-07-29T04:15:54","guid":{"rendered":"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/"},"modified":"2023-07-29T04:15:54","modified_gmt":"2023-07-29T04:15:54","slug":"kruskal-wallis-excel-testi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/","title":{"rendered":"Excel'de kruskal-wallis testi nas\u0131l yap\u0131l\u0131r"},"content":{"rendered":"

<\/p>\n

\n

\u00dc\u00e7 veya daha fazla ba\u011f\u0131ms\u0131z grubun medyanlar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in Kruskal-Wallis testi<\/a> kullan\u0131l\u0131r. Tek y\u00f6nl\u00fc ANOVA’n\u0131n parametrik olmayan e\u015fde\u011feri olarak kabul edilir.<\/span><\/p>\n

Bu e\u011fitimde Excel’de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n

\u00d6rnek: Excel’de Kruskal-Wallis testi<\/strong><\/span><\/h3>\n

Ara\u015ft\u0131rmac\u0131lar, \u00fc\u00e7 farkl\u0131 g\u00fcbrenin farkl\u0131 bitki b\u00fcy\u00fcmesi d\u00fczeylerine yol a\u00e7\u0131p a\u00e7mad\u0131\u011f\u0131n\u0131 bilmek istiyorlar. Rastgele 30 farkl\u0131 bitki se\u00e7iyorlar ve bunlar\u0131 10’arl\u0131 \u00fc\u00e7 gruba ay\u0131r\u0131yorlar ve her gruba farkl\u0131 bir g\u00fcbre uyguluyorlar. Bir ay sonra her bitkinin y\u00fcksekli\u011fini \u00f6l\u00e7\u00fcyorlar.<\/span><\/p>\n

Medyan b\u00fcy\u00fcmenin \u00fc\u00e7 grupta da ayn\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek amac\u0131yla Kruskal-Wallis testi ger\u00e7ekle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin.<\/span><\/p>\n

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

Her gruptaki 10 bitkinin her birinin toplam b\u00fcy\u00fcmesini (in\u00e7 cinsinden) g\u00f6steren a\u015fa\u011f\u0131daki verileri girin:<\/span> <\/p>\n

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

Ad\u0131m 2: Verileri s\u0131n\u0131fland\u0131r\u0131n.<\/span><\/strong><\/p>\n

Daha sonra, 30 bitki aras\u0131nda her bitkinin b\u00fcy\u00fcmesine bir s\u0131ralama atamak i\u00e7in RANK.AVG()<\/strong> fonksiyonunu kullanaca\u011f\u0131z. A\u015fa\u011f\u0131daki form\u00fcl, birinci gruptaki ilk bitkinin s\u0131ralamas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n

\"\"<\/p>\n

Bu form\u00fcl\u00fc h\u00fccrelerin geri kalan\u0131na kopyalay\u0131n:<\/span> <\/p>\n

\"\"<\/p>\n

Daha sonra, her bir s\u00fctun i\u00e7in s\u0131ralar\u0131n toplam\u0131n\u0131, \u00f6rnek boyutu ve s\u0131ralar\u0131n kare toplam\u0131n\u0131n \u00f6rnek boyutuna b\u00f6l\u00fcnmesiyle birlikte hesaplay\u0131n:<\/span> <\/p>\n

\"\"<\/p>\n

Ad\u0131m 3: Test istatisti\u011fini ve kar\u015f\u0131l\u0131k gelen p de\u011ferini hesaplay\u0131n.<\/strong><\/span><\/p>\n

Test istatisti\u011fi \u015fu \u015fekilde tan\u0131mlan\u0131r:<\/span><\/p>\n

H = 12\/(n(n+1)) * \u03a3R j<\/sub> 2<\/sup> \/n j<\/sub> \u2013 3(n+1)<\/span><\/p>\n

Alt\u0131n:<\/span><\/p>\n

    \n
  • n = toplam \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc<\/span><\/li>\n
  • R j<\/sub> 2<\/sup> = j’inci<\/sup> grup i\u00e7in s\u0131ralar\u0131n toplam\u0131<\/span><\/li>\n
  • n j<\/sub> = j’inci<\/sup> grubun \u00f6rneklem b\u00fcy\u00fckl\u00fc\u011f\u00fc<\/span><\/li>\n<\/ul>\n

    S\u0131f\u0131r hipotezi alt\u0131nda H, k-1 serbestlik derecesine sahip bir Ki-kare da\u011f\u0131l\u0131m\u0131n\u0131 takip eder.<\/span><\/p>\n

    A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc test istatisti\u011fini, H’yi ve kar\u015f\u0131l\u0131k gelen p de\u011ferini hesaplamak i\u00e7in kullan\u0131lan form\u00fclleri g\u00f6sterir:<\/span><\/p>\n

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

    Test istatisti\u011fi H = 6,204’t\u00fcr<\/strong> ve kar\u015f\u0131l\u0131k gelen p de\u011feri p = 0,045’tir<\/strong> . Bu p de\u011feri 0,05’ten k\u00fc\u00e7\u00fck oldu\u011fundan, ortalama bitki b\u00fcy\u00fcmesinin her \u00fc\u00e7 g\u00fcbre i\u00e7in de ayn\u0131 oldu\u011fu \u015feklindeki s\u0131f\u0131r hipotezini reddedebiliriz. Kullan\u0131lan g\u00fcbre t\u00fcr\u00fcn\u00fcn bitki b\u00fcy\u00fcmesinde istatistiksel olarak anlaml\u0131 farkl\u0131l\u0131klara neden oldu\u011fu sonucuna varmak i\u00e7in yeterli kan\u0131t\u0131m\u0131z var.<\/span><\/p>\n

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

    Son olarak Kruskal-Wallis testinin sonu\u00e7lar\u0131n\u0131 bildirmek istiyoruz. \u0130\u015fte bunun nas\u0131l yap\u0131laca\u011f\u0131na dair bir \u00f6rnek:<\/span><\/p>\n

    \n

    Ortalama bitki b\u00fcy\u00fcmesinin \u00fc\u00e7 farkl\u0131 bitki g\u00fcbresi i\u00e7in ayn\u0131 olup olmad\u0131\u011f\u0131n\u0131 belirlemek amac\u0131yla Kruskal-Wallist testi yap\u0131ld\u0131. Analizde toplam 30 bitki kullan\u0131ld\u0131. Her g\u00fcbre 10 farkl\u0131 bitkiye uyguland\u0131.<\/span><\/p>\n

    Test, \u00fc\u00e7 g\u00fcbre aras\u0131nda ortalama bitki b\u00fcy\u00fcmesinin ayn\u0131 olmad\u0131\u011f\u0131n\u0131 (H = 6,204, p = 0,045) ortaya \u00e7\u0131kard\u0131. Yani, iki veya daha fazla g\u00fcbre aras\u0131nda ortalama bitki b\u00fcy\u00fcmesi a\u00e7\u0131s\u0131ndan istatistiksel olarak anlaml\u0131 bir fark vard\u0131.<\/span><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

    \u00dc\u00e7 veya daha fazla ba\u011f\u0131ms\u0131z grubun medyanlar\u0131 aras\u0131nda istatistiksel olarak anlaml\u0131 bir fark olup olmad\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in Kruskal-Wallis testi kullan\u0131l\u0131r. Tek y\u00f6nl\u00fc ANOVA’n\u0131n parametrik olmayan e\u015fde\u011feri olarak kabul edilir. Bu e\u011fitimde Excel’de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r. \u00d6rnek: Excel’de Kruskal-Wallis testi Ara\u015ft\u0131rmac\u0131lar, \u00fc\u00e7 farkl\u0131 g\u00fcbrenin farkl\u0131 bitki b\u00fcy\u00fcmesi d\u00fczeylerine yol a\u00e7\u0131p a\u00e7mad\u0131\u011f\u0131n\u0131 bilmek istiyorlar. Rastgele […]<\/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-664","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Kruskal-Wallis Testi Nas\u0131l Yap\u0131l\u0131r - Statorials<\/title>\n<meta name=\"description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin 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\/kruskal-wallis-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 Kruskal-Wallis Testi Nas\u0131l Yap\u0131l\u0131r - Statorials\" \/>\n<meta property=\"og:description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T04:15:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/kruskalwallisexcel1.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\/kruskal-wallis-excel-testi\/\",\"url\":\"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/\",\"name\":\"Excel'de Kruskal-Wallis Testi Nas\u0131l Yap\u0131l\u0131r - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T04:15:54+00:00\",\"dateModified\":\"2023-07-29T04:15:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de kruskal-wallis testi nas\u0131l yap\u0131l\u0131r\"}]},{\"@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 Kruskal-Wallis Testi Nas\u0131l Yap\u0131l\u0131r - Statorials","description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin 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\/kruskal-wallis-excel-testi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Kruskal-Wallis Testi Nas\u0131l Yap\u0131l\u0131r - Statorials","og_description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/","og_site_name":"Statorials","article_published_time":"2023-07-29T04:15:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/kruskalwallisexcel1.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\/kruskal-wallis-excel-testi\/","url":"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/","name":"Excel'de Kruskal-Wallis Testi Nas\u0131l Yap\u0131l\u0131r - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T04:15:54+00:00","dateModified":"2023-07-29T04:15:54+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Kruskal-Wallis testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/kruskal-wallis-excel-testi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de kruskal-wallis testi nas\u0131l yap\u0131l\u0131r"}]},{"@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\/664","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=664"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/664\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}