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

Introducci\u00f3n a DISTR.T.CD en Excel y Google Sheets<\/h2>\n

La funci\u00f3n DISTR.T.CD en Microsoft Excel y Google Sheets se emplea para calcular la distribuci\u00f3n T de Student de cola derecha. Esta funci\u00f3n es fundamental para realizar pruebas de hip\u00f3tesis en estad\u00edstica, especialmente en situaciones en las que se cuenta con muestras peque\u00f1as y la desviaci\u00f3n est\u00e1ndar de la poblaci\u00f3n es desconocida.<\/p>\n

Sintaxis y ejemplos de uso<\/h2>\n

La sintaxis de la funci\u00f3n DISTR.T.CD es la misma tanto en Excel como en Google Sheets:<\/p>\n

=DISTR.T.CD(x, grados_libertad)<\/code><\/pre>\n
    \n
  • x<\/code>: Valor al que se eval\u00faa la funci\u00f3n.<\/li>\n
  • grados_libertad<\/code>: N\u00famero de grados de libertad de la distribuci\u00f3n.<\/li>\n<\/ul>\n
    Ejemplo de uso b\u00e1sico:<\/p>\n
    =DISTR.T.CD(2.13, 10)<\/code><\/pre>\n
    Este ejemplo calcula la probabilidad de obtener un valor superior a 2.13 en una distribuci\u00f3n T con 10 grados de libertad.<\/p>\n
    Aplicaciones pr\u00e1cticas<\/h2>\n
    An\u00e1lisis de resultados de pruebas<\/h2>\n
    Consideremos que un docente desea verificar si la puntuaci\u00f3n promedio en un examen final es significativamente diferente de un valor te\u00f3rico esperado de 80. Asumiendo que la muestra de puntuaciones de 25 estudiantes sigue una distribuci\u00f3n normal y que la desviaci\u00f3n est\u00e1ndar es desconocida, se podr\u00eda utilizar la funci\u00f3n DISTR.T.CD para determinar esto.<\/p>\n
    Paso a paso:<\/strong><\/p>\n
      \n
    • Calcula la media y la desviaci\u00f3n est\u00e1ndar de las puntuaciones de los estudiantes.<\/li>\n
    • Calcula el valor de T utilizando la media de las puntuaciones, la media esperada y la desviaci\u00f3n est\u00e1ndar:<\/li>\n
      t = (media_muestra - media_esperada) \/ (desviacion_estandar \/ SQRT(n))<\/code><\/pre>\n
    • A continuaci\u00f3n, usa la funci\u00f3n DISTR.T.CD para obtener el p-valor:<\/li>\n
      =DISTR.T.CD(t, n-1)<\/code><\/pre>\n<\/ul>\n
      Si el p-valor resulta ser menor que 0.05, el docente podr\u00eda rechazar la hip\u00f3tesis nula de que no existe una diferencia significativa entre las puntuaciones medias.<\/p>\n
      Comparaci\u00f3n de dos medias independientes<\/h2>\n
      Si se requiere comparar las medias de dos grupos independientes, por ejemplo, antes y despu\u00e9s de un tratamiento, se puede utilizar la funci\u00f3n DISTR.T.CD.<\/p>\n
      Paso a paso:<\/strong><\/p>\n
        \n
      • Calcula la diferencia entre las medias de los dos grupos.<\/li>\n
      • Estima el error est\u00e1ndar de la diferencia entre medias.<\/li>\n
      • Calcula el valor t:<\/li>\n
        t = diferencia_medias \/ error_estandar<\/code><\/pre>\n
      • Utiliza la funci\u00f3n para determinar el p-valor y concluir sobre las diferencias:<\/li>\n
        =DISTR.T.CD(t, grados_libertad)<\/code><\/pre>\n<\/ul>\n
        Este proceso ayudar\u00e1 a determinar si el tratamiento tuvo un efecto estad\u00edsticamente significativo comparando los resultados antes y despu\u00e9s de su aplicaci\u00f3n.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Devuelve la distribuci\u00f3n de t de Student<\/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-14231","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n T.DIST.RT (DISTR.T.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n T.DIST.RT (DISTR.T.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\/t-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 T.DIST.RT (DISTR.T.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n T.DIST.RT (DISTR.T.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/t-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:59:33+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 T.DIST.RT (DISTR.T.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\/t-dist-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/t-dist-rt\/\",\"name\":\"Funci\u00f3n T.DIST.RT (DISTR.T.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:59:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n T.DIST.RT (DISTR.T.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/t-dist-rt\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/t-dist-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/t-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.T.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 T.DIST.RT (DISTR.T.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n T.DIST.RT (DISTR.T.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\/t-dist-rt\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n T.DIST.RT (DISTR.T.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n T.DIST.RT (DISTR.T.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/t-dist-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:59:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n T.DIST.RT (DISTR.T.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\/t-dist-rt\/","url":"https:\/\/functiontranslator.com\/es\/t-dist-rt\/","name":"Funci\u00f3n T.DIST.RT (DISTR.T.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:59:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n T.DIST.RT (DISTR.T.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/t-dist-rt\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/t-dist-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/t-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.T.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\/14231","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=14231"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14231\/revisions"}],"predecessor-version":[{"id":30360,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14231\/revisions\/30360"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}