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

La fonction LOI.BINOMIALE, aussi connue sous le nom BINOMDIST en anglais, sert \u00e0 calculer la probabilit\u00e9 d’un nombre sp\u00e9cifi\u00e9 de succ\u00e8s dans une s\u00e9rie d’essais, suivant une distribution binomiale. Elle est essentielle pour analyser des r\u00e9sultats statistiques dans des contextes o\u00f9 les conditions de succ\u00e8s sont clairement d\u00e9finies et ind\u00e9pendantes.<\/p>\n

Description de la syntaxe<\/h2>\n

Voici comment se pr\u00e9sente la syntaxe de la fonction LOI.BINOMIALE dans Excel :<\/p>\n

=LOI.BINOMIALE(nombre_succ\u00e8s; nombre_essais; probabilit\u00e9_succ\u00e8s; cumulatif)<\/code><\/pre>\n
    \n
  • nombre_succ\u00e8s<\/strong> : Correspond au nombre de succ\u00e8s souhait\u00e9s durant les essais.<\/li>\n
  • nombre_essais<\/strong> : Indique le nombre total d’essais effectu\u00e9s.<\/li>\n
  • probabilit\u00e9_succ\u00e8s<\/strong> : Repr\u00e9sente la probabilit\u00e9 de r\u00e9aliser un succ\u00e8s \u00e0 chaque essai.<\/li>\n
  • cumulatif<\/strong> : Param\u00e8tre logique qui sp\u00e9cifie si la fonction doit retourner une probabilit\u00e9 ponctuelle (FAUX) ou cumulative (VRAI).<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Illustrons l’application de la fonction LOI.BINOMIALE avec des exemples :<\/p>\n
    =LOI.BINOMIALE(4; 10; 0.5; FAUX)<\/code><\/pre>\n
    Cet exemple calcule la probabilit\u00e9 d’obtenir exactement 4 succ\u00e8s sur 10 tentatives, avec une probabilit\u00e9 de succ\u00e8s de 0.5 par essai.<\/p>\n
    =LOI.BINOMIALE(3; 10; 0.5; VRAI)<\/code><\/pre>\n
    Celui-ci renvoie la probabilit\u00e9 d’avoir trois succ\u00e8s ou moins dans 10 tentatives.<\/p>\n
    Cas pratiques<\/h2>\n
    La fonction LOI.BINOMIALE peut \u00eatre exploit\u00e9e dans de nombreux sc\u00e9narios pratiques :<\/p>\n
    Sc\u00e9nario 1 : Test de contr\u00f4le qualit\u00e9<\/h2>\n
    Une entreprise produit des ampoules avec une probabilit\u00e9 de d\u00e9faillance de 0.05 avant la fin de leur garantie. Si l’entreprise teste 20 ampoules, quelle est la probabilit\u00e9 qu’au moins une ampoule d\u00e9faille ?<\/p>\n
    =1 - LOI.BINOMIALE(0; 20; 0.05; VRAI)<\/code><\/pre>\n
    Cette formule calcule la probabilit\u00e9 compl\u00e9mentaire que z\u00e9ro ampoule ne d\u00e9faille, offrant ainsi la probabilit\u00e9 qu’au moins une d\u00e9faille.<\/p>\n
    Sc\u00e9nario 2 : \u00c9tude de march\u00e9<\/h2>\n
    Un d\u00e9partement de marketing souhaite \u00e9valuer l’efficacit\u00e9 d’une nouvelle publicit\u00e9. Ils estiment que la probabilit\u00e9 qu’un client ach\u00e8te le produit apr\u00e8s l’avoir vue est de 0.2. Si 15 clients sont expos\u00e9s \u00e0 la publicit\u00e9, quelle est la probabilit\u00e9 qu’au moins trois clients passent \u00e0 l’achat ?<\/p>\n
    =LOI.BINOMIALE(2; 15; 0.2; VRAI)<\/code><\/pre>\n
    Cette approche calcule la probabilit\u00e9 que jusqu’\u00e0 deux clients (moins de trois) n’ach\u00e8tent pas, et soustrait ce r\u00e9sultat de 1 pour obtenir la probabilit\u00e9 d’au moins trois achats.<\/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":[317],"tags":[],"class_list":["post-6416","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction BINOMDIST (LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction BINOMDIST (LOI.BINOMIALE) 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\/binomdist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction BINOMDIST (LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction BINOMDIST (LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/binomdist\/\" \/>\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:28+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction BINOMDIST (LOI.BINOMIALE) 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\/binomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/binomdist\/\",\"name\":\"Fonction BINOMDIST (LOI.BINOMIALE) 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:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction BINOMDIST (LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/binomdist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/binomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/binomdist\/#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\"}]},{\"@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 BINOMDIST (LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction BINOMDIST (LOI.BINOMIALE) 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\/binomdist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction BINOMDIST (LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction BINOMDIST (LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/binomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction BINOMDIST (LOI.BINOMIALE) 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\/binomdist\/","url":"https:\/\/functiontranslator.com\/fr\/binomdist\/","name":"Fonction BINOMDIST (LOI.BINOMIALE) 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:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction BINOMDIST (LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/binomdist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/binomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/binomdist\/#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"}]},{"@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\/6416","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=6416"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6416\/revisions"}],"predecessor-version":[{"id":29428,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6416\/revisions\/29428"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}