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

Introducci\u00f3n y Sintaxis de la Funci\u00f3n en Excel y Google Sheets<\/h2>\n

La funci\u00f3n F.DIST.RT<\/strong> en Microsoft Excel y DISTR.F.CD<\/strong> en Google Sheets se utiliza para calcular la probabilidad de la cola derecha de una distribuci\u00f3n F de Fisher. Esta funci\u00f3n es fundamental en el an\u00e1lisis de varianza (ANOVA), que sirve para comparar las varianzas de dos muestras y determinar si provienen de poblaciones con varianzas iguales.<\/p>\n

La sintaxis en Excel es:<\/p>\n

F.DIST.RT(x, grados_libertad1, grados_libertad2)<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • x<\/strong>: El valor para el cual se desea calcular la funci\u00f3n de distribuci\u00f3n.<\/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
    En Google Sheets, la sintaxis es similar:<\/p>\n
    DISTR.F.CD(x, grados_libertad1, grados_libertad2)<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    Ejemplo 1: An\u00e1lisis de Varianza de Dos Muestras<\/h2>\n
    Consideremos la situaci\u00f3n en la que deseamos comparar las varianzas de la producci\u00f3n diaria de dos m\u00e1quinas para determinar si existen diferencias significativas entre ellas. Las varianzas calculadas y los grados de libertad de cada muestra son los siguientes:<\/p>\n\n\n\n\n
    M\u00e1quina<\/th>\nVarianza<\/th>\nGrados de Libertad<\/th>\n<\/tr>\n
    A<\/td>\n5.1<\/td>\n10<\/td>\n<\/tr>\n
    B<\/td>\n3.8<\/td>\n15<\/td>\n<\/tr>\n<\/table>\n
    Para utilizar la funci\u00f3n F.DIST.RT en Excel, primero calculamos el estad\u00edstico F con la f\u00f3rmula:<\/p>\n
    F = Varianza_A \/ Varianza_B = 5.1 \/ 3.8<\/code><\/pre>\n
    Luego, utilizamos este estad\u00edstico como entrada para la funci\u00f3n:<\/p>\n
    =F.DIST.RT(1.3421, 10, 15)<\/code><\/pre>\n
    Esto devuelve el valor p, que indica si las diferencias en la varianza son estad\u00edsticamente significativas. Un valor de p inferior a 0.05 generalmente se considera como indicativo de diferencias significativas.<\/p>\n
    Ejemplo 2: Comparaci\u00f3n de la Igualdad de Varianzas en Investigaciones Cient\u00edficas<\/h2>\n
    En investigaci\u00f3n cient\u00edfica, frecuentemente es necesario confirmar si dos conjuntos de datos provienen de poblaciones con varianzas iguales antes de realizar comparaciones adicionales. Supongamos que un estudio ecol\u00f3gico reporta las siguientes varianzas y grados de libertad para dos grupos:<\/p>\n\n\n\n\n
    Grupo<\/th>\nVarianza<\/th>\nGrados de Libertad<\/th>\n<\/tr>\n
    Control<\/td>\n2.4<\/td>\n22<\/td>\n<\/tr>\n
    Experimental<\/td>\n2.1<\/td>\n22<\/td>\n<\/tr>\n<\/table>\n
    Calculamos el estad\u00edstico F como sigue:<\/p>\n
    F = Varianza_Control \/ Varianza_Experimental = 2.4 \/ 2.1<\/code><\/pre>\n
    A continuaci\u00f3n, aplicamos la funci\u00f3n en Excel o Google Sheets:<\/p>\n
    =F.DIST.RT(1.1429, 22, 22)<\/code><\/pre>\n
    Un resultado de la funci\u00f3n por debajo de 0.05 sugerir\u00eda que las varianzas no son iguales, lo que tendr\u00eda implicaciones significativas para los an\u00e1lisis subsiguientes que se realicen sobre los datos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve 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-13962","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n F.DIST.RT (DISTR.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.DIST.RT (DISTR.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-dist-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.DIST.RT (DISTR.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.DIST.RT (DISTR.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/f-dist-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:00+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.DIST.RT (DISTR.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-dist-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/f-dist-rt\/\",\"name\":\"Funci\u00f3n F.DIST.RT (DISTR.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:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n F.DIST.RT (DISTR.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/f-dist-rt\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/f-dist-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/f-dist-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\":\"DISTR.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.DIST.RT (DISTR.F.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n F.DIST.RT (DISTR.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-dist-rt\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n F.DIST.RT (DISTR.F.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n F.DIST.RT (DISTR.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/f-dist-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:48:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n F.DIST.RT (DISTR.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-dist-rt\/","url":"https:\/\/functiontranslator.com\/es\/f-dist-rt\/","name":"Funci\u00f3n F.DIST.RT (DISTR.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:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n F.DIST.RT (DISTR.F.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/f-dist-rt\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/f-dist-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/f-dist-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":"DISTR.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\/13962","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=13962"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13962\/revisions"}],"predecessor-version":[{"id":30022,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13962\/revisions\/30022"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}