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

Syntaxe et Explication<\/h2>\n

La fonction CRITBINOM<\/strong> ou CRITERE.LOI.BINOMIALE<\/strong> dans Excel permet de d\u00e9terminer le plus petit entier pour lequel la fonction de distribution binomiale cumul\u00e9e est inf\u00e9rieure ou \u00e9gale \u00e0 un seuil de probabilit\u00e9 sp\u00e9cifi\u00e9. Cette fonction est particuli\u00e8rement utile pour les analyses statistiques, y compris les tests d’hypoth\u00e8ses qui s’appuient sur la distribution binomiale.<\/p>\n

Syntaxe de la fonction :<\/p>\n

CRITBINOM(N, p, alpha)<\/strong><\/code><\/pre>\n
    \n
  • N<\/strong> : le nombre total d’essais.<\/li>\n
  • p<\/strong> : la probabilit\u00e9 de succ\u00e8s dans un essai unique.<\/li>\n
  • alpha<\/strong> : le seuil de probabilit\u00e9. Le r\u00e9sultat est le nombre minimal de succ\u00e8s n\u00e9cessaires pour que la probabilit\u00e9 cumul\u00e9e atteigne ou d\u00e9passe alpha.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =CRITBINOM(10, 0.5, 0.95)<\/code><\/pre>\n
    Cet exemple retourne le nombre minimal de succ\u00e8s requis sur 10 essais, chacun ayant une probabilit\u00e9 de succ\u00e8s de 0.5, pour que la probabilit\u00e9 cumul\u00e9e soit au moins de 0.95.<\/p>\n
    Exemples Pratiques<\/h2>\n
    Utilisation dans le contr\u00f4le de qualit\u00e9<\/h2>\n
    Consid\u00e9rons un sc\u00e9nario o\u00f9 une usine produit des composants \u00e9lectroniques avec une probabilit\u00e9 de 1% qu’un composant soit d\u00e9fectueux. Pour s\u2019assurer \u00e0 99% de d\u00e9tecter un composant d\u00e9fectueux, l’usine doit d\u00e9terminer le nombre minimal d\u2019inspections \u00e0 effectuer.<\/p>\n
    =CRITBINOM(100, 0.01, 0.99)<\/code><\/pre>\n
    Cette formule calcule le nombre minimal d’inspections n\u00e9cessaires parmi 100 pour garantir avec 99% de certitude la d\u00e9tection d’au moins un produit d\u00e9fectueux. Si le r\u00e9sultat est 4, cela signifie qu\u2019au moins 4 inspections sont requises pour atteindre cette probabilit\u00e9.<\/p>\n
    Analyse de risque dans le financement de projets<\/h2>\n
    Imaginez un investisseur en capital-risque \u00e9valuant le risque associ\u00e9 au financement de 20 startups, chacune ayant 10% de chances de succ\u00e8s. L’investisseur veut savoir combien d’entreprises doivent r\u00e9ussir pour avoir au moins 90% de chances de voir un retour positif sur son portefeuille global.<\/p>\n
    =CRITBINOM(20, 0.10, 0.90)<\/code><\/pre>\n
    Le r\u00e9sultat indiquerait que si au moins 6 startups sur 20 r\u00e9ussissent, alors il y a 90% de chances que le portefeuille g\u00e9n\u00e8re un retour positif. Cette information permet \u00e0 l’investisseur de prendre des d\u00e9cisions bas\u00e9es sur une \u00e9valuation pr\u00e9cise du risque.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la plus petite valeuR pouR laquelle la distRibution binomiale cumul\u00e9e est inf\u00e9RieuRe ou \u00e9gale \u00e0 une valeuR de cRit\u00e8Re<\/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-6472","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction CRITBINOM (CRITERE.LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CRITBINOM (CRITERE.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\/critbinom\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CRITBINOM (CRITERE.LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CRITBINOM (CRITERE.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\/critbinom\/\" \/>\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:03:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CRITBINOM (CRITERE.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\/critbinom\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/critbinom\/\",\"name\":\"Fonction CRITBINOM (CRITERE.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:03:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CRITBINOM (CRITERE.LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/critbinom\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/critbinom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/critbinom\/#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\":\"CRITERE.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 CRITBINOM (CRITERE.LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CRITBINOM (CRITERE.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\/critbinom\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CRITBINOM (CRITERE.LOI.BINOMIALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CRITBINOM (CRITERE.LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/critbinom\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CRITBINOM (CRITERE.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\/critbinom\/","url":"https:\/\/functiontranslator.com\/fr\/critbinom\/","name":"Fonction CRITBINOM (CRITERE.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:03:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CRITBINOM (CRITERE.LOI.BINOMIALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/critbinom\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/critbinom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/critbinom\/#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":"CRITERE.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\/6472","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=6472"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6472\/revisions"}],"predecessor-version":[{"id":29484,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6472\/revisions\/29484"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}