{"id":6574,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/croissance\/"},"modified":"2021-02-26T08:07:12","modified_gmt":"2021-02-26T08:07:12","slug":"growth","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/growth\/","title":{"rendered":"CROISSANCE"},"content":{"rendered":"

La fonction CROISSANCE est largement utilis\u00e9e dans MS Excel et Google Sheets pour pr\u00e9dire les valeurs futures bas\u00e9es sur des donn\u00e9es existantes qui suivent un mod\u00e8le exponentiel. Cette fonction est particuli\u00e8rement utile dans les analyses financi\u00e8res, la biostatistique, et tout domaine o\u00f9 l’on observe une croissance exponentielle.<\/p>\n

Syntaxe et exemples d’utilisation<\/h2>\n

La syntaxe de base de la fonction CROISSANCE dans Excel et Google Sheets est la suivante :<\/p>\n

CROISSANCE(known_y's, [known_x's], [new_x's], [const])<\/code><\/pre>\n
    \n
  • known_y’s<\/strong> : Il s’agit de l’ensemble des valeurs Y d\u00e9j\u00e0 connues dans la relation Y = b*m^x.<\/li>\n
  • known_x’s<\/strong> (facultatif) : L’ensemble des valeurs X correspondantes aux valeurs Y fournies. Si omis, il est suppos\u00e9 que l’ensemble est {1, 2, 3, …}.<\/li>\n
  • new_x’s<\/strong> (facultatif) : Les nouvelles valeurs X pour lesquelles vous voulez pr\u00e9voir des valeurs Y.<\/li>\n
  • const<\/strong> (facultatif) : Un param\u00e8tre logique qui indique si la constante b doit \u00eatre calcul\u00e9e (TRUE ou omis) ou d\u00e9finie \u00e0 1 (FALSE).<\/li>\n<\/ul>\n
    Exemple d’utilisation :<\/p>\n
    Supposons que nous avons les points de donn\u00e9es suivants: X = {1, 2, 3, 4, 5} Y = {2, 4, 8, 16, 32} Pour pr\u00e9dire la valeur de Y pour X=6, utilisez la fonction CROISSANCE : =CROISSANCE(Y; X; 6)<\/code><\/pre>\n
    Cela renverra 64, car la fonction pr\u00e9dit que Y continuera de doubler comme dans les donn\u00e9es pr\u00e9c\u00e9dentes.<\/p>\n
    Application pratique dans l’analyse de donn\u00e9es<\/h2>\n
    Cas pratique 1 : Pr\u00e9vision des ventes<\/p>\n
    Imaginons qu’une entreprise a enregistr\u00e9 une croissance annuelle des ventes comme suit :<\/p>\n
    Ann\u00e9e (X): 2018, 2019, 2020, 2021 Ventes (Y): 150, 300, 600, 1200<\/code><\/pre>\n
    Pour pr\u00e9voir les ventes de l’ann\u00e9e 2022, la formule serait :<\/p>\n
    =CROISSANCE(Y; X; 2022)<\/code><\/pre>\n
    La fonction estimerait les ventes de 2022 en supposant que la tendance de croissance exponentielle continue.<\/p>\n
    Cas pratique 2 : Estimation de la population<\/p>\n
    Consid\u00e9rons une ville dont la population a augment\u00e9 de mani\u00e8re exponentielle au cours des derni\u00e8res ann\u00e9es :<\/p>\n
    Ann\u00e9e (X): 2010, 2015, 2020 Population (Y): 1 million, 1.5 millions, 2.25 millions<\/code><\/pre>\n
    Si l’on veut estimer la population pour l’ann\u00e9e 2025, on utiliserait :<\/p>\n
    =CROISSANCE(Y; X; 2025)<\/code><\/pre>\n
    La valeur retourn\u00e9e aidera les urbanistes \u00e0 planifier les ressources n\u00e9cessaires pour r\u00e9pondre aux besoins d’une population croissante.<\/p>\n
    En conclusion, la fonction CROISSANCE est un outil puissant pour mod\u00e9liser et pr\u00e9dire les donn\u00e9es suivant une progression exponentielle, permettant aux utilisateurs d’apporter des d\u00e9cisions \u00e9clair\u00e9es bas\u00e9es sur des pr\u00e9visions fiables.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule des valeurs par rapport \u00e0 une 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-6574","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction GROWTH (CROISSANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction GROWTH (CROISSANCE) 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\/growth\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction GROWTH (CROISSANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction GROWTH (CROISSANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/growth\/\" \/>\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:07:12+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction GROWTH (CROISSANCE) 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\/growth\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/growth\/\",\"name\":\"Fonction GROWTH (CROISSANCE) 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:07:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction GROWTH (CROISSANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/growth\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/growth\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/growth\/#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\":\"CROISSANCE\"}]},{\"@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 GROWTH (CROISSANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction GROWTH (CROISSANCE) 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\/growth\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction GROWTH (CROISSANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction GROWTH (CROISSANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/growth\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction GROWTH (CROISSANCE) 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\/growth\/","url":"https:\/\/functiontranslator.com\/fr\/growth\/","name":"Fonction GROWTH (CROISSANCE) 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:07:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction GROWTH (CROISSANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/growth\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/growth\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/growth\/#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":"CROISSANCE"}]},{"@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\/6574","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=6574"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6574\/revisions"}],"predecessor-version":[{"id":29585,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6574\/revisions\/29585"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}