{"id":14239,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-t-inv\/"},"modified":"2021-02-26T09:00:18","modified_gmt":"2021-02-26T09:00:18","slug":"tinv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/tinv\/","title":{"rendered":"DISTR.T.INV"},"content":{"rendered":"<h2>Introducci\u00f3n<\/h2>\n<p>La funci\u00f3n DISTR.T.INV en Microsoft Excel y TINV en Google Sheets se utiliza para calcular el valor inverso de la distribuci\u00f3n t de Student. Esta funci\u00f3n es de gran utilidad en el \u00e1mbito estad\u00edstico, especialmente para realizar pruebas de hip\u00f3tesis y calcular intervalos de confianza cuando se manejan muestras de tama\u00f1o reducido.<\/p>\n<h2>Sintaxis y Ejemplos<\/h2>\n<p>La sintaxis de la funci\u00f3n var\u00eda ligeramente entre ambas plataformas:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>DISTR.T.INV(probabilidad, grados_de_libertad)<\/code><\/li>\n<li><strong>Google Sheets:<\/strong> <code>TINV(probabilidad, grados_de_libertad)<\/code><\/li>\n<\/ul>\n<p>Donde:<\/p>\n<ul>\n<li><strong>probabilidad<\/strong> corresponde a la probabilidad asociada con la distribuci\u00f3n t de dos colas.<\/li>\n<li><strong>grados_de_libertad<\/strong> se refiere al n\u00famero de grados de libertad en la muestra.<\/li>\n<\/ul>\n<p><strong>Ejemplo en Excel:<\/strong><\/p>\n<pre> <code>=DISTR.T.INV(0.05, 10)<\/code> <\/pre>\n<p>Este ejemplo determina el valor t para una probabilidad del 5% y 10 grados de libertad, usual en pruebas de significancia estad\u00edstica.<\/p>\n<p><strong>Ejemplo en Google Sheets:<\/strong><\/p>\n<pre> <code>=TINV(0.10, 15)<\/code> <\/pre>\n<p>Este comando calcula el valor t para una probabilidad del 10% y 15 grados de libertad.<\/p>\n<h2>Aplicaciones pr\u00e1cticas<\/h2>\n<p>La funci\u00f3n se emplea en diversos contextos estad\u00edsticos, destacando principalmente en:<\/p>\n<h2>Aplicaci\u00f3n en pruebas de hip\u00f3tesis<\/h2>\n<p>En las pruebas de hip\u00f3tesis, particularmente con muestras peque\u00f1as, DISTR.T.INV es crucial para determinar el valor cr\u00edtico t. Por ejemplo, si un investigador desea comprobar si la media de 20 mediciones difiere significativamente de 10 con un nivel de significancia del 5%, emplear\u00eda:<\/p>\n<pre> <code>=DISTR.T.INV(0.05, 19)<\/code> <\/pre>\n<p>Si el valor t calculado de la muestra es superior al valor devuelto por la funci\u00f3n, se rechaza la hip\u00f3tesis nula de que la media es 10.<\/p>\n<h2>Uso en intervalos de confianza<\/h2>\n<p>Para establecer un intervalo de confianza del 95% para la media de una muestra, tambi\u00e9n se utiliza esta funci\u00f3n para obtener el valor cr\u00edtico t. Consideremos una muestra de 30 observaciones:<\/p>\n<pre> <code>=DISTR.T.INV(0.025, 29)<\/code> <\/pre>\n<p>Este valor se usa para construir el intervalo, multiplicando este valor cr\u00edtico por el error est\u00e1ndar de la media de la muestra y ajustando este resultado a la media muestral para formar el intervalo.<\/p>\n<h2>Conclusi\u00f3n<\/h2>\n<p>Las funciones DISTR.T.INV en Excel y TINV en Google Sheets son herramientas indispensables en el an\u00e1lisis estad\u00edstico, particularmente valiosas en situaciones con muestras peque\u00f1as donde la distribuci\u00f3n t de Student es preferida sobre la distribuci\u00f3n normal. Estas funciones facilitan la evaluaci\u00f3n de hip\u00f3tesis y la estimaci\u00f3n de intervalos de confianza basados en la distribuci\u00f3n t.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Devuelve la funci\u00f3n inversa de 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":[542],"tags":[],"class_list":["post-14239","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n TINV (DISTR.T.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n TINV (DISTR.T.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\/tinv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n TINV (DISTR.T.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n TINV (DISTR.T.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/tinv\/\" \/>\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-26T09:00:18+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 TINV (DISTR.T.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\/tinv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/tinv\/\",\"name\":\"Funci\u00f3n TINV (DISTR.T.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-26T09:00:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n TINV (DISTR.T.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/tinv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/tinv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/tinv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilidad\",\"item\":\"https:\/\/functiontranslator.com\/es\/compatibilidad\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DISTR.T.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 TINV (DISTR.T.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n TINV (DISTR.T.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\/tinv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n TINV (DISTR.T.INV) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n TINV (DISTR.T.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/tinv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T09:00:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n TINV (DISTR.T.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\/tinv\/","url":"https:\/\/functiontranslator.com\/es\/tinv\/","name":"Funci\u00f3n TINV (DISTR.T.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-26T09:00:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n TINV (DISTR.T.INV) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/tinv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/tinv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/tinv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Compatibilidad","item":"https:\/\/functiontranslator.com\/es\/compatibilidad\/"},{"@type":"ListItem","position":3,"name":"DISTR.T.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\/14239","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=14239"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14239\/revisions"}],"predecessor-version":[{"id":30368,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14239\/revisions\/30368"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}