{"id":6679,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-binomiale-neg-n\/"},"modified":"2021-02-26T08:10:49","modified_gmt":"2021-02-26T08:10:49","slug":"negbinom-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/","title":{"rendered":"LOI.BINOMIALE.NEG.N"},"content":{"rendered":"

Pr\u00e9sentation de la fonction de distribution binomiale n\u00e9gative<\/h2>\n

La fonction LOI.BINOMIALE.NEG.N dans Microsoft Excel et Google Sheets sert \u00e0 d\u00e9terminer la probabilit\u00e9 de rencontrer un certain nombre d’\u00e9checs avant de r\u00e9aliser un nombre d\u00e9fini de succ\u00e8s au cours de s\u00e9ries d’essais de Bernoulli ind\u00e9pendants. Chaque essai r\u00e9sulte soit en un succ\u00e8s, soit en un \u00e9chec.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction :<\/p>\n

LOI.BINOMIALE.NEG.N(n_succ\u00e8s, n_\u00e9checs, probabilit\u00e9_succ\u00e8s, [cumulatif])<\/code><\/pre>\n
    \n
  • n_succ\u00e8s<\/code> : Le nombre de succ\u00e8s d\u00e9sir\u00e9s.<\/li>\n
  • n_\u00e9checs<\/code> : Le nombre d’\u00e9checs rencontr\u00e9s.<\/li>\n
  • probabilit\u00e9_succ\u00e8s<\/code> : La probabilit\u00e9 qu’un essai soit r\u00e9ussi.<\/li>\n
  • [cumulatif]<\/code> : Un param\u00e8tre facultatif qui peut \u00eatre TRUE pour la fonction de distribution cumul\u00e9e (probabilit\u00e9 d’avoir au plus n_\u00e9checs \u00e9checs) ou FALSE pour la fonction de probabilit\u00e9 de masse (probabilit\u00e9 d’avoir exactement n_\u00e9checs \u00e9checs).<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n\n\n\n\n
    Fonction<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    LOI.BINOMIALE.NEG.N(3, 2, 0.5, FALSE)<\/code><\/td>\nCalcule la probabilit\u00e9 d’avoir exactement 2 \u00e9checs avant le 3e succ\u00e8s.<\/td>\n0.1875<\/td>\n<\/tr>\n
    LOI.BINOMIALE.NEG.N(3, 2, 0.5, TRUE)<\/code><\/td>\nCalcule la probabilit\u00e9 d’avoir jusqu’\u00e0 2 \u00e9checs avant le 3e succ\u00e8s.<\/td>\n0.8125<\/td>\n<\/tr>\n<\/table>\n
    Cas pratiques d’application<\/h2>\n
    Voici quelques exemples pratiques de l’utilisation de la fonction LOI.BINOMIALE.NEG.N dans des sc\u00e9narios r\u00e9els pour illustrer son utilit\u00e9 et son application.<\/p>\n
    Sc\u00e9nario 1 : Contr\u00f4le de qualit\u00e9<\/h3>\n
    Dans une usine qui effectue le contr\u00f4le qualit\u00e9 sur ses produits, pour des ampoules par exemple, la fonction peut \u00eatre utilis\u00e9e pour d\u00e9terminer la probabilit\u00e9 de trouver 5 ampoules d\u00e9fectueuses avant d’identifier 10 ampoules fonctionnelles, en supposant une probabilit\u00e9 de d\u00e9faut de 0.1.<\/p>\n
     LOI.BINOMIALE.NEG.N(10, 5, 0.1, FALSE) <\/code><\/pre>\n
    Cela donne la probabilit\u00e9 exacte de rencontrer ce cas sp\u00e9cifique. Supposons que le r\u00e9sultat soit 0.0573, indiquant ainsi une probabilit\u00e9 assez faible de se retrouver dans cette situation.<\/p>\n
    Sc\u00e9nario 2 : Marketing digital<\/h3>\n
    Un responsable du marketing num\u00e9rique souhaite \u00e9valuer la performance d’une campagne publicitaire devant obtenir au moins 20 conversions pour \u00eatre consid\u00e9r\u00e9e comme rentable. Il peut utiliser cette fonction pour estimer la probabilit\u00e9 d’accumuler plus de 30 clics sans conversion avant de r\u00e9aliser ces 20 conversions, en prenant une probabilit\u00e9 de conversion de 0.05.<\/p>\n
     LOI.BINOMIALE.NEG.N(20, 30, 0.05, TRUE) <\/code><\/pre>\n
    Ce calcul fournit la probabilit\u00e9 cumul\u00e9e de ne pas atteindre les 20 succ\u00e8s requis avant d’atteindre 30 \u00e9checs. Si le r\u00e9sultat est par exemple 0.945, cela met en \u00e9vidence peut-\u00eatre le besoin de revoir la strat\u00e9gie de la campagne.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe discR\u00e8te suivant une loi binomiale n\u00e9gative<\/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-6679","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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\/negbinom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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\/negbinom-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:10:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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\/negbinom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/\",\"name\":\"Fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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:10:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/negbinom-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.BINOMIALE.NEG.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 NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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\/negbinom-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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\/negbinom-dist\/","url":"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/","name":"Fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.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:10:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NEGBINOM.DIST (LOI.BINOMIALE.NEG.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/negbinom-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/negbinom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/negbinom-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.BINOMIALE.NEG.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\/6679","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=6679"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6679\/revisions"}],"predecessor-version":[{"id":29690,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6679\/revisions\/29690"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}