{"id":6410,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-beta-n\/"},"modified":"2021-02-26T08:02:22","modified_gmt":"2021-02-26T08:02:22","slug":"beta-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/beta-dist\/","title":{"rendered":"LOI.BETA.N"},"content":{"rendered":"<h2>Description g\u00e9n\u00e9rale<\/h2>\n<p>La fonction LOI.BETA.N dans Microsoft Excel et BETA.DIST dans Google Sheets sert \u00e0 calculer la densit\u00e9 ou la fonction de distribution cumulative de la loi b\u00eata. Cette distribution de probabilit\u00e9 est fr\u00e9quemment utilis\u00e9e en statistiques pour repr\u00e9senter des variables al\u00e9atoires qui prennent des valeurs dans l&rsquo;intervalle [0, 1]. Elle trouve des applications dans des domaines vari\u00e9s tels que l&rsquo;analyse bay\u00e9sienne, la gestion de la qualit\u00e9 et la th\u00e9orie de la fiabilit\u00e9.<\/p>\n<h2>Syntaxe et exemples<\/h2>\n<p>La syntaxe de cette fonction diff\u00e8re l\u00e9g\u00e8rement entre Excel et Google Sheets :<\/p>\n<ul>\n<li><strong>Excel<\/strong> : <code>LOI.BETA.N(x, alpha, beta, [accumulateur], [A], [B])<\/code><\/li>\n<li><strong>Google Sheets<\/strong> : <code>BETA.DIST(x, alpha, beta, cumulative, [A], [B])<\/code><\/li>\n<\/ul>\n<p>Les param\u00e8tres de la fonction sont d\u00e9finis comme suit :<\/p>\n<ul>\n<li><code>x<\/code> repr\u00e9sente la valeur pour laquelle la fonction de distribution est calcul\u00e9e.<\/li>\n<li><code>alpha<\/code> et <code>beta<\/code> sont les param\u00e8tres de forme de la distribution.<\/li>\n<li><code>accumulateur<\/code> ou <code>cumulative<\/code>, un bool\u00e9en, d\u00e9termine si la fonction renvoie une densit\u00e9 de probabilit\u00e9 (FAUX) ou une distribution cumulative (VRAI).<\/li>\n<li><code>A<\/code> (optionnel) est la limite inf\u00e9rieure de l&rsquo;intervalle pour x.<\/li>\n<li><code>B<\/code> (optionnel) est la limite sup\u00e9rieure de l&rsquo;intervalle pour x.<\/li>\n<\/ul>\n<pre> <code> =LOI.BETA.N(0.5, 2, 3, FAUX) \/\/ Renvoie la densit\u00e9 de probabilit\u00e9 de la loi b\u00eata pour x = 0.5, avec alpha = 2 et beta = 3 dans Excel. =BETA.DIST(0.5, 2, 3, TRUE) \/\/ Renvoie la distribution cumulative pour les m\u00eames valeurs dans Google Sheets. <\/code> <\/pre>\n<h2>Exemples pratiques<\/h2>\n<h3>Sc\u00e9nario 1 : \u00c9valuation des risques<\/h3>\n<p>Supposons qu&rsquo;un gestionnaire de projets veuille \u00e9valuer la probabilit\u00e9 de r\u00e9ussir \u00e0 terminer un projet \u00e0 temps, en utilisant une \u00e9chelle de 0 \u00e0 1, o\u00f9 1 signifie certainement \u00e0 temps. La fonction BETA.DIST est id\u00e9ale pour mod\u00e9liser cette probabilit\u00e9.<\/p>\n<pre> <code> \/\/ Param\u00e8tres : risque mod\u00e9r\u00e9 de retard, mais g\u00e9n\u00e9ralement \u00e0 l'heure =LOI.BETA.N(0.8, 3, 2, VRAI) \/\/ Probabilit\u00e9 de terminer \u00e0 80% dans les temps ou avant. <\/code> <\/pre>\n<h3>Sc\u00e9nario 2 : Analyse de la satisfaction client<\/h3>\n<p>Une entreprise souhaite \u00e9valuer la satisfaction client \u00e0 partir de sondages not\u00e9s de 0 \u00e0 1. La distribution b\u00eata peut servir \u00e0 mod\u00e9liser la distribution de ces \u00e9valuations.<\/p>\n<pre> <code> \/\/ Param\u00e8tres : majorit\u00e9 des clients satisfaits, quelques insatisfaits =BETA.DIST(0.6, 5, 1, TRUE, 0, 1) \/\/ Probabilit\u00e9 cumulative qu'un client donne une note de 0.6 ou moins. <\/code> <\/pre>\n<h2>Conclusion<\/h2>\n<p>Ces exemples illustrent comment les fonctions LOI.BETA.N et BETA.DIST peuvent \u00eatre appliqu\u00e9es dans divers contextes, de la gestion de projet \u00e0 l&rsquo;analyse de satisfaction client. Gr\u00e2ce \u00e0 leur flexibilit\u00e9, ces fonctions aident \u00e0 mieux appr\u00e9hender et mod\u00e9liser les probabilit\u00e9s dans des intervalles sp\u00e9cifiques.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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":[315],"tags":[],"class_list":["post-6410","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction BETA.DIST (LOI.BETA.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction BETA.DIST (LOI.BETA.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/beta-dist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction BETA.DIST (LOI.BETA.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction BETA.DIST (LOI.BETA.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/beta-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:22+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction BETA.DIST (LOI.BETA.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\/beta-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/beta-dist\/\",\"name\":\"Fonction BETA.DIST (LOI.BETA.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:22+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction BETA.DIST (LOI.BETA.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/beta-dist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/beta-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/beta-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.BETA.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 BETA.DIST (LOI.BETA.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction BETA.DIST (LOI.BETA.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\/beta-dist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction BETA.DIST (LOI.BETA.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction BETA.DIST (LOI.BETA.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/beta-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:22+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction BETA.DIST (LOI.BETA.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\/beta-dist\/","url":"https:\/\/functiontranslator.com\/fr\/beta-dist\/","name":"Fonction BETA.DIST (LOI.BETA.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:22+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction BETA.DIST (LOI.BETA.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/beta-dist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/beta-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/beta-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.BETA.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\/6410","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=6410"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6410\/revisions"}],"predecessor-version":[{"id":29422,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6410\/revisions\/29422"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}