{"id":13843,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/inv-binom\/"},"modified":"2021-02-26T08:42:55","modified_gmt":"2021-02-26T08:42:55","slug":"binom-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/binom-inv\/","title":{"rendered":"INV.BINOM"},"content":{"rendered":"

Introducci\u00f3n a la funci\u00f3n INV.BINOM en Excel y Google Sheets<\/h2>\n

La funci\u00f3n INV.BINOM, tambi\u00e9n conocida como BINOM.INV en ingl\u00e9s, es una herramienta estad\u00edstica disponible tanto en MS Excel como en Google Sheets. Esta funci\u00f3n se utiliza para determinar el m\u00ednimo n\u00famero de \u00e9xitos necesarios en una distribuci\u00f3n binomial acumulativa que sea mayor o igual a un criterio de probabilidad especificado.<\/p>\n

Sintaxis y Ejemplos de Uso<\/h2>\n

La sintaxis de la funci\u00f3n INV.BINOM es la siguiente:<\/p>\n

INV.BINOM(n\u00famero_ensayos, probabilidad_\u00e9xito, probabilidad_cr\u00edtica)<\/code><\/pre>\n
    \n
  • n\u00famero_ensayos<\/strong>: Es el total de ensayos o experimentos realizados.<\/li>\n
  • probabilidad_\u00e9xito<\/strong>: La probabilidad de obtener un \u00e9xito en cada ensayo.<\/li>\n
  • probabilidad_cr\u00edtica<\/strong>: La probabilidad acumulada cr\u00edtica que define el umbral de \u00e9xito.<\/li>\n<\/ul>\n
    Ejemplo Pr\u00e1ctico 1<\/h2>\n
    Imagine un gerente de marketing que necesita determinar cu\u00e1ntos clientes deben ser encuestados para tener, al menos, un 90% de confianza de que el 25% o m\u00e1s de todos los clientes est\u00e1n satisfechos con un nuevo producto. Si la probabilidad de encontrar un cliente satisfecho en cada encuesta individual es del 25%, la f\u00f3rmula ser\u00eda:<\/p>\n
    =INV.BINOM(100, 0.25, 0.90)<\/code><\/pre>\n
    Esta f\u00f3rmula calcula el n\u00famero m\u00ednimo de clientes satisfechos necesarios, de una muestra de 100, para asegurar con un 90% de confianza que, al menos, el 25% de la base total de clientes est\u00e1 satisfecha.<\/p>\n
    Ejemplo Pr\u00e1ctico 2<\/h2>\n
    En un contexto educativo, un profesor quiere saber cu\u00e1ntos estudiantes deben aprobar un examen para asegurar que, al menos, el 70% de los estudiantes mantienen un nivel de \u00e9xito, con un 95% de confianza. Si cada estudiante tiene una probabilidad del 70% de aprobar, la f\u00f3rmula ser\u00eda:<\/p>\n
    =INV.BINOM(30, 0.70, 0.95)<\/code><\/pre>\n
    Esta f\u00f3rmula indica el n\u00famero m\u00ednimo de estudiantes que deben aprobar de un grupo de 30 para estar 95% seguro de que, al menos, el 70% del total de los estudiantes puede aprobar el examen.<\/p>\n
    Conclusiones y Observaciones<\/h2>\n
    La funci\u00f3n INV.BINOM es sumamente \u00fatil en \u00e1reas donde es necesario estimar proporciones bajo un determinado nivel de confianza basado en muestras limitadas. Los ejemplos mostrados demuestran la aplicaci\u00f3n pr\u00e1ctica de esta funci\u00f3n en escenarios tanto comerciales como educativos para tomar decisiones informadas basadas en an\u00e1lisis estad\u00edstico.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el menor valor cuya distribuci\u00f3n binomial acumulativa es menor o igual a un valor de criterio<\/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-13843","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n BINOM.INV (INV.BINOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n BINOM.INV (INV.BINOM) 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\/binom-inv\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n BINOM.INV (INV.BINOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n BINOM.INV (INV.BINOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/binom-inv\/\" \/>\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:42:55+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 BINOM.INV (INV.BINOM) 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\/binom-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/binom-inv\/\",\"name\":\"Funci\u00f3n BINOM.INV (INV.BINOM) 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:42:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n BINOM.INV (INV.BINOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/binom-inv\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/binom-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/binom-inv\/#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.BINOM\"}]},{\"@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 BINOM.INV (INV.BINOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n BINOM.INV (INV.BINOM) 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\/binom-inv\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n BINOM.INV (INV.BINOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n BINOM.INV (INV.BINOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/binom-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:42:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n BINOM.INV (INV.BINOM) 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\/binom-inv\/","url":"https:\/\/functiontranslator.com\/es\/binom-inv\/","name":"Funci\u00f3n BINOM.INV (INV.BINOM) 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:42:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n BINOM.INV (INV.BINOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/binom-inv\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/binom-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/binom-inv\/#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.BINOM"}]},{"@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\/13843","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=13843"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13843\/revisions"}],"predecessor-version":[{"id":29907,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13843\/revisions\/29907"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}