{"id":14008,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-hipergeom\/"},"modified":"2021-02-26T08:49:58","modified_gmt":"2021-02-26T08:49:58","slug":"hypgeomdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/hypgeomdist\/","title":{"rendered":"DISTR.HIPERGEOM"},"content":{"rendered":"

Descripci\u00f3n General de la Funci\u00f3n de Distribuci\u00f3n Hipergeom\u00e9trica<\/h2>\n

La funci\u00f3n DISTR.HIPERGEOM<\/code> en Microsoft Excel y HYPGEOMDIST<\/code> en Google Sheets calculan la probabilidad de lograr un n\u00famero espec\u00edfico de \u00e9xitos en una muestra tomada de una poblaci\u00f3n finita sin reemplazo. Esta funci\u00f3n es de gran utilidad en el \u00e1mbito de las estad\u00edsticas y la probabilidad. <\/p>\n

Sintaxis y Aplicaciones Pr\u00e1cticas<\/h2>\n

La sintaxis para la funci\u00f3n es la siguiente: <\/p>\n

 =DISTR.HIPERGEOM(x, n\u00fam_muestra, \u00e9xitos, tama\u00f1o) <\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • x<\/strong>: n\u00famero de \u00e9xitos deseados en la muestra.<\/li>\n
  • n\u00fam_muestra<\/strong>: tama\u00f1o de la muestra extra\u00edda.<\/li>\n
  • \u00e9xitos<\/strong>: n\u00famero total de \u00e9xitos posibles en la poblaci\u00f3n completa.<\/li>\n
  • tama\u00f1o<\/strong>: tama\u00f1o total de la poblaci\u00f3n.<\/li>\n<\/ul>\n
    Ejemplos de Uso en Situaciones Reales<\/h2>\n
    Exploraremos el uso de esta funci\u00f3n a trav\u00e9s de dos ejemplos pr\u00e1cticos.<\/p>\n
    Control de Calidad en Producci\u00f3n<\/h2>\n
     Imagina que una f\u00e1brica produce 1000 unidades diariamente, y se estima que 20 de estas pueden ser defectuosas. Si revisamos una muestra de 100 unidades, \u00bfcu\u00e1l es la probabilidad de encontrar exactamente 5 defectuosas? <\/p>\n
     =DISTR.HIPERGEOM(5, 100, 20, 1000) <\/code><\/pre>\n
     Este c\u00e1lculo proporciona la probabilidad de descubrir precisamente 5 unidades defectuosas en una muestra de 100, sabiendo que hay 20 defectuosas en los 1000 art\u00edculos producidos. <\/p>\n
    Evaluaci\u00f3n de Encuestas Electorales<\/h2>\n
     Considera un peque\u00f1o municipio con 800 votantes registrados, de los cuales 300 afirman que votar\u00e1n por el candidato A. Si se encuesta a 50 de esos votantes, \u00bfcu\u00e1l es la probabilidad de que al menos 25 indiquen su preferencia por dicho candidato? <\/p>\n
     Para calcular esta probabilidad, se deben sumar las probabilidades individuales de obtener entre 25 y 50 votos a favor del candidato A. <\/p>\n
     =SUMA(DISTR.HIPERGEOM(25, 50, 300, 800), DISTR.HIPERGEOM(26, 50, 300, 800), ..., DISTR.HIPERGEOM(50, 50, 300, 800)) <\/code><\/pre>\n
     Este ejemplo muestra c\u00f3mo la funci\u00f3n puede ser \u00fatil para analizar resultados potenciales en encuestas de opini\u00f3n, usando muestras que son representativas pero relativamente peque\u00f1as en comparaci\u00f3n con la poblaci\u00f3n total. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la distribuci\u00f3n hipergeom\u00e9trica<\/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-14008","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"\nFunci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) 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\/hypgeomdist\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/hypgeomdist\/\" \/>\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:49:58+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 HYPGEOMDIST (DISTR.HIPERGEOM) 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\/hypgeomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/hypgeomdist\/\",\"name\":\"Funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) 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:49:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/hypgeomdist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/hypgeomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/hypgeomdist\/#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.HIPERGEOM\"}]},{\"@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 HYPGEOMDIST (DISTR.HIPERGEOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) 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\/hypgeomdist\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/hypgeomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:49:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) 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\/hypgeomdist\/","url":"https:\/\/functiontranslator.com\/es\/hypgeomdist\/","name":"Funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) 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:49:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOMDIST (DISTR.HIPERGEOM) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/hypgeomdist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/hypgeomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/hypgeomdist\/#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.HIPERGEOM"}]},{"@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\/14008","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=14008"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14008\/revisions"}],"predecessor-version":[{"id":30066,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14008\/revisions\/30066"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}