{"id":13967,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/inv-f-cd\/"},"modified":"2021-02-26T08:48:06","modified_gmt":"2021-02-26T08:48:06","slug":"f-inv-rt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/f-inv-rt\/","title":{"rendered":"INV.F.CD"},"content":{"rendered":"

La funci\u00f3n F.INV.RT en Microsoft Excel y su equivalente INV.F.CD en Google Sheets son utilizadas para calcular la inversa de la funci\u00f3n de distribuci\u00f3n acumulativa de una distribuci\u00f3n F. Esto es particularmente \u00fatil en an\u00e1lisis estad\u00edsticos, especialmente en el contexto de pruebas de hip\u00f3tesis como el an\u00e1lisis de varianza (ANOVA).<\/p>\n

Sintaxis y ejemplos<\/h2>\n

La sintaxis para la funci\u00f3n INV.F.CD en Google Sheets y F.INV.RT en Excel es:<\/p>\n

 =INV.F.CD(probabilidad, grados_libertad1, grados_libertad2) =F.INV.RT(probabilidad, grados_libertad1, grados_libertad2) <\/code><\/pre>\n
D\u00f3nde:<\/p>\n
    \n
  • probabilidad<\/strong>: Es la probabilidad asociada a la distribuci\u00f3n F.<\/li>\n
  • grados_libertad1<\/strong>: N\u00famero de grados de libertad del numerador.<\/li>\n
  • grados_libertad2<\/strong>: N\u00famero de grados de libertad del denominador.<\/li>\n<\/ul>\n
    Ejemplo en Excel y Google Sheets:<\/strong><\/p>\n
    Supongamos que necesitamos calcular el valor cr\u00edtico de una distribuci\u00f3n F con un nivel de significancia de 0.05, y con 10 y 20 grados de libertad en el numerador y el denominador respectivamente. Utilizar\u00edamos la funci\u00f3n de la siguiente manera:<\/p>\n
     =INV.F.CD(0.95, 10, 20) =F.INV.RT(0.95, 10, 20) <\/code><\/pre>\n
    El resultado ser\u00eda el valor F para el cual la probabilidad acumulativa es 0.95 bajo dichas condiciones.<\/p>\n
    Aplicaciones pr\u00e1cticas de la funci\u00f3n<\/h2>\n
    Caso pr\u00e1ctico 1: An\u00e1lisis de varianza (ANOVA)<\/h2>\n
    En un experimento que compara tres tratamientos con diferentes n\u00fameros de sujetos y queremos determinar si las diferencias entre las medias de los tratamientos son estad\u00edsticamente significativas. Podemos usar la funci\u00f3n INV.F.CD para encontrar el valor cr\u00edtico de F y compararlo con el valor calculado de F para determinar si rechazamos la hip\u00f3tesis nula.<\/p>\n
     =N\u00famero de Grados de Libertad del numerador = 2 (3 tratamientos - 1) =N\u00famero de Grados de Libertad del denominador = 27 (30 sujetos - 3) =Probabilidad = 0.95 =F.INV.RT(0.95, 2, 27) o =INV.F.CD(0.95, 2, 27) <\/code><\/pre>\n
    Si el valor calculado de F es mayor que el valor obtenido con la funci\u00f3n, rechazamos la hip\u00f3tesis nula, indicando diferencias significativas entre los tratamientos.<\/p>\n
    Caso pr\u00e1ctico 2: Comparaci\u00f3n de dos varianzas<\/h2>\n
    Supongamos que dos m\u00e1quinas diferentes producen la misma pieza y queremos determinar si hay diferencias significativas en las varianzas de las dimensiones de las piezas que producen. Utilizamos la funci\u00f3n INV.F.CD para establecer el valor cr\u00edtico y compararlo con el valor F calculado.<\/p>\n
     =N\u00famero de Grados de Libertad del numerador = 14 (15 piezas - 1) =N\u00famero de Grados de Libertad del denominador = 14 (15 piezas - 1) =Probabilidad = 0.95 =F.INV.RT(0.95, 14, 14) o =INV.F.CD(0.95, 14, 14) <\/code><\/pre>\n
    Si el valor F calculado es mayor que el valor obtenido utilizando la funci\u00f3n, existe una diferencia significativa en las varianzas de las dimensiones de las piezas producidas por las dos m\u00e1quinas.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la funci\u00f3n inversa de la distribuci\u00f3n de probabilidad F<\/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-13967","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n F.INV.RT (INV.F.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n F.INV.RT (INV.F.CD) 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\/f-inv-rt\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n F.INV.RT (INV.F.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n F.INV.RT (INV.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/f-inv-rt\/\" \/>\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:06+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 F.INV.RT (INV.F.CD) 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\/f-inv-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/f-inv-rt\/\",\"name\":\"Funci\u00f3n F.INV.RT (INV.F.CD) 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:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n F.INV.RT (INV.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/f-inv-rt\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/f-inv-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/f-inv-rt\/#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\":\"INV.F.CD\"}]},{\"@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 F.INV.RT (INV.F.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n F.INV.RT (INV.F.CD) 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\/f-inv-rt\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n F.INV.RT (INV.F.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n F.INV.RT (INV.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/f-inv-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n F.INV.RT (INV.F.CD) 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\/f-inv-rt\/","url":"https:\/\/functiontranslator.com\/es\/f-inv-rt\/","name":"Funci\u00f3n F.INV.RT (INV.F.CD) 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:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n F.INV.RT (INV.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/f-inv-rt\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/f-inv-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/f-inv-rt\/#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":"INV.F.CD"}]},{"@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\/13967","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=13967"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13967\/revisions"}],"predecessor-version":[{"id":30026,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13967\/revisions\/30026"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}