{"id":6531,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/loi-exponentielle\/"},"modified":"2021-02-26T08:05:58","modified_gmt":"2021-02-26T08:05:58","slug":"expondist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/expondist\/","title":{"rendered":"LOI.EXPONENTIELLE"},"content":{"rendered":"

Description de la fonction LOI.EXPONENTIELLE<\/h2>\n

La fonction LOI.EXPONENTIELLE dans Excel, connue sous le nom de EXPONDIST en versions anglaises, est utilis\u00e9e pour calculer la probabilit\u00e9 selon une distribution exponentielle. Cette fonction est couramment employ\u00e9e pour mod\u00e9liser l’intervalle de temps entre des \u00e9v\u00e9nements survenant \u00e0 un rythme constant.<\/p>\n

La syntaxe de la fonction se pr\u00e9sente ainsi :<\/p>\n

=LOI.EXPONENTIELLE(x; lambda; cumul)<\/code><\/pre>\n
    \n
  • x<\/strong> : La valeur ou le point pour lequel vous souhaitez calculer la probabilit\u00e9.<\/li>\n
  • lambda<\/strong> : Le taux de survenue des \u00e9v\u00e9nements, qui doit \u00eatre une valeur positive.<\/li>\n
  • cumul<\/strong> : Un param\u00e8tre bool\u00e9en qui sp\u00e9cifie la forme de la fonction. Si cumul est VRAI, LOI.EXPONENTIELLE retourne la fonction de distribution cumul\u00e9e. Si cumul est FAUX, la fonction retourne la densit\u00e9 probabilit\u00e9 de la distribution.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Voici quelques exemples d’application de la fonction LOI.EXPONENTIELLE dans des contextes pratiques.<\/p>\n
    1. Calcul de la probabilit\u00e9 d’un \u00e9v\u00e9nement dans un intervalle donn\u00e9<\/h2>\n
    Imaginons qu’une boutique ait un temps moyen de 10 minutes entre l’arriv\u00e9e de chaque client. On peut utiliser LOI.EXPONENTIELLE pour estimer la probabilit\u00e9 qu’un client arrive dans les 5 minutes suivantes.<\/p>\n
    =LOI.EXPONENTIELLE(5; 1\/10; FAUX)<\/code><\/pre>\n
    Dans cet exemple, x<\/code> repr\u00e9sente 5 minutes, lambda<\/code> est 0,1 (1 divis\u00e9 par 10 minutes), et cumul<\/code> est FAUX, ce qui nous permet d’obtenir la densit\u00e9 de probabilit\u00e9 \u00e0 cet instant.<\/p>\n
    2. Calcul de la probabilit\u00e9 cumul\u00e9e<\/h2>\n
    Utilisant le m\u00eame contexte de la boutique, pour savoir la probabilit\u00e9 qu’un client arrive dans les 15 minutes ou moins, ajustez la fonction de la mani\u00e8re suivante :<\/p>\n
    =LOI.EXPONENTIELLE(15; 1\/10; VRAI)<\/code><\/pre>\n
    Ici, x<\/code> repr\u00e9sente 15 minutes et cumul<\/code> est VRAI, ce qui nous procure la probabilit\u00e9 cumul\u00e9e.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la distRibution exponentielle<\/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-6531","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction EXPONDIST (LOI.EXPONENTIELLE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction EXPONDIST (LOI.EXPONENTIELLE) 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\/expondist\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction EXPONDIST (LOI.EXPONENTIELLE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction EXPONDIST (LOI.EXPONENTIELLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/expondist\/\" \/>\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:05:58+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction EXPONDIST (LOI.EXPONENTIELLE) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/expondist\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/expondist\/\",\"name\":\"Fonction EXPONDIST (LOI.EXPONENTIELLE) 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:05:58+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction EXPONDIST (LOI.EXPONENTIELLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/expondist\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/expondist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/expondist\/#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.EXPONENTIELLE\"}]},{\"@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 EXPONDIST (LOI.EXPONENTIELLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction EXPONDIST (LOI.EXPONENTIELLE) 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\/expondist\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction EXPONDIST (LOI.EXPONENTIELLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction EXPONDIST (LOI.EXPONENTIELLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/expondist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:58+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction EXPONDIST (LOI.EXPONENTIELLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/expondist\/","url":"https:\/\/functiontranslator.com\/fr\/expondist\/","name":"Fonction EXPONDIST (LOI.EXPONENTIELLE) 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:05:58+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction EXPONDIST (LOI.EXPONENTIELLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/expondist\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/expondist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/expondist\/#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.EXPONENTIELLE"}]},{"@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\/6531","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=6531"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6531\/revisions"}],"predecessor-version":[{"id":29543,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6531\/revisions\/29543"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}