{"id":10929,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/dist-hipgeom\/"},"modified":"2021-02-25T17:21:00","modified_gmt":"2021-02-25T17:21:00","slug":"hypgeom-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/","title":{"rendered":"DIST.HIPGEOM"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o de Distribui\u00e7\u00e3o Hipergeom\u00e9trica<\/h2>\n

A fun\u00e7\u00e3o de distribui\u00e7\u00e3o hipergeom\u00e9trica, denominada HYPGEOM.DIST no Microsoft Excel e DIST.HIPGEOM nas Google Sheets, \u00e9 empregada para calcular a probabilidade de se obter um n\u00famero espec\u00edfico de sucessos em amostras extra\u00eddas de uma popula\u00e7\u00e3o finita sem reposi\u00e7\u00e3o. Essa fun\u00e7\u00e3o \u00e9 particularmente \u00fatil em estat\u00edsticas, sendo frequentemente aplicada em controle de qualidade e pesquisas de mercado.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

No Excel, a sintaxe da fun\u00e7\u00e3o \u00e9:<\/p>\n

HYPGEOM.DIST(x, n, M, N, cumulativo)<\/code><\/pre>\n
No Google Sheets, a sintaxe \u00e9:<\/p>\n
DIST.HIPGEOM(x, n, M, N, cumulativo)<\/code><\/pre>\n
    \n
  • x<\/b>: n\u00famero de sucessos desejados na amostra.<\/li>\n
  • n<\/b>: tamanho da amostra.<\/li>\n
  • M<\/b>: n\u00famero total de sucessos poss\u00edveis na popula\u00e7\u00e3o.<\/li>\n
  • N<\/b>: tamanho total da popula\u00e7\u00e3o.<\/li>\n
  • cumulativo<\/b>: um valor l\u00f3gico que indica o tipo de resultado desejado; VERDADEIRO para a fun\u00e7\u00e3o de distribui\u00e7\u00e3o cumulativa, FALSO para a fun\u00e7\u00e3o de densidade de probabilidade.<\/li>\n<\/ul>\n
    Exemplo 1:<\/b> Imagine que uma urna cont\u00e9m 20 bolas, das quais 8 s\u00e3o vermelhas. Se 5 bolas s\u00e3o selecionadas aleatoriamente sem substitui\u00e7\u00e3o, qual seria a probabilidade de exatamente 3 delas serem vermelhas?<\/p>\n
    =HYPGEOM.DIST(3, 5, 8, 20, FALSO)<\/code><\/pre>\n
    Em Google Sheets, a f\u00f3rmula seria:<\/p>\n
    =DIST.HIPGEOM(3, 5, 8, 20, FALSO)<\/code><\/pre>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Controle de Qualidade<\/h2>\n
    Um engenheiro de qualidade investiga se um lote de componentes eletr\u00f4nicos cont\u00e9m um n\u00famero excessivo de pe\u00e7as defeituosas. O lote tem 1500 itens, com at\u00e9 100 podendo estar defeituosos. Ao analisar uma amostra de 200 pe\u00e7as, ele deseja avaliar a probabilidade de encontrar mais de 10 itens defeituosos para decidir se um exame mais detalhado \u00e9 necess\u00e1rio.<\/p>\n
    Solu\u00e7\u00e3o:<\/p>\n
    =1 - HYPGEOM.DIST(10, 200, 100, 1500, VERDADEIRO)<\/code><\/pre>\n
    Essa f\u00f3rmula calcula a probabilidade cumulativa de encontrar 10 ou menos defeitos e subtrai de 1 para determinar a probabilidade de encontrar mais de 10 defeitos.<\/p>\n
    An\u00e1lise de Pesquisas Eleitorais<\/h2>\n
    Um cientista pol\u00edtico est\u00e1 estudando uma amostra de 300 eleitores de um total de 5000, sendo que 2500 s\u00e3o apoiadores de um determinado candidato. Ele quer calcular a probabilidade de que 180 ou mais eleitores na amostra apoiem esse candidato.<\/p>\n
    Solu\u00e7\u00e3o:<\/p>\n
    =1 - DIST.HIPGEOM(179, 300, 2500, 5000, VERDADEIRO)<\/code><\/pre>\n
    Utilizando a mesma abordagem do exemplo anterior, esta f\u00f3rmula usa a distribui\u00e7\u00e3o cumulativa para estimar a probabilidade de 179 ou menos apoiadores, subtraindo-se 1 para encontrar a probabilidade de haver 180 ou mais apoiadores.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve a distribui\u00e7\u00e3o 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":[442],"tags":[],"class_list":["post-10929","post","type-post","status-publish","format-standard","hentry","category-estatistica"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/hypgeom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:21:00+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\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\/pt-pt\/hypgeom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/\",\"name\":\"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:21:00+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estat\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DIST.HIPGEOM\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/hypgeom-dist\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:21:00+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/","url":"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/","name":"Fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:21:00+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o HYPGEOM.DIST (DIST.HIPGEOM) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/hypgeom-dist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Estat\u00edstica","item":"https:\/\/functiontranslator.com\/pt-pt\/estatistica\/"},{"@type":"ListItem","position":3,"name":"DIST.HIPGEOM"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10929"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10929\/revisions"}],"predecessor-version":[{"id":25758,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10929\/revisions\/25758"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}