{"id":6564,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-gamma\/"},"modified":"2021-02-26T08:06:53","modified_gmt":"2021-02-26T08:06:53","slug":"gammadist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/gammadist\/","title":{"rendered":"LOI.GAMMA"},"content":{"rendered":"<h2>Introduction \u00e0 la fonction LOI.GAMMA dans Excel et Google Sheets<\/h2>\n<p>La fonction <strong>LOI.GAMMA<\/strong> est utilis\u00e9e pour \u00e9valuer la probabilit\u00e9 qu&rsquo;une variable al\u00e9atoire suivant une distribution Gamma soit inf\u00e9rieure \u00e0 une certaine valeur. Cette distribution est fr\u00e9quemment utilis\u00e9e en statistiques pour mod\u00e9liser des d\u00e9lais ou des p\u00e9riodes de vie dans des conditions sp\u00e9cifiques.<\/p>\n<h2>Syntaxe et exemples<\/h2>\n<p>Voici la syntaxe de la fonction :<\/p>\n<pre><code>=LOI.GAMMA(x, alpha, beta, cumul)<\/code><\/pre>\n<ul>\n<li><strong>x<\/strong> : la valeur pour laquelle la probabilit\u00e9 cumul\u00e9e est calcul\u00e9e.<\/li>\n<li><strong>alpha<\/strong> (\u03b1) : le param\u00e8tre de forme de la distribution.<\/li>\n<li><strong>beta<\/strong> (\u03b2) : le param\u00e8tre d&rsquo;\u00e9chelle de la distribution.<\/li>\n<li><strong>cumul<\/strong> : bool\u00e9en (VRAI ou FAUX) indiquant le type de fonction \u00e0 utiliser. Si VRAI, la fonction calcule la distribution cumulative ; si FAUX, elle retourne la densit\u00e9 de probabilit\u00e9.<\/li>\n<\/ul>\n<p>Exemple de calcul de la probabilit\u00e9 cumulative :<\/p>\n<pre><code>=LOI.GAMMA(4, 2, 3, VRAI)<\/code><\/pre>\n<p>Cette formule calcule la probabilit\u00e9 cumulative qu&rsquo;une variable al\u00e9atoire Gamma avec \u03b1=2 et \u03b2=3 soit inf\u00e9rieure \u00e0 4.<\/p>\n<p>Exemple de calcul de la densit\u00e9 de probabilit\u00e9 :<\/p>\n<pre><code>=LOI.GAMMA(4, 2, 3, FAUX)<\/code><\/pre>\n<p>Cette formule d\u00e9termine la densit\u00e9 de probabilit\u00e9 de la distribution Gamma en x=4 pour \u03b1=2 et \u03b2=3.<\/p>\n<h2>Applications pratiques de LOI.GAMMA<\/h2>\n<h3>Exemple 1 : \u00c9valuation de la dur\u00e9e de vie des mat\u00e9riaux<\/h3>\n<p>Consid\u00e9rez un composant dont la dur\u00e9e de vie est mod\u00e9lis\u00e9e par une distribution Gamma avec \u03b1=3 et \u03b2=10.<\/p>\n<ul>\n<li>Probl\u00e8me : D\u00e9terminer la probabilit\u00e9 que le composant dure moins de 20 ans.<\/li>\n<li>Solution : <code>=LOI.GAMMA(20, 3, 10, VRAI)<\/code><\/li>\n<\/ul>\n<p>Cette formule estime la probabilit\u00e9 cumulative que la dur\u00e9e de vie du composant soit inf\u00e9rieure \u00e0 20 ans.<\/p>\n<h3>Exemple 2 : Mod\u00e9lisation des d\u00e9lais de projet<\/h3>\n<p>La dur\u00e9e n\u00e9cessaire pour achever un projet peut \u00eatre incertaine et est souvent mod\u00e9lis\u00e9e par une distribution Gamma.<\/p>\n<ul>\n<li>Probl\u00e8me : Calculer la probabilit\u00e9 de terminer un projet en moins de 15 jours si \u03b1=5 et \u03b2=3.<\/li>\n<li>Solution : <code>=LOI.GAMMA(15, 5, 3, VRAI)<\/code><\/li>\n<\/ul>\n<p>La fonction LOI.GAMMA peut vous aider \u00e0 pr\u00e9voir et g\u00e9rer les attentes concernant le temps requis pour compl\u00e9ter un projet, en estimant la probabilit\u00e9 que celui-ci soit termin\u00e9 en 15 jours ou moins.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Renvoie la pRobabilit\u00e9 d\u2019une vaRiable al\u00e9atoiRe suivant une loi Gamma<\/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-6564","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction GAMMADIST (LOI.GAMMA) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction GAMMADIST (LOI.GAMMA) 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\/gammadist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction GAMMADIST (LOI.GAMMA) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction GAMMADIST (LOI.GAMMA) 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\/gammadist\/\" \/>\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:06:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction GAMMADIST (LOI.GAMMA) 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\/gammadist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/gammadist\/\",\"name\":\"Fonction GAMMADIST (LOI.GAMMA) 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:06:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction GAMMADIST (LOI.GAMMA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/gammadist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/gammadist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/gammadist\/#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.GAMMA\"}]},{\"@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 GAMMADIST (LOI.GAMMA) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction GAMMADIST (LOI.GAMMA) 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\/gammadist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction GAMMADIST (LOI.GAMMA) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction GAMMADIST (LOI.GAMMA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/gammadist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction GAMMADIST (LOI.GAMMA) 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\/gammadist\/","url":"https:\/\/functiontranslator.com\/fr\/gammadist\/","name":"Fonction GAMMADIST (LOI.GAMMA) 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:06:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction GAMMADIST (LOI.GAMMA) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/gammadist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/gammadist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/gammadist\/#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.GAMMA"}]},{"@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\/6564","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=6564"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6564\/revisions"}],"predecessor-version":[{"id":29575,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6564\/revisions\/29575"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}