{"id":14007,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/distr-hipergeom-n\/"},"modified":"2021-02-26T08:49:57","modified_gmt":"2021-02-26T08:49:57","slug":"hypgeom-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/","title":{"rendered":"DISTR.HIPERGEOM.N"},"content":{"rendered":"<h2>Introducci\u00f3n a la Distribuci\u00f3n Hipergeom\u00e9trica<\/h2>\n<p>La distribuci\u00f3n hipergeom\u00e9trica es una herramienta estad\u00edstica utilizada para modelar situaciones en las que objetos son seleccionados de un conjunto finito sin reposici\u00f3n. Resulta particularmente \u00fatil para calcular la probabilidad de obtener un n\u00famero espec\u00edfico de \u00e9xitos en una muestra extra\u00edda de una poblaci\u00f3n con un n\u00famero conocido de \u00e9xitos potenciales.<\/p>\n<h2>Sintaxis y Ejemplos<\/h2>\n<p>En Excel y Google Sheets, la funci\u00f3n de distribuci\u00f3n hipergeom\u00e9trica se representa por <code>DISTR.HIPERGEOM.N(x, M, n, N)<\/code>, donde:<\/p>\n<ul>\n<li><b>x<\/b> corresponde al n\u00famero de \u00e9xitos observados en la muestra.<\/li>\n<li><b>M<\/b> indica el n\u00famero total de \u00e9xitos en la poblaci\u00f3n.<\/li>\n<li><b>n<\/b> es el tama\u00f1o de la muestra extra\u00edda.<\/li>\n<li><b>N<\/b> representa el tama\u00f1o total de la poblaci\u00f3n.<\/li>\n<\/ul>\n<p>El resultado de esta funci\u00f3n es la probabilidad de observar exactamente <code>x<\/code> \u00e9xitos en la muestra seleccionada de la poblaci\u00f3n.<\/p>\n<pre> <code>=DISTR.HIPERGEOM.N(4, 20, 10, 40)<\/code> <\/pre>\n<p>Este ejemplo calcula la probabilidad de lograr precisamente 4 \u00e9xitos al seleccionar 10 elementos de una poblaci\u00f3n de 40, donde hay 20 \u00e9xitos posibles.<\/p>\n<h2>Pr\u00e1ctica: An\u00e1lisis de Control de Calidad<\/h2>\n<p>Consideremos una f\u00e1brica que produce 1000 unidades de un producto, de las cuales 100 son defectuosas. La probabilidad de que, al seleccionar aleatoriamente 30 unidades, exactamente 5 sean defectuosas se puede calcular como:<\/p>\n<pre> <code>=DISTR.HIPERGEOM.N(5, 100, 30, 1000)<\/code> <\/pre>\n<p>Este c\u00e1lculo es fundamental para evaluar la eficacia del control de calidad y para asegurar que el proceso productivo cumple con los est\u00e1ndares establecidos. La funci\u00f3n nos permite determinar la probabilidad de encontrar un espec\u00edfico n\u00famero de unidades defectuosas en una muestra, lo que es clave para tomar decisiones respecto a ajustes en la producci\u00f3n.<\/p>\n<h2>Pr\u00e1ctica: Selecci\u00f3n de Jurado<\/h2>\n<p>Supongamos que en una ciudad de 5000 habitantes, 1500 son hombres. Si se necesita formar un jurado de 12 miembros seleccionados al azar, la probabilidad de que exactamente 7 miembros sean hombres se puede hallar mediante:<\/p>\n<pre> <code>=DISTR.HIPERGEOM.N(7, 1500, 12, 5000)<\/code> <\/pre>\n<p>Este c\u00e1lculo es \u00fatil para garantizar una representaci\u00f3n equitativa en un jurado o cualquier otro grupo, contribuyendo a la imparcialidad y justicia del proceso de selecci\u00f3n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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":[540],"tags":[],"class_list":["post-14007","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.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\/hypgeom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/hypgeom-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:49:57+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 HYPGEOM.DIST (DISTR.HIPERGEOM.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\/hypgeom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/\",\"name\":\"Funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.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:49:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/hypgeom-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.HIPERGEOM.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 HYPGEOM.DIST (DISTR.HIPERGEOM.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.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\/hypgeom-dist\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:49:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.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\/hypgeom-dist\/","url":"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/","name":"Funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.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:49:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n HYPGEOM.DIST (DISTR.HIPERGEOM.N) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/hypgeom-dist\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/hypgeom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/hypgeom-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.HIPERGEOM.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\/14007","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=14007"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14007\/revisions"}],"predecessor-version":[{"id":30065,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14007\/revisions\/30065"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}