{"id":13970,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/prueba-fisher-inv\/"},"modified":"2021-02-26T08:48:09","modified_gmt":"2021-02-26T08:48:09","slug":"fisherinv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/fisherinv\/","title":{"rendered":"PRUEBA.FISHER.INV"},"content":{"rendered":"

La funci\u00f3n PRUEBA.FISHER.INV se utiliza tanto en Microsoft Excel como en Google Sheets para calcular la inversa de la transformaci\u00f3n de Fisher. Esta funci\u00f3n es particularmente \u00fatil en el \u00e1mbito de la estad\u00edstica, ya que permite revertir los valores correlaci\u00f3n transformados a sus valores originales del coeficiente de correlaci\u00f3n de Pearson.<\/p>\n

Descripci\u00f3n y sintaxis de la funci\u00f3n<\/h2>\n

La sintaxis de la funci\u00f3n PRUEBA.FISHER.INV en Excel y Google Sheets es la siguiente:<\/p>\n

PRUEBA.FISHER.INV(y)<\/code><\/pre>\n
    \n
  • y<\/strong>: Representa el valor de la transformaci\u00f3n de Fisher, un n\u00famero real. Este valor es el resultado de aplicar la transformaci\u00f3n de Fisher (funci\u00f3n FISHER) al coeficiente de correlaci\u00f3n de Pearson.<\/li>\n<\/ul>\n
    Un ejemplo t\u00edpico de uso de la funci\u00f3n es:<\/p>\n
    =PRUEBA.FISHER.INV(0.972955)<\/code><\/pre>\n
    Este ejemplo devuelve el coeficiente de correlaci\u00f3n de Pearson original basado en el valor proporcionado por la transformaci\u00f3n de Fisher.<\/p>\n
    Escenarios aplicables<\/h2>\n
    A continuaci\u00f3n se describen dos escenarios pr\u00e1cticos en los que se puede emplear la funci\u00f3n PRUEBA.FISHER.INV.<\/p>\n
    Caso 1: An\u00e1lisis de correlaci\u00f3n entre variables<\/h2>\n
    Consideremos un investigador que ha transformado los coeficientes de correlaci\u00f3n de Pearson en su estudio para llevar a cabo un an\u00e1lisis estad\u00edsticamente m\u00e1s robusto. Al finalizar este an\u00e1lisis, necesita revertir esos coeficientes a su forma original. Si el valor transformado es 1.2, la f\u00f3rmula para revertir este valor ser\u00eda:<\/p>\n
    =PRUEBA.FISHER.INV(1.2)<\/code><\/pre>\n
    Esta f\u00f3rmula devolver\u00e1 el coeficiente de correlaci\u00f3n de Pearson original correspondiente al valor transformado.<\/p>\n
    Caso 2: Comparaci\u00f3n de enfoques en meta-an\u00e1lisis<\/h2>\n
    En un meta-an\u00e1lisis, es habitual transformar los coeficientes de correlaci\u00f3n usando la transformaci\u00f3n de Fisher para facilitar combinaciones y comparaciones m\u00e1s efectivas. Tras concluir el an\u00e1lisis comparativo, es necesario revertir estos valores transformados. Por ejemplo, si el valor transformado de Fisher es 0.5, la f\u00f3rmula adecuada ser\u00eda:<\/p>\n
    =PRUEBA.FISHER.INV(0.5)<\/code><\/pre>\n
    Esta funci\u00f3n calcular\u00e1 y devolver\u00e1 el coeficiente de correlaci\u00f3n original a partir del valor transformado.<\/p>\n
    El uso de PRUEBA.FISHER.INV es esencial cuando se manejan an\u00e1lisis estad\u00edsticos que requieren de precisi\u00f3n y transformaciones en los coeficientes. Con estos ejemplos, esperamos que los usuarios puedan aplicar de manera efectiva esta funci\u00f3n en sus an\u00e1lisis espec\u00edficos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la funci\u00f3n inversa de la transformaci\u00f3n Fisher<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-13970","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\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\/es\/fisherinv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/fisherinv\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:48:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/fisherinv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/fisherinv\/\",\"name\":\"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:48:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/fisherinv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/fisherinv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/fisherinv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PRUEBA.FISHER.INV\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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\/es\/fisherinv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/fisherinv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/fisherinv\/","url":"https:\/\/functiontranslator.com\/es\/fisherinv\/","name":"Funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:48:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n FISHERINV (PRUEBA.FISHER.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/fisherinv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/fisherinv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/fisherinv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"PRUEBA.FISHER.INV"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13970"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13970\/revisions"}],"predecessor-version":[{"id":30029,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13970\/revisions\/30029"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}