{"id":6555,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/prevision-lineaire\/"},"modified":"2021-02-26T08:06:41","modified_gmt":"2021-02-26T08:06:41","slug":"forecast-linear","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/forecast-linear\/","title":{"rendered":"PREVISION.LINEAIRE"},"content":{"rendered":"

Introduction \u00e0 la fonction de pr\u00e9vision<\/h2>\n

La fonction PREVISION.LINEAIRE, \u00e9galement appel\u00e9e FORECAST.LINEAR, est utilis\u00e9e dans Excel et Google Sheets pour pr\u00e9dire une valeur future en se basant sur des donn\u00e9es historiques lin\u00e9aires. Elle est id\u00e9ale pour les analyses pr\u00e9sumant une corr\u00e9lation lin\u00e9aire entre les ensembles de donn\u00e9es.<\/p>\n

Syntaxe et Exemples<\/h2>\n

La syntaxe de la fonction PREVISION.LINEAIRE est :<\/p>\n

PREVISION.LINEAIRE(x, Y, X)<\/code><\/pre>\n
    \n
  • x<\/strong> : La valeur pour laquelle la pr\u00e9vision est calcul\u00e9e.<\/li>\n
  • Y<\/strong> : Ensemble des valeurs d\u00e9pendantes, c’est-\u00e0-dire les donn\u00e9es historiques.<\/li>\n
  • X<\/strong> : Ensemble des valeurs ind\u00e9pendantes qui correspondent \u00e0 Y.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =PREVISION.LINEAIRE(10, A2:A10, B2:B10)<\/code><\/pre>\n
    Dans cet exemple, la fonction est utilis\u00e9e pour pr\u00e9dire la valeur correspondant \u00e0 x = 10, en se fondant sur les plages A2:A10 pour Y et B2:B10 pour X.<\/p>\n
    Applications pratiques<\/h2>\n
    Pr\u00e9vision des ventes<\/h2>\n
    Consid\u00e9rons une entreprise cherchant \u00e0 pr\u00e9dire ses ventes pour le mois suivant, en se basant sur les ventes des mois pr\u00e9c\u00e9dents :<\/p>\n\n\n\n\n\n\n\n
    Mois (X)<\/th>\nVentes (Y)<\/th>\n<\/tr>\n
    1<\/td>\n200<\/td>\n<\/tr>\n
    2<\/td>\n220<\/td>\n<\/tr>\n
    3<\/td>\n240<\/td>\n<\/tr>\n
    4<\/td>\n260<\/td>\n<\/tr>\n
    5<\/td>\n280<\/td>\n<\/tr>\n<\/table>\n
    La formule pour estimer les ventes du mois 6 serait :<\/p>\n
    =PREVISION.LINEAIRE(6, B2:B6, A2:A6)<\/code><\/pre>\n
    Cette formule permet de pr\u00e9dire les ventes en se basant sur la tendance lin\u00e9aire des mois ant\u00e9rieurs.<\/p>\n
    Estimation de la croissance de la population<\/h2>\n
    Un d\u00e9mographe souhaitant pr\u00e9dire la population d’une ville dans les ann\u00e9es \u00e0 venir pourrait utiliser PREVISION.LINEAIRE avec les donn\u00e9es historiques suivantes :<\/p>\n\n\n\n\n\n
    Ann\u00e9e (X)<\/th>\nPopulation (Y)<\/th>\n<\/tr>\n
    2010<\/td>\n1.2M<\/td>\n<\/tr>\n
    2015<\/td>\n1.5M<\/td>\n<\/tr>\n
    2020<\/td>\n1.8M<\/td>\n<\/tr>\n<\/table>\n
    Pour estimer la population en 2025 :<\/p>\n
    =PREVISION.LINEAIRE(2025, B2:B4, A2:A4)<\/code><\/pre>\n
    Cette m\u00e9thode permet d’estimer la croissance future de la population en supposant que la tendance actuelle se poursuive.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie une valeur future en fonction des valeurs existantes<\/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-6555","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction FORECAST.LINEAR (PREVISION.LINEAIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FORECAST.LINEAR (PREVISION.LINEAIRE) 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\/forecast-linear\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FORECAST.LINEAR (PREVISION.LINEAIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FORECAST.LINEAR (PREVISION.LINEAIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/forecast-linear\/\" \/>\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:41+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction FORECAST.LINEAR (PREVISION.LINEAIRE) 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\/forecast-linear\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/forecast-linear\/\",\"name\":\"Fonction FORECAST.LINEAR (PREVISION.LINEAIRE) 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:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FORECAST.LINEAR (PREVISION.LINEAIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/forecast-linear\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/forecast-linear\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/forecast-linear\/#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\":\"PREVISION.LINEAIRE\"}]},{\"@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 FORECAST.LINEAR (PREVISION.LINEAIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FORECAST.LINEAR (PREVISION.LINEAIRE) 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\/forecast-linear\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FORECAST.LINEAR (PREVISION.LINEAIRE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FORECAST.LINEAR (PREVISION.LINEAIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/forecast-linear\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FORECAST.LINEAR (PREVISION.LINEAIRE) 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\/forecast-linear\/","url":"https:\/\/functiontranslator.com\/fr\/forecast-linear\/","name":"Fonction FORECAST.LINEAR (PREVISION.LINEAIRE) 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:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FORECAST.LINEAR (PREVISION.LINEAIRE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/forecast-linear\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/forecast-linear\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/forecast-linear\/#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":"PREVISION.LINEAIRE"}]},{"@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\/6555","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=6555"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6555\/revisions"}],"predecessor-version":[{"id":29566,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6555\/revisions\/29566"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}