{"id":6647,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/logreg\/"},"modified":"2021-02-26T08:09:51","modified_gmt":"2021-02-26T08:09:51","slug":"logest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/logest\/","title":{"rendered":"LOGREG"},"content":{"rendered":"

La fonction LOGEST, appel\u00e9e LOGREG en fran\u00e7ais, est essentielle pour effectuer une r\u00e9gression exponentielle. Elle g\u00e9n\u00e8re des statistiques approfondies pour une s\u00e9rie de donn\u00e9es, ce qui s’av\u00e8re extr\u00eamement utile dans des domaines vari\u00e9s tels que la finance, la biologie et la m\u00e9t\u00e9orologie. Elle permet notamment de mod\u00e9liser l’\u00e9volution des populations, des investissements ou des ph\u00e9nom\u00e8nes naturels.<\/p>\n

Description de la fonction<\/h2>\n

LOGEST est une fonction statistique d’Excel qui estime la meilleure courbe exponentielle qui s’ajuste \u00e0 un jeu de points de donn\u00e9es. Cette fonction renvoie une matrice de valeurs qui caract\u00e9risent cette courbe.<\/p>\n

Syntaxe dans Excel :<\/strong><\/p>\n

=LOGEST(y_connues, [x_connues], [const], [stat])<\/code><\/pre>\n
    \n
  • y_connues<\/strong> : Correspond \u00e0 la plage de cellules contenant la variable d\u00e9pendante Y.<\/li>\n
  • x_connues<\/strong> (optionnel) : Repr\u00e9sente la plage de cellules qui contiennent les variables ind\u00e9pendantes X. En l’absence de cette plage, Excel utilise par d\u00e9faut les valeurs 1, 2, 3, etc.<\/li>\n
  • const<\/strong> (optionnel) : Valeur logique qui sp\u00e9cifie si la constante b doit \u00eatre incluse dans le mod\u00e8le (TRUE par d\u00e9faut).<\/li>\n
  • stat<\/strong> (optionnel) : Valeur logique qui indique si des statistiques suppl\u00e9mentaires doivent \u00eatre retourn\u00e9es (FALSE par d\u00e9faut).<\/li>\n<\/ul>\n
    Syntaxe dans Google Sheets :<\/strong><\/p>\n
    =LOGREG(y_connues; [x_connues]; [const]; [stat])<\/code><\/pre>\n
    Exemples d’application<\/h2>\n
    Pr\u00e9diction de croissance de la population<\/h2>\n
    Consid\u00e9rons une \u00e9tude sur la croissance d’une population animale au fil du temps. Voici les donn\u00e9es recueillies :<\/p>\n\n\n\n\n\n\n\n
    Ann\u00e9e<\/th>\nPopulation<\/th>\n<\/tr>\n
    2011<\/td>\n150<\/td>\n<\/tr>\n
    2012<\/td>\n165<\/td>\n<\/tr>\n
    2013<\/td>\n180<\/td>\n<\/tr>\n
    2014<\/td>\n196<\/td>\n<\/tr>\n
    2015<\/td>\n210<\/td>\n<\/tr>\n<\/table>\n
    Pour pr\u00e9voir la population de l’ann\u00e9e suivante, la formule LOGEST peut \u00eatre utilis\u00e9e :<\/p>\n
    =LOGEST(B2:B6, A2:A6, TRUE, TRUE)<\/code><\/pre>\n
    Cette formule renvoie un tableau avec les param\u00e8tres estim\u00e9s de la courbe exponentielle. Pour consulter des donn\u00e9es sp\u00e9cifiques, il peut \u00eatre n\u00e9cessaire d’adopter un formatage de cellule appropri\u00e9 ou d’utiliser la fonction INDEX.<\/p>\n
    Analyse de rendements financiers<\/h2>\n
    Dans le secteur financier, LOGEST peut \u00eatre utilis\u00e9e pour estimer le taux de croissance annuel compos\u00e9 d’un investissement. Prenons l’exemple des rendements suivants :<\/p>\n\n\n\n\n\n\n\n
    Ann\u00e9e<\/th>\nRendement (%)<\/th>\n<\/tr>\n
    2011<\/td>\n5<\/td>\n<\/tr>\n
    2012<\/td>\n7<\/td>\n<\/tr>\n
    2013<\/td>\n6<\/td>\n<\/tr>\n
    2014<\/td>\n8<\/td>\n<\/tr>\n
    2015<\/td>\n10<\/td>\n<\/tr>\n<\/table>\n
    Pour calculer le taux moyen de croissance, la formule ci-dessous peut \u00eatre configur\u00e9e :<\/p>\n
    =EXP(INDEX(LOGEST(B2:B6), 1)) - 1<\/code><\/pre>\n
    Cette m\u00e9thode combine LOGEST pour calculer l’exponentielle des rendements et la fonction INDEX pour extraire le taux de croissance sp\u00e9cifique. La fonction EXP convertit ensuite ce taux en une valeur de pourcentage.<\/p>\n
    Ces exemples d\u00e9montrent l’efficacit\u00e9 et la polyvalence de la fonction LOGEST pour l’analyse de donn\u00e9es et la pr\u00e9vision de tendances futures dans diverses applications.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie les paRam\u00e8tRes d\u2019une tendance exponentielle<\/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-6647","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction LOGEST (LOGREG) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction LOGEST (LOGREG) 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\/logest\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction LOGEST (LOGREG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction LOGEST (LOGREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/logest\/\" \/>\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:09:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction LOGEST (LOGREG) 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\/logest\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/logest\/\",\"name\":\"Fonction LOGEST (LOGREG) 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:09:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction LOGEST (LOGREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/logest\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/logest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/logest\/#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\":\"LOGREG\"}]},{\"@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 LOGEST (LOGREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction LOGEST (LOGREG) 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\/logest\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction LOGEST (LOGREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction LOGEST (LOGREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/logest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction LOGEST (LOGREG) 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\/logest\/","url":"https:\/\/functiontranslator.com\/fr\/logest\/","name":"Fonction LOGEST (LOGREG) 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:09:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction LOGEST (LOGREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/logest\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/logest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/logest\/#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":"LOGREG"}]},{"@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\/6647","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=6647"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6647\/revisions"}],"predecessor-version":[{"id":29658,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6647\/revisions\/29658"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}