{"id":5576,"date":"2025-07-15T13:34:44","date_gmt":"2025-07-15T13:34:44","guid":{"rendered":"https:\/\/functiontranslator.com\/funkce-fisher\/"},"modified":"2021-02-26T09:55:24","modified_gmt":"2021-02-26T09:55:24","slug":"fisher","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/fisher\/","title":{"rendered":"FISHER"},"content":{"rendered":"

Funkce FISHER se pou\u017e\u00edv\u00e1 pro transformaci Pearsonova korela\u010dn\u00edho koeficientu (r) na Fishersk\u00e9ho Z-transformaci, co\u017e umo\u017e\u0148uje lep\u0161\u00ed manipulaci s daty p\u0159i prov\u00e1d\u011bn\u00ed statistick\u00fdch test\u016f. Tato transformace je obvykle pou\u017e\u00edv\u00e1na v anal\u00fdze korelac\u00ed, kde transformovan\u00e9 hodnoty maj\u00ed p\u0159ibli\u017en\u011b norm\u00e1ln\u00ed rozd\u011blen\u00ed, co\u017e usnad\u0148uje dal\u0161\u00ed statistick\u00e9 zpracov\u00e1n\u00ed.<\/p>\n

Syntaxe a pou\u017eit\u00ed funkce<\/h2>\n

Syntaxe funkce FISHER v MS Excel i Google Tabulk\u00e1ch je:<\/p>\n

=FISHER(r)<\/code><\/pre>\n
    \n
  • r<\/code> – hodnota Pearsonova korela\u010dn\u00edho koeficientu, mus\u00ed b\u00fdt v rozmez\u00ed mezi -1 a 1.<\/li>\n<\/ul>\n
    P\u0159\u00edklad:<\/p>\n
    =FISHER(0.5)<\/code><\/pre>\n
    Tento p\u0159\u00edklad vr\u00e1t\u00ed hodnotu Fishersk\u00e9 Z-transformace pro korela\u010dn\u00ed koeficient 0.5.<\/p>\n
    Praktick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed<\/h2>\n
    Zde jsou uvedeny dva praktick\u00e9 p\u0159\u00edklady, kter\u00e9 ilustruj\u00ed, jak m\u016f\u017ee b\u00fdt funkce FISHER pou\u017eita v re\u00e1ln\u00fdch sc\u00e9n\u00e1\u0159\u00edch.<\/p>\n
    Anal\u00fdza korelace mezi dv\u011bma prom\u011bnn\u00fdmi<\/h2>\n
    P\u0159edpokl\u00e1dejme, \u017ee m\u00e1te data o studijn\u00ed \u00fasp\u011b\u0161nosti student\u016f (jako prom\u011bnnou X) a po\u010det hodin str\u00e1ven\u00fdch studiem (jako prom\u011bnnou Y). Po v\u00fdpo\u010dtu Pearsonova korela\u010dn\u00edho koeficientu jste z\u00edskali hodnotu 0.8, co\u017e nazna\u010duje siln\u00fd pozitivn\u00ed vztah. P\u0159i anal\u00fdze tohoto vztahu chcete pou\u017e\u00edt Fisherovu transformaci pro p\u0159esn\u011bj\u0161\u00ed porovn\u00e1n\u00ed a testov\u00e1n\u00ed.<\/p>\n
    =FISHER(0.8)<\/code><\/pre>\n
    Uveden\u00fd p\u0159\u00edkaz vr\u00e1t\u00ed Fishersk\u00e9 Z-transformovanou hodnotu, kterou m\u016f\u017eete n\u00e1sledn\u011b pou\u017e\u00edt pro hypot\u00e9zn\u00ed testov\u00e1n\u00ed nebo dal\u0161\u00ed statistick\u00e9 anal\u00fdzy.<\/p>\n
    Meta-anal\u00fdza v\u00fdzkumn\u00fdch studi\u00ed<\/h2>\n
    Kdy\u017e pracujete s v\u00fdsledky n\u011bkolika studi\u00ed zkoumaj\u00edc\u00edch stejn\u00fd vztah, m\u016f\u017eete se setkat s r\u016fzn\u00fdmi korela\u010dn\u00edmi koeficienty. P\u0159eveden\u00edm t\u011bchto koeficient\u016f na Fishersk\u00e9 Z sk\u00f3re m\u016f\u017eete sn\u00e1ze prov\u00e1d\u011bt meta-anal\u00fdzu. Nap\u0159\u00edklad, m\u00e1te t\u0159i studie s koeficienty 0.3, 0.5 a 0.7.<\/p>\n
    =FISHER(0.3) =FISHER(0.5) =FISHER(0.7)<\/code><\/pre>\n
    Po z\u00edsk\u00e1n\u00ed Fishersk\u00fdch Z sk\u00f3re z ka\u017ed\u00e9 studie m\u016f\u017eete vypo\u010d\u00edtat pr\u016fm\u011brn\u00e9 Z sk\u00f3re a n\u00e1sledn\u011b jej p\u0159ev\u00e9st zp\u011bt na korela\u010dn\u00ed koeficient pro celkov\u00fd z\u00e1v\u011br o zkouman\u00e9m vztahu.<\/p>\n
    V obou p\u0159\u00edpadech funkc\u00ed FISHER pom\u00e1h\u00e1te zp\u0159esnit statistick\u00e9 z\u00e1v\u011bry a zjednodu\u0161it procesy, kter\u00e9 by jinak vy\u017eadovaly slo\u017eit\u011bj\u0161\u00ed statistick\u00e9 metody. Jde o n\u00e1stroj, kter\u00fd zna\u010dn\u011b roz\u0161i\u0159uje analytick\u00e9 mo\u017enosti v r\u00e1mci Excelu a Google Tabulek.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vr\u00e1t\u00ed hodnotu Fisherovy transformace<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[287],"tags":[],"class_list":["post-5576","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nFunkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije FISHER u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/fisher\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije FISHER u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/fisher\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T09:55:24+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/fisher\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/fisher\/\",\"name\":\"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:44+00:00\",\"dateModified\":\"2021-02-26T09:55:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije FISHER u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/fisher\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/fisher\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/fisher\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistick\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/cs\/statisticke\/\"},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije FISHER u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/fisher\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije FISHER u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/fisher\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:44+00:00","article_modified_time":"2021-02-26T09:55:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/fisher\/","url":"https:\/\/functiontranslator.com\/cs\/fisher\/","name":"Funkce FISHER v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:44+00:00","dateModified":"2021-02-26T09:55:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije FISHER u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/fisher\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/fisher\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/fisher\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Statistick\u00e9","item":"https:\/\/functiontranslator.com\/cs\/statisticke\/"},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5576"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5576\/revisions"}],"predecessor-version":[{"id":30714,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5576\/revisions\/30714"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}