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

La distribution hyperg\u00e9om\u00e9trique est une m\u00e9thode statistique extr\u00eamement utile, sp\u00e9cialement dans les cas o\u00f9 il est n\u00e9cessaire de calculer des probabilit\u00e9s de succ\u00e8s sans remise. C’est un outil essentiel pour \u00e9valuer les probabilit\u00e9s dans des contextes o\u00f9 l’\u00e9chantillon n’est pas remis dans la population apr\u00e8s chaque tirage.<\/p>\n

Syntaxe et exemples d’utilisation<\/h2>\n

La syntaxe de la fonction LOI.HYPERGEOMETRIQUE.N dans Google Sheets et HYPGEOM.DIST dans Excel varie l\u00e9g\u00e8rement, bien que leur fonctionnement soit tr\u00e8s similaire.<\/p>\n

La syntaxe pour Excel est :<\/p>\n

HYPGEOM.DIST(x, n, M, N, cumulatif)<\/code><\/pre>\n
Param\u00e8tres :<\/p>\n
    \n
  • x<\/strong> : Le nombre de succ\u00e8s dans l’\u00e9chantillon.<\/li>\n
  • n<\/strong> : La taille de l’\u00e9chantillon.<\/li>\n
  • M<\/strong> : Le nombre total de succ\u00e8s possibles dans la population.<\/li>\n
  • N<\/strong> : La taille de la population.<\/li>\n
  • cumulatif<\/strong> : Un bool\u00e9en sp\u00e9cifiant si le r\u00e9sultat doit \u00eatre la fonction de distribution cumul\u00e9e ou la probabilit\u00e9 ponctuelle.<\/li>\n<\/ul>\n
    Exemple Excel :<\/p>\n
    =HYPGEOM.DIST(3, 20, 8, 50, FAUX)<\/code><\/pre>\n
    Cela calcule la probabilit\u00e9 d’obtenir exactement 3 succ\u00e8s dans un \u00e9chantillon de 20, tir\u00e9 d’une population de 50 individus o\u00f9 il y a 8 succ\u00e8s possibles.<\/p>\n
    La syntaxe pour Google Sheets est :<\/p>\n
    LOI.HYPERGEOMETRIQUE.N(x, n, M, N, cumulatif)<\/code><\/pre>\n
    Exemple Google Sheets :<\/p>\n
    =LOI.HYPERGEOMETRIQUE.N(3, 20, 8, 50, FAUX)<\/code><\/pre>\n
    Cela fournit un r\u00e9sultat identique \u00e0 l’exemple Excel pr\u00e9c\u00e9demment mentionn\u00e9.<\/p>\n
    Applications pratiques de la distribution hyperg\u00e9om\u00e9trique<\/h2>\n
    Contr\u00f4le de qualit\u00e9 dans la production<\/h2>\n
    Consid\u00e9rons une entreprise de fabrication de pi\u00e8ces automobiles qui cherche \u00e0 \u00e9valuer la qualit\u00e9 de sa production. Sur un total de 1000 pi\u00e8ces, 90 sont d\u00e9fectueuses.<\/p>\n
    Application :<\/p>\n
    =HYPGEOM.DIST(2, 30, 90, 1000, FAUX)<\/code><\/pre>\n
    Ce calcul estime la probabilit\u00e9 de trouver pr\u00e9cis\u00e9ment 2 pi\u00e8ces d\u00e9fectueuses dans un \u00e9chantillon al\u00e9atoire de 30 pi\u00e8ces.<\/p>\n
    \u00c9tude des traits biologiques dans une population \u00e9cologique<\/h2>\n
    Un biologiste souhaite estimer la probabilit\u00e9 de d\u00e9couvrir un certain nombre d’individus pr\u00e9sentant un trait g\u00e9n\u00e9tique rare dans une petite population. Si la population totale est de 1500 animaux, dont 35 poss\u00e8dent ce trait rare :<\/p>\n
    Application :<\/p>\n
    =LOI.HYPERGEOMETRIQUE.N(5, 60, 35, 1500, FAUX)<\/code><\/pre>\n
    Cette fonction permet de calculer la probabilit\u00e9 de rep\u00e9rer exactement 5 animaux poss\u00e9dant le trait g\u00e9n\u00e9tique rare dans un \u00e9chantillon de 60 individus.<\/p>\n
    En r\u00e9sum\u00e9, ma\u00eetriser la fonction de distribution hyperg\u00e9om\u00e9trique est crucial dans de nombreux domaines pratiques o\u00f9 les tirages se font sans remise. Elle fournit une analyse pr\u00e9cise des probabilit\u00e9s dans ces situations, rendant cet outil indispensable pour les d\u00e9cideurs et chercheurs.<\/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":[315],"tags":[],"class_list":["post-6582","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) 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\/hypgeom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/\" \/>\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:29+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) 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\/hypgeom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/\",\"name\":\"Fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) 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:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LOI.HYPERGEOMETRIQUE.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\":\"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 HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) 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\/hypgeom-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) 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\/hypgeom-dist\/","url":"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/","name":"Fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) 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:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction HYPGEOM.DIST (LOI.HYPERGEOMETRIQUE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/hypgeom-dist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"LOI.HYPERGEOMETRIQUE.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":"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\/6582","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=6582"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6582\/revisions"}],"predecessor-version":[{"id":29593,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6582\/revisions\/29593"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}