{"id":15414,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/fisher\/"},"modified":"2021-02-25T16:27:03","modified_gmt":"2021-02-25T16:27:03","slug":"fisher","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/fisher\/","title":{"rendered":"FISHER"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, i\u015f ve e\u011fitim d\u00fcnyas\u0131nda yayg\u0131n olarak kullan\u0131lan iki \u00f6nemli elektronik tablo program\u0131d\u0131r. Bu yaz\u0131da, bu programlarda bulunan “FISHER” fonksiyonunun kullan\u0131m\u0131na ili\u015fkin bir rehber sunaca\u011f\u0131z. FISHER fonksiyonu, belirli bir de\u011ferin Fisher d\u00f6n\u00fc\u015f\u00fcm\u00fcn\u00fc (veya Fisher Z d\u00f6n\u00fc\u015f\u00fcm\u00fc) hesaplamak i\u00e7in kullan\u0131l\u0131r ve istatistiksel analizlerde \u00f6nemli bir role sahiptir.<\/p>\n

Fonksiyonun Tan\u0131m\u0131 ve Kullan\u0131m\u0131<\/h2>\n

FISHER fonksiyonu, -1 ile 1 aras\u0131ndaki Pearson korelasyon katsay\u0131lar\u0131n\u0131, normal da\u011f\u0131l\u0131ma daha yak\u0131n bir yakla\u015f\u0131m sa\u011flayan Z skorlar\u0131na d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu d\u00f6n\u00fc\u015f\u00fcm, \u00f6zellikle k\u00fc\u00e7\u00fck \u00f6rneklem boyutlar\u0131nda korelasyon katsay\u0131lar\u0131n\u0131n normalle\u015ftirilmesi amac\u0131yla tercih edilir.<\/p>\n

 = FISHER(r) <\/code><\/pre>\n
    \n
  • r<\/strong>: D\u00f6n\u00fc\u015ft\u00fcr\u00fclecek korelasyon katsay\u0131s\u0131d\u0131r ve bu de\u011fer -1 ile 1 aras\u0131nda (bu iki de\u011fer dahil) olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m:<\/strong><\/p>\n
    = FISHER(0.75)<\/code><\/pre>\n
    Bu form\u00fcl, 0.75 korelasyon katsay\u0131s\u0131n\u0131n Fisher Z d\u00f6n\u00fc\u015f\u00fcm de\u011ferini verir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    FISHER fonksiyonu \u00e7e\u015fitli istatistiksel analizlerde kullan\u0131labilir. \u0130\u015fte bu fonksiyonun kullan\u0131labilece\u011fi iki pratik \u00f6rnek:<\/p>\n
    \u00d6rnek 1: \u0130ki De\u011fi\u015fken Aras\u0131ndaki \u0130li\u015fkinin \u0130ncelenmesi<\/h2>\n
    Bir sosyal bilimler ara\u015ft\u0131rmas\u0131nda, iki de\u011fi\u015fken (X ve Y) aras\u0131ndaki korelasyon katsay\u0131s\u0131n\u0131 hesaplad\u0131n\u0131z ve r = 0.65 buldunuz. Bu korelasyonun anlaml\u0131l\u0131\u011f\u0131n\u0131 test etmek i\u00e7in Fisher Z d\u00f6n\u00fc\u015f\u00fcm\u00fc kullanabilirsiniz.<\/p>\n
    1. Korelasyon katsay\u0131s\u0131n\u0131 hesaplay\u0131n: r = 0.65 2. Fisher d\u00f6n\u00fc\u015f\u00fcm\u00fcn\u00fc uygulay\u0131n: = FISHER(0.65) Bu i\u015flem yakla\u015f\u0131k 0.74 de\u011ferini verir.<\/code><\/pre>\n
    Bu de\u011fer, daha sonraki istatistiksel testlerde kullan\u0131labilir.<\/p>\n
    \u00d6rnek 2: \u00c7oklu Korelasyon Testleri<\/h2>\n
    Ayn\u0131 veri seti \u00fczerinde birden fazla korelasyon testi yap\u0131yorsunuz ve bu testlerin sonu\u00e7lar\u0131n\u0131 normal da\u011f\u0131l\u0131ma daha uygun hale getirmek istiyorsunuz. Her bir r de\u011feri i\u00e7in Fisher d\u00f6n\u00fc\u015f\u00fcm\u00fc uygulayarak bu i\u015flemi ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n
    \u00d6rne\u011fin, r de\u011ferleri s\u0131ras\u0131yla 0.55, -0.45 ve 0.72 olan \u00fc\u00e7 farkl\u0131 korelasyon i\u00e7in: = FISHER(0.55) -> Yakla\u015f\u0131k 0.62 = FISHER(-0.45) -> Yakla\u015f\u0131k -0.48 = FISHER(0.72) -> Yakla\u015f\u0131k 0.87<\/code><\/pre>\n
    Bu d\u00f6n\u00fc\u015ft\u00fcr\u00fclm\u00fc\u015f de\u011ferler, analizlerinizi daha sa\u011flam ve g\u00fcvenilir k\u0131lar.<\/p>\n
    FISHER fonksiyonu, Excel ve Google Sheets’te istatistiksel analiz yaparken kullanabilece\u011finiz son derece yararl\u0131 bir ara\u00e7t\u0131r. Korelasyon katsay\u0131lar\u0131n\u0131 normalle\u015ftirmek ve \u00e7e\u015fitli istatistiksel testlerde kullanmak \u00fczere tasarlanm\u0131\u015ft\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131, veri yorumlamalar\u0131n\u0131za de\u011ferli katk\u0131lar sa\u011flayabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Fisher d\u00f6n\u00fc\u015f\u00fcm\u00fcn\u00fc verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15414","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da FISHER fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/fisher\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da FISHER fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/fisher\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:27:03+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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:\/\/functiontranslator.com\/tr\/fisher\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/fisher\/\",\"name\":\"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:27:03+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da FISHER fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/fisher\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/fisher\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/fisher\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"FISHER\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da FISHER fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/fisher\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da FISHER fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/fisher\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:27:03+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/fisher\/","url":"https:\/\/functiontranslator.com\/tr\/fisher\/","name":"Excel'de FISHER Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:27:03+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da FISHER fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/fisher\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/fisher\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/fisher\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"FISHER"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15414"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15414\/revisions"}],"predecessor-version":[{"id":26682,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15414\/revisions\/26682"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}