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

Description de la fonction<\/h2>\n

La fonction LOI.BETA dans Excel et Google Sheets calcule la fonction de distribution cumul\u00e9e pour la distribution b\u00eata. Cette fonction est utile en statistique et probabilit\u00e9s quand on analyse des variables qui suivent une distribution b\u00eata. Elle est souvent utilis\u00e9e pour mod\u00e9liser des situations o\u00f9 les variations des valeurs se limitent \u00e0 un intervalle sp\u00e9cifique de 0 \u00e0 1.<\/p>\n

Syntaxe de la fonction<\/h2>\n
LOI.BETA(x; alpha; beta; A; B)<\/code><\/pre>\n
Les param\u00e8tres de la fonction sont d\u00e9finis comme suit :<\/p>\n
    \n
  • x<\/strong> : la valeur pour laquelle la fonction est \u00e9valu\u00e9e, situ\u00e9e entre les bornes A et B.<\/li>\n
  • alpha<\/strong> : un param\u00e8tre de forme de la distribution b\u00eata qui doit \u00eatre positif.<\/li>\n
  • beta<\/strong> : un autre param\u00e8tre de forme de la distribution b\u00eata, \u00e9galement positif.<\/li>\n
  • A<\/strong> : la borne inf\u00e9rieure de x, qui est 0 par d\u00e9faut.<\/li>\n
  • B<\/strong> : la borne sup\u00e9rieure de x, qui est 1 par d\u00e9faut.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n\n\n\n\n
    Fonction<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    \n
    LOI.BETA(0.5; 2; 2; 0; 1)<\/code><\/pre>\n<\/td>\n
    		Calcule la distribution cumul\u00e9e de la loi b\u00eata pour x = 0.5, alpha = 2, et beta = 2, entre les bornes 0 et 1.<\/td>\nLe r\u00e9sultat repr\u00e9sente la probabilit\u00e9 cumul\u00e9e jusqu’\u00e0 0.5 dans une distribution b\u00eata sym\u00e9trique standard.<\/td>\n<\/tr>\n
    \n
    LOI.BETA(0.75; 4; 3; 0; 1)<\/code><\/pre>\n<\/td>\n
    		Calcule la distribution cumul\u00e9e de la loi b\u00eata pour x = 0.75 avec les param\u00e8tres alpha = 4 et beta = 3.<\/td>\nLe r\u00e9sultat indique la probabilit\u00e9 cumul\u00e9e jusqu’\u00e0 0.75 pour ces param\u00e8tres de la distribution b\u00eata.<\/td>\n<\/tr>\n<\/table>\n
    Sc\u00e9narios pratiques<\/h2>\n
    \u00c9valuation des probabilit\u00e9s de r\u00e9ussite d’un nouveau produit<\/h3>\n
    Lorsque l’adoption d’un nouveau produit sur le march\u00e9 suit une distribution b\u00eata, avec les param\u00e8tres alpha = 4 (attentes positives) et beta = 2 (risques d’\u00e9chec), la fonction permet d’\u00e9valuer la probabilit\u00e9 que le produit soit accept\u00e9 \u00e0 hauteur de 80% ou plus (x = 0.8) :<\/p>\n
    LOI.BETA(0.8; 4; 2)<\/code><\/pre>\n
    Cette \u00e9valuation donnerait la probabilit\u00e9 cumul\u00e9e d’une acceptation d’au moins 80% sur le march\u00e9.<\/p>\n
    Analyse de la satisfaction client sur une \u00e9chelle donn\u00e9e<\/h3>\n
    Si la satisfaction client est mod\u00e9lis\u00e9e par une loi b\u00eata sur une \u00e9chelle de 1 \u00e0 5 (o\u00f9 5 correspond \u00e0 totalement satisfait et 1 \u00e0 pas du tout satisfait), avec des param\u00e8tres alpha = 5 et beta = 1, vous pouvez utiliser cette fonction pour estimer la probabilit\u00e9 que la satisfaction d\u00e9passe 4 :<\/p>\n
    LOI.BETA(4; 5; 1; 1; 5)<\/code><\/pre>\n
    Ce calcul donne la probabilit\u00e9 cumul\u00e9e que la satisfaction soit sup\u00e9rieure \u00e0 4.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la fonction de distRibution cumul\u00e9e<\/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-6409","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction BETADIST (LOI.BETA) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction BETADIST (LOI.BETA) 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\/betadist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction BETADIST (LOI.BETA) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction BETADIST (LOI.BETA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/betadist\/\" \/>\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:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction BETADIST (LOI.BETA) 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\/betadist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/betadist\/\",\"name\":\"Fonction BETADIST (LOI.BETA) 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:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction BETADIST (LOI.BETA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/betadist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/betadist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/betadist\/#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.BETA\"}]},{\"@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 BETADIST (LOI.BETA) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction BETADIST (LOI.BETA) 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\/betadist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction BETADIST (LOI.BETA) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction BETADIST (LOI.BETA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/betadist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction BETADIST (LOI.BETA) 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\/betadist\/","url":"https:\/\/functiontranslator.com\/fr\/betadist\/","name":"Fonction BETADIST (LOI.BETA) 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:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction BETADIST (LOI.BETA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/betadist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/betadist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/betadist\/#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.BETA"}]},{"@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\/6409","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=6409"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6409\/revisions"}],"predecessor-version":[{"id":29421,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6409\/revisions\/29421"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}