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

Description de la Fonction<\/h2>\n

La fonction LOI.BINOMIALE.NEG dans Excel et Google Sheets est con\u00e7ue pour calculer la probabilit\u00e9 d’atteindre un nombre pr\u00e9d\u00e9termin\u00e9 de succ\u00e8s au cours de tentatives ind\u00e9pendantes et successives jusqu’\u00e0 ce que ce nombre de succ\u00e8s soit obtenu. Cette fonction s’av\u00e8re particuli\u00e8rement pertinente dans les contextes o\u00f9 le nombre total de tentatives peut varier, tandis que le nombre de succ\u00e8s \u00e0 atteindre reste fixe.<\/p>\n

Syntaxe:<\/strong><\/p>\n

LOI.BINOMIALE.NEG(nombre_succ\u00e8s, nombre_\u00e9checs, probabilit\u00e9_succ\u00e8s)<\/code><\/pre>\n
Dans cette syntaxe :<\/p>\n
    \n
  • nombre_succ\u00e8s<\/strong> correspond au nombre de succ\u00e8s recherch\u00e9s.<\/li>\n
  • nombre_\u00e9checs<\/strong> repr\u00e9sente le nombre d’\u00e9checs avant de parvenir au nombre de succ\u00e8s n\u00e9cessaires.<\/li>\n
  • probabilit\u00e9_succ\u00e8s<\/strong> indique la probabilit\u00e9 de succ\u00e8s \u00e0 chaque tentative.<\/li>\n<\/ul>\n
    Exemples de Calcul<\/h2>\n
    Imaginons que vous d\u00e9sirez calculer la probabilit\u00e9 d’enregistrer exactement 3 \u00e9checs avant de r\u00e9aliser 5 succ\u00e8s, avec une probabilit\u00e9 de 50% de succ\u00e8s \u00e0 chaque essai. Vous utiliserez la formule suivante :<\/p>\n
    =LOI.BINOMIALE.NEG(5, 3, 0.5)<\/code><\/pre>\n
    Cette op\u00e9ration d\u00e9termine la probabilit\u00e9 de rencontrer ce sc\u00e9nario pr\u00e9cis lors de vos tentatives.<\/p>\n
    Sc\u00e9narios d’Utilisation Pratique<\/h2>\n
    Sc\u00e9nario 1: Contr\u00f4le Qualit\u00e9<\/h3>\n
    Dans le cadre d’une cha\u00eene de production, il peut \u00eatre utile de d\u00e9terminer apr\u00e8s combien d’\u00e9checs un processus innovant produira 10 articles de qualit\u00e9. Si la probabilit\u00e9 de produire un article de qualit\u00e9 \u00e0 chaque essai est de 30%, pour calculer la probabilit\u00e9 qu’il y ait 4 \u00e9checs avant de r\u00e9aliser 10 succ\u00e8s :<\/p>\n
    =LOI.BINOMIALE.NEG(10, 4, 0.3)<\/code><\/pre>\n
    Ce calcul permet d’\u00e9valuer l’efficacit\u00e9 d’un processus de production et de planifier des optimisations si n\u00e9cessaire.<\/p>\n
    Sc\u00e9nario 2: Marketing et promotions<\/h3>\n
    Une entreprise initie une nouvelle campagne promotionnelle offrant un cadeau aux 100 premiers clients r\u00e9ussissant un d\u00e9fi sp\u00e9cifique. Si la probabilit\u00e9 de r\u00e9ussir le d\u00e9fi \u00e0 chaque essai est de 20%, et que l’on souhaite savoir la probabilit\u00e9 que le 150\u00e8me participant soit le 100\u00e8me gagnant, utilisez :<\/p>\n
    =LOI.BINOMIALE.NEG(100, 49, 0.2)<\/code><\/pre>\n
    Cette information aide \u00e0 jauger l’attrait et le niveau de difficult\u00e9 du d\u00e9fi afin de garantir une participation suffisante sans exc\u00e9der un nombre d\u00e9termin\u00e9 de tentatives.<\/p>\n
     Voici une explication d\u00e9taill\u00e9e et des exemples pratiques illustrant l\u2019utilit\u00e9 de la fonction `LOI.BINOMIALE.NEG` dans Excel et Google Sheets, adapt\u00e9s \u00e0 diverses situations professionnelles.<\/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":[317],"tags":[],"class_list":["post-6680","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction NEGBINOMDIST (LOI.BINOMIALE.NEG) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) 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\/negbinomdist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/negbinomdist\/\" \/>\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:50+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) 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\/negbinomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/negbinomdist\/\",\"name\":\"Fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) 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:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/negbinomdist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/negbinomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/negbinomdist\/#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.BINOMIALE.NEG\"}]},{\"@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 NEGBINOMDIST (LOI.BINOMIALE.NEG) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) 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\/negbinomdist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/negbinomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:10:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) 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\/negbinomdist\/","url":"https:\/\/functiontranslator.com\/fr\/negbinomdist\/","name":"Fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) 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:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NEGBINOMDIST (LOI.BINOMIALE.NEG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/negbinomdist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/negbinomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/negbinomdist\/#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.BINOMIALE.NEG"}]},{"@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\/6680","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=6680"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6680\/revisions"}],"predecessor-version":[{"id":29691,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6680\/revisions\/29691"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}