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

La funci\u00f3n T.DIST, tambi\u00e9n conocida como DISTR.T.N en algunas versiones de Excel, es utilizada para calcular la distribuci\u00f3n t de Student, una herramienta fundamental en el \u00e1mbito de la estad\u00edstica utilizada para comparar los promedios de dos grupos de datos. Google Sheets tambi\u00e9n soporta esta funci\u00f3n, facilitando la realizaci\u00f3n de an\u00e1lisis estad\u00edsticos similares en entornos en la nube.<\/p>\n

Descripci\u00f3n y Sintaxis<\/h2>\n

La funci\u00f3n T.DIST calcula la probabilidad en la cola de la distribuci\u00f3n t de Student. Es especialmente \u00fatil para evaluar si dos grupos de datos difieren de manera significativa entre s\u00ed.<\/p>\n

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

T.DIST(x, grados_libertad, cola)<\/code><\/pre>\n
    \n
  • x<\/strong> – El valor t que se evaluar\u00e1 en la distribuci\u00f3n.<\/li>\n
  • grados_libertad<\/strong> – Los grados de libertad en la distribuci\u00f3n t.<\/li>\n
  • cola<\/strong> – Determina el n\u00famero de colas para la distribuci\u00f3n. Si cola es 1, se calcula la distribuci\u00f3n t unilateral; si cola es 2, se calcula la distribuci\u00f3n t bilateral.<\/li>\n<\/ul>\n
    En Google Sheets, la sintaxis es muy similar:<\/p>\n
    DISTR.T.N(x, grados_libertad, [modo])<\/code><\/pre>\n
      \n
    • [modo]<\/strong> – Opcional. Si se omite o es verdadero, calcula la funci\u00f3n de distribuci\u00f3n acumulativa; si es falso, calcula la funci\u00f3n de densidad de probabilidad.<\/li>\n<\/ul>\n
      Ejemplos de Aplicaci\u00f3n<\/h2>\n
      Comparaci\u00f3n de promedios de dos muestras<\/h2>\n
      Consideremos un estudio educativo que compara las puntuaciones de dos grupos de estudiantes en un examen espec\u00edfico para determinar si hay diferencias significativas en los promedios.<\/p>\n\n\n\n\n\n\n
      Grupo A<\/th>\nGrupo B<\/th>\n<\/tr>\n
      85<\/td>\n90<\/td>\n<\/tr>\n
      78<\/td>\n88<\/td>\n<\/tr>\n
      90<\/td>\n85<\/td>\n<\/tr>\n
      88<\/td>\n91<\/td>\n<\/tr>\n<\/table>\n
      Si la estad\u00edstica t calculada es 2.26 con 6 grados de libertad, podemos emplear la funci\u00f3n para obtener la probabilidad:<\/p>\n
      T.DIST(2.26, 6, 2)<\/code><\/pre>\n
      Este resultado debe compararse con un nivel de significancia preestablecido, com\u00fanmente 0.05 o 0.01 en investigaciones cient\u00edficas.<\/p>\n
      Determinaci\u00f3n de m\u00e1rgenes de error en encuestas<\/h2>\n
      En encuestas sobre opiniones o intenciones de voto, es com\u00fan calcular un margen de error que indica el rango dentro del cual los resultados podr\u00edan variar en replicaciones sucesivas de la misma encuesta.<\/p>\n
      Si tenemos un valor t de 1.65 con 18 grados de libertad y queremos calcular el \u00e1rea bajo la curva de la distribuci\u00f3n t a la derecha de este valor, usar\u00edamos:<\/p>\n
      T.DIST(1.65, 18, 1)<\/code><\/pre>\n
      Este resultado mostrar\u00e1 la probabilidad de que el promedio real difiera del estimado por un error mayor al inicialmente previsto, seg\u00fan el margen de error calculado.<\/p>\n
      En ambos casos, el dominio de la funci\u00f3n T.DIST (DISTR.T.N) en Excel y Google Sheets permite a investigadores y analistas llevar a cabo an\u00e1lisis estad\u00edsticos precisos y fundamentados para tomar decisiones informadas.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve los puntos porcentuales (probabilidad) de la distribuci\u00f3n 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-14229","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n T.DIST (DISTR.T.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n T.DIST (DISTR.T.N) 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\/\" \/>\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 (DISTR.T.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n T.DIST (DISTR.T.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/t-dist\/\" \/>\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:28+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 (DISTR.T.N) 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\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/t-dist\/\",\"name\":\"Funci\u00f3n T.DIST (DISTR.T.N) 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:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n T.DIST (DISTR.T.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/t-dist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/t-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/t-dist\/#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.N\"}]},{\"@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 (DISTR.T.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n T.DIST (DISTR.T.N) 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\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n T.DIST (DISTR.T.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n T.DIST (DISTR.T.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/t-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:59:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n T.DIST (DISTR.T.N) 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\/","url":"https:\/\/functiontranslator.com\/es\/t-dist\/","name":"Funci\u00f3n T.DIST (DISTR.T.N) 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:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n T.DIST (DISTR.T.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/t-dist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/t-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/t-dist\/#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.N"}]},{"@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\/14229","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=14229"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14229\/revisions"}],"predecessor-version":[{"id":30358,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14229\/revisions\/30358"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}