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

La fonction de distribution binomiale est fondamentale en statistique pour d\u00e9crire les situations o\u00f9 il existe uniquement deux r\u00e9sultats possibles pour un \u00e9v\u00e9nement et son contraire. Cette fonction se r\u00e9v\u00e8le extr\u00eamement utile dans des domaines tels que la gestion de projet, la qualit\u00e9, les enqu\u00eates ou les \u00e9tudes de march\u00e9. Dans Excel et Google Sheets, la fonction LOI.BINOMIALE.N permet de calculer la probabilit\u00e9 d’obtenir un nombre d\u00e9fini de succ\u00e8s lors d’un nombre donn\u00e9 d’essais dans une exp\u00e9rience de Bernoulli.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

 LOI.BINOMIALE.N(nombre_succ\u00e8s, nombre_essais, probabilit\u00e9_succ\u00e8s, cumulatif) <\/code><\/pre>\n
    \n
  • nombre_succ\u00e8s<\/strong> : C’est le nombre de succ\u00e8s que l’on souhaite obtenir, repr\u00e9sent\u00e9 par un entier situ\u00e9 entre 0 et le nombre total d’essais.<\/li>\n
  • nombre_essais<\/strong> : Correspond au nombre total d’essais, ou tentatives, \u00e9valu\u00e9 par un entier positif.<\/li>\n
  • probabilit\u00e9_succ\u00e8s<\/strong> : Il s’agit de la probabilit\u00e9 de succ\u00e8s pour chaque essai, une valeur qui doit se situer entre 0 et 1.<\/li>\n
  • cumulatif<\/strong> : Cet argument bool\u00e9en (VRAI ou FAUX) sp\u00e9cifie le mode de calcul de la probabilit\u00e9 :\n
      \n
    • VRAI<\/strong> : Calcule la probabilit\u00e9 cumulative que le nombre de succ\u00e8s soit inf\u00e9rieur ou \u00e9gal au nombre de succ\u00e8s sp\u00e9cifi\u00e9.<\/li>\n
    • FAUX<\/strong> : Donne la probabilit\u00e9 pour que le nombre de succ\u00e8s corresponde exactement au nombre de succ\u00e8s indiqu\u00e9.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Exemples pratiques d’utilisation<\/h2>\n
      Explorons des cas d’utilisation concrets de la fonction LOI.BINOMIALE.N.<\/p>\n
      Sc\u00e9nario 1 : \u00c9tude de march\u00e9<\/h2>\n
      Consid\u00e9rez une entreprise testant un nouveau produit avec un \u00e9chantillon de 25 clients potentiels, d\u00e9sirant \u00e9valuer la probabilit\u00e9 que 15 clients acceptent de l’acheter. Admettons que chaque client a 60 % de chance d’acheter le produit.<\/p>\n
      Formule utilis\u00e9e :<\/p>\n
       =LOI.BINOMIALE.N(15, 25, 0.6, FAUX) <\/code><\/pre>\n
      Cette formule fournit la probabilit\u00e9 pr\u00e9cise que 15 sur les 25 clients choisissent d’acheter le produit.<\/p>\n
      Sc\u00e9nario 2 : Contr\u00f4le de qualit\u00e9<\/h2>\n
      Une soci\u00e9t\u00e9 produit des lots de 50 pi\u00e8ces et cherche \u00e0 d\u00e9terminer la probabilit\u00e9 que jusqu’\u00e0 5 pi\u00e8ces sur 50 soient d\u00e9fectueuses, sachant que la probabilit\u00e9 pour qu’une pi\u00e8ce soit d\u00e9fectueuse est de 1%.<\/p>\n
      Formule utilis\u00e9e :<\/p>\n
       =LOI.BINOMIALE.N(5, 50, 0.01, VRAI) <\/code><\/pre>\n
      Cette formule calcule la probabilit\u00e9 cumulative que 5 pi\u00e8ces ou moins sur 50 soient d\u00e9fectueuses, une donn\u00e9e capitale pour les strat\u00e9gies de contr\u00f4le de qualit\u00e9.<\/p>\n
      Ces illustrations montrent comment la fonction LOI.BINOMIALE.N peut \u00eatre employ\u00e9e pour prendre des d\u00e9cisions bas\u00e9es sur des analyses statistiques pr\u00e9cises, permettant de mieux appr\u00e9hender les risques et opportunit\u00e9s dans divers contextes commerciaux et industriels.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe discR\u00e8te suivant la loi binomiale<\/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-6417","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction BINOM.DIST (LOI.BINOMIALE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction BINOM.DIST (LOI.BINOMIALE.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\/binom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction BINOM.DIST (LOI.BINOMIALE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction BINOM.DIST (LOI.BINOMIALE.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\/binom-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:02:35+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction BINOM.DIST (LOI.BINOMIALE.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\/binom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/binom-dist\/\",\"name\":\"Fonction BINOM.DIST (LOI.BINOMIALE.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:02:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction BINOM.DIST (LOI.BINOMIALE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/binom-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/binom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/binom-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.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 BINOM.DIST (LOI.BINOMIALE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction BINOM.DIST (LOI.BINOMIALE.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\/binom-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction BINOM.DIST (LOI.BINOMIALE.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction BINOM.DIST (LOI.BINOMIALE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/binom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction BINOM.DIST (LOI.BINOMIALE.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\/binom-dist\/","url":"https:\/\/functiontranslator.com\/fr\/binom-dist\/","name":"Fonction BINOM.DIST (LOI.BINOMIALE.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:02:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction BINOM.DIST (LOI.BINOMIALE.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/binom-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/binom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/binom-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.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\/6417","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=6417"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6417\/revisions"}],"predecessor-version":[{"id":29429,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6417\/revisions\/29429"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}