{"id":13862,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/inv-chicuad-cd\/"},"modified":"2021-02-26T08:43:31","modified_gmt":"2021-02-26T08:43:31","slug":"chisq-inv-rt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/","title":{"rendered":"INV.CHICUAD.CD"},"content":{"rendered":"

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

La funci\u00f3n CHISQ.INV.RT<\/code> en Microsoft Excel y INV.CHICUAD.CD<\/code> en Google Sheets permite calcular el valor inverso de la cola derecha de la distribuci\u00f3n chi-cuadrado. Esta funci\u00f3n es frecuentemente utilizada en estad\u00edstica para determinar los valores cr\u00edticos en pruebas de hip\u00f3tesis que emplean la distribuci\u00f3n chi-cuadrado.<\/p>\n

Sintaxis en Excel:<\/p>\n

CHISQ.INV.RT(probabilidad, grados_de_libertad)<\/code><\/pre>\n
Sintaxis en Google Sheets:<\/p>\n
INV.CHICUAD.CD(probabilidad, grados_de_libertad)<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • probabilidad<\/strong> corresponde al nivel de significancia en la cola derecha de la distribuci\u00f3n.<\/li>\n
  • grados_de_libertad<\/strong> representan los grados de libertad de la distribuci\u00f3n chi-cuadrado.<\/li>\n<\/ul>\n
    Ejemplo de uso:<\/p>\n
     =CHISQ.INV.RT(0.05, 10)<\/code> en Excel o =INV.CHICUAD.CD(0.05, 10)<\/code> en Google Sheets devolver\u00e1 el valor cr\u00edtico chi-cuadrado para un nivel de significancia de 0.05 con 10 grados de libertad. <\/p>\n
    Aplicaciones pr\u00e1cticas de la funci\u00f3n<\/h2>\n
    El uso de CHISQ.INV.RT<\/code> y INV.CHICUAD.CD<\/code> es especialmente relevante en contextos de pruebas de hip\u00f3tesis donde se utiliza la distribuci\u00f3n chi-cuadrado.<\/p>\n
    Primer Escenario: Prueba de bondad de ajuste de Pearson<\/h2>\n
    Supongamos que tenemos observaciones categorizadas y deseamos evaluar si estas se ajustan a una distribuci\u00f3n te\u00f3rica esperada mediante la prueba de bondad de ajuste de Pearson. Los grados de libertad en este caso suelen ser el n\u00famero de categor\u00edas menos uno. Utilizaremos la funci\u00f3n para calcular el valor cr\u00edtico requerido.<\/p>\n
    Por ejemplo, para 5 categor\u00edas, al nivel de significancia del 0.05:<\/p>\n
    =CHISQ.INV.RT(0.05, 4)<\/code><\/pre>\n
    Este c\u00e1lculo proporciona el valor cr\u00edtico que necesitamos para comparar con nuestro estad\u00edstico chi-cuadrado observado.<\/p>\n
    Segundo Escenario: Comparaci\u00f3n de tablas de contingencia<\/h2>\n
    En \u00e1reas como la investigaci\u00f3n de mercados o los estudios sociales, es com\u00fan comparar dos variables categ\u00f3ricas, como nivel de estudios y preferencia de producto, usando una tabla de contingencia. Aplicamos un test chi-cuadrado para examinar la relaci\u00f3n entre ellas.<\/p>\n
    Si tenemos 3 niveles de educaci\u00f3n y 4 tipos de producto, los grados de libertad ser\u00e1n (3-1)*(4-1) = 6. Para hallar el valor cr\u00edtico chi-cuadrado al nivel de 0.05, calculamos:<\/p>\n
    =CHISQ.INV.RT(0.05, 6)<\/code><\/pre>\n
    Este resultado nos ayuda a determinar si las diferencias observadas en la tabla son estad\u00edsticamente significativas al ser comparadas con el valor cr\u00edtico.<\/p>\n\n\n\n\n
    Nivel de significancia<\/th>\nGrados de libertad<\/th>\nValor Cr\u00edtico Chi-Cuadrado<\/th>\n<\/tr>\n
    0.05<\/td>\n5<\/td>\n=CHISQ.INV.RT(0.05, 5)<\/td>\n<\/tr>\n
    0.05<\/td>\n6<\/td>\n=CHISQ.INV.RT(0.05, 6)<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la funci\u00f3n inversa de la probabilidad de una cola de la distribuci\u00f3n chi cuadrado<\/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-13862","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n CHISQ.INV.RT (INV.CHICUAD.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.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\/chisq-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 CHISQ.INV.RT (INV.CHICUAD.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/chisq-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:43:31+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 CHISQ.INV.RT (INV.CHICUAD.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\/chisq-inv-rt\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/\",\"name\":\"Funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.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:43:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/chisq-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.CHICUAD.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 CHISQ.INV.RT (INV.CHICUAD.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.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\/chisq-inv-rt\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.CD) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:43:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.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\/chisq-inv-rt\/","url":"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/","name":"Funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.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:43:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n CHISQ.INV.RT (INV.CHICUAD.CD) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/chisq-inv-rt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/chisq-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.CHICUAD.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\/13862","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=13862"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13862\/revisions"}],"predecessor-version":[{"id":29925,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13862\/revisions\/29925"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}