{"id":6583,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-hypergeometrique\/"},"modified":"2021-02-26T08:07:30","modified_gmt":"2021-02-26T08:07:30","slug":"hypgeomdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/","title":{"rendered":"LOI.HYPERGEOMETRIQUE"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction LOI.HYPERGEOMETRIQUE est utilis\u00e9e dans Microsoft Excel et Google Sheets pour d\u00e9terminer la probabilit\u00e9 d’obtenir un nombre sp\u00e9cifi\u00e9 de succ\u00e8s dans un \u00e9chantillon al\u00e9atoire tir\u00e9 d’une population finie sans remplacement. Elle est particuli\u00e8rement utile pour analyser la probabilit\u00e9 qu’un \u00e9v\u00e9nement particulier se produise sur la base d’un \u00e9chantillon.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe de la fonction LOI.HYPERGEOMETRIQUE est la suivante :<\/p>\n

LOI.HYPERGEOMETRIQUE(nb_succ\u00e8s, taille_echant, nb_succ\u00e8s_pop, taille_pop)<\/code><\/pre>\n
    \n
  • nb_succ\u00e8s<\/strong> : Le nombre de succ\u00e8s observ\u00e9s dans l’\u00e9chantillon.<\/li>\n
  • taille_echant<\/strong> : La taille totale de l’\u00e9chantillon.<\/li>\n
  • nb_succ\u00e8s_pop<\/strong> : Le nombre total de succ\u00e8s possibles au sein de la population.<\/li>\n
  • taille_pop<\/strong> : Le nombre total d’\u00e9l\u00e9ments dans la population.<\/li>\n<\/ul>\n
    Exemple concret :<\/p>\n
    =LOI.HYPERGEOMETRIQUE(4, 10, 20, 100)<\/code><\/pre>\n
    Cette formule estime la probabilit\u00e9 de tirer 4 succ\u00e8s dans un \u00e9chantillon de 10, issu d’une population totale de 100 personnes, parmi lesquelles 20 sont des succ\u00e8s potentiels.<\/p>\n
    Exemples pratiques<\/h2>\n
    Sc\u00e9nario 1: Contr\u00f4le de qualit\u00e9<\/h2>\n
    Considerons une usine produisant 1000 pi\u00e8ces, dont 100 sont d\u00e9fectueuses. Un \u00e9chantillon de 100 pi\u00e8ces est examin\u00e9 pour \u00e9valuer le taux de d\u00e9fauts. Quelle est la probabilit\u00e9 de trouver exactement 10 pi\u00e8ces d\u00e9fectueuses dans cet \u00e9chantillon ?<\/p>\n
    =LOI.HYPERGEOMETRIQUE(10, 100, 100, 1000)<\/code><\/pre>\n
    La fonction calcule la probabilit\u00e9 en utilisant le mod\u00e8le hyperg\u00e9om\u00e9trique, ce qui est essentiel pour \u00e9valuer les risques de contr\u00f4le qualit\u00e9 et ajuster les proc\u00e9dures si n\u00e9cessaire.<\/p>\n
    Sc\u00e9nario 2: \u00c9tude biologique<\/h2>\n
    Un biologiste \u00e9tudie un \u00e9chantillon de 200 plantes dans une population totale de 8000, parmi lesquelles 1200 sont infect\u00e9es par une maladie. Il souhaite d\u00e9terminer la probabilit\u00e9 que pr\u00e9cis\u00e9ment 30 plantes de l’\u00e9chantillon soient infect\u00e9es.<\/p>\n
    =LOI.HYPERGEOMETRIQUE(30, 200, 1200, 8000)<\/code><\/pre>\n
    Ce calcul peut aider le biologiste \u00e0 \u00e9valuer la propagation de la maladie au sein de la population de plantes et \u00e0 planifier des strat\u00e9gies de gestion efficaces.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe discR\u00e8te suivant une loi hypeRg\u00e9om\u00e9tRique<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[317],"tags":[],"class_list":["post-6583","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/hypgeomdist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:07:30+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/\",\"name\":\"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:07:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilit\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/fr\/compatibilite\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LOI.HYPERGEOMETRIQUE\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/hypgeomdist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/","url":"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/","name":"Fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:07:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction HYPGEOMDIST (LOI.HYPERGEOMETRIQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/hypgeomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/hypgeomdist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Compatibilit\u00e9","item":"https:\/\/functiontranslator.com\/fr\/compatibilite\/"},{"@type":"ListItem","position":3,"name":"LOI.HYPERGEOMETRIQUE"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6583"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6583\/revisions"}],"predecessor-version":[{"id":29594,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6583\/revisions\/29594"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}