{"id":663,"date":"2023-07-29T04:23:02","date_gmt":"2023-07-29T04:23:02","guid":{"rendered":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/"},"modified":"2023-07-29T04:23:02","modified_gmt":"2023-07-29T04:23:02","slug":"excelde-friedman-testi-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/","title":{"rendered":"Excel'de friedman testi nas\u0131l ger\u00e7ekle\u015ftirilir"},"content":{"rendered":"

<\/p>\n

\n

Friedman testi,<\/strong> tekrarlanan ANOVA \u00f6l\u00e7\u00fcmlerine<\/a> parametrik olmayan bir alternatiftir. 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 Friedman testinin Excel’de nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n

\u00d6rnek: Excel’deki Friedman testi<\/span><\/strong><\/h3>\n

Friedman testini Excel’de 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

\u00dc\u00e7 farkl\u0131 ila\u00e7 alan 10 hastan\u0131n reaksiyon s\u00fcresini (saniye cinsinden) g\u00f6steren a\u015fa\u011f\u0131daki verileri girin. Her hasta \u00fc\u00e7 ilac\u0131n her birinde \u00f6l\u00e7\u00fcld\u00fc\u011f\u00fcnden, ortalama reaksiyon s\u00fcresinin ila\u00e7lar aras\u0131nda farkl\u0131l\u0131k g\u00f6sterip g\u00f6stermedi\u011fini belirlemek i\u00e7in Friedman testini kullanaca\u011f\u0131z.<\/span> <\/p>\n

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

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

Daha sonra =RANK.AVG()<\/strong> fonksiyonunu kullanarak her sat\u0131rdaki veri de\u011ferlerini artan s\u0131rada s\u0131ralay\u0131n. A\u015fa\u011f\u0131daki form\u00fcl, hasta 1’in ilaca 1 yan\u0131t s\u00fcresi s\u0131ralamas\u0131n\u0131n nas\u0131l hesaplanaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span> <\/p>\n

\"Excel'de<\/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 ve s\u0131ralar\u0131n kare toplam\u0131n\u0131 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

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

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

    \n
  • n = hasta say\u0131s\u0131<\/span><\/li>\n
  • k = tedavi gruplar\u0131n\u0131n say\u0131s\u0131<\/span><\/li>\n
  • R j<\/sub> 2<\/sup> = j’inci<\/sup> grup i\u00e7in s\u0131ralar\u0131n toplam\u0131<\/span><\/li>\n<\/ul>\n

    S\u0131f\u0131r hipotezi alt\u0131nda Q, k-1 serbestlik derecesine sahip 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, Q’yu ve kar\u015f\u0131l\u0131k gelen p de\u011ferini hesaplamak i\u00e7in kullan\u0131lan form\u00fclleri g\u00f6sterir:<\/span> <\/p>\n

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

    Test istatisti\u011fi Q = 12,35’tir<\/strong> ve kar\u015f\u0131l\u0131k gelen p de\u011feri p = 0,00208’dir<\/strong> . Bu de\u011fer 0,05’ten k\u00fc\u00e7\u00fck oldu\u011fundan ortalama yan\u0131t s\u00fcresinin her \u00fc\u00e7 ila\u00e7 i\u00e7in de ayn\u0131 oldu\u011fu y\u00f6n\u00fcndeki s\u0131f\u0131r hipotezini reddedebiliriz. Kullan\u0131lan ila\u00e7 t\u00fcr\u00fcn\u00fcn yan\u0131t s\u00fcresinde istatistiksel olarak anlaml\u0131 farkl\u0131l\u0131klara yol a\u00e7t\u0131\u011f\u0131 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 test sonu\u00e7lar\u0131n\u0131 bildirmek istiyoruz. \u0130\u015fte bunun nas\u0131l yap\u0131laca\u011f\u0131na dair bir \u00f6rnek:<\/span><\/p>\n

    \n

    \u00dc\u00e7 farkl\u0131 ilac\u0131n yan\u0131t s\u00fcresi \u00fczerindeki etkisini incelemek i\u00e7in 10 hastaya Friedman testi uyguland\u0131. Her hasta her ilac\u0131 bir kez kulland\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 (Q = 12,35, p = 0,00208).<\/span><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

    Friedman testi, tekrarlanan ANOVA \u00f6l\u00e7\u00fcmlerine parametrik olmayan bir alternatiftir. 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 Friedman testinin Excel’de nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r. \u00d6rnek: Excel’deki Friedman testi Friedman testini Excel’de ger\u00e7ekle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin. Ad\u0131m 1: Verileri […]<\/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-663","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\nExcel'de Friedman Testi Nas\u0131l Yap\u0131l\u0131r \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Friedman 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\/excelde-friedman-testi-nasil-yapilir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de Friedman Testi Nas\u0131l Yap\u0131l\u0131r \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Friedman testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T04:23:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/friedman1.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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/\",\"url\":\"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/\",\"name\":\"Excel'de Friedman Testi Nas\u0131l Yap\u0131l\u0131r \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-29T04:23:02+00:00\",\"dateModified\":\"2023-07-29T04:23:02+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Friedman testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel'de friedman 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 Friedman Testi Nas\u0131l Yap\u0131l\u0131r \u2013 Statorials","description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Friedman 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\/excelde-friedman-testi-nasil-yapilir\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Friedman Testi Nas\u0131l Yap\u0131l\u0131r \u2013 Statorials","og_description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Friedman testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.","og_url":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/","og_site_name":"Statorials","article_published_time":"2023-07-29T04:23:02+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/friedman1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/","url":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/","name":"Excel'de Friedman Testi Nas\u0131l Yap\u0131l\u0131r \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-29T04:23:02+00:00","dateModified":"2023-07-29T04:23:02+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Ad\u0131m ad\u0131m \u00f6rnek de dahil olmak \u00fczere Excel'de Friedman testinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fine ili\u015fkin basit bir a\u00e7\u0131klama.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excelde-friedman-testi-nasil-yapilir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel'de friedman 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\/663","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=663"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/663\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}