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

Introduction \u00e0 la fonction PREVISION<\/h2>\n

La fonction PREVISION, disponible dans Microsoft Excel et Google Sheets, permet d’estimer une valeur future en utilisant la m\u00e9thode de r\u00e9gression lin\u00e9aire, \u00e0 partir de donn\u00e9es historiques. Cette fonction est largement utilis\u00e9e dans des domaines tels que la statistique, l’\u00e9conomie, et d’autres o\u00f9 il est n\u00e9cessaire de faire des pr\u00e9dictions sur de futures tendances \u00e0 partir de donn\u00e9es existantes.<\/p>\n

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

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

=PREVISION(x, y, valeurs_x)<\/code><\/pre>\n
    \n
  • x<\/strong> : la valeur pour laquelle la pr\u00e9vision est calcul\u00e9e.<\/li>\n
  • y<\/strong> : l’ensemble des valeurs d\u00e9pendantes.<\/li>\n
  • valeurs_x<\/strong> : l’ensemble des valeurs ind\u00e9pendantes.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =PREVISION(2025, A2:A10, B2:B10)<\/code><\/pre>\n
    Dans cet exemple, Excel\/Google Sheets utilisera les donn\u00e9es historiques des cellules A2:A10 (ann\u00e9es) et B2:B10 (valeurs associ\u00e9es) pour pr\u00e9dire la valeur correspondant \u00e0 l’ann\u00e9e 2025.<\/p>\n
    Applications pratiques de PREVISION<\/h2>\n
    Cas d’usage 1 : Pr\u00e9diction des ventes<\/h2>\n
    Imaginez que vous disposiez des donn\u00e9es des ventes annuelles d’une entreprise de 2012 \u00e0 2020, et que vous souhaitez pr\u00e9dire les ventes pour l’ann\u00e9e 2022.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
    Ann\u00e9e<\/th>\nVentes (en milliers)<\/th>\n<\/tr>\n
    2012<\/td>\n400<\/td>\n<\/tr>\n
    2013<\/td>\n450<\/td>\n<\/tr>\n
    2014<\/td>\n480<\/td>\n<\/tr>\n
    2015<\/td>\n500<\/td>\n<\/tr>\n
    2016<\/td>\n520<\/td>\n<\/tr>\n
    2017<\/td>\n560<\/td>\n<\/tr>\n
    2018<\/td>\n600<\/td>\n<\/tr>\n
    2019<\/td>\n630<\/td>\n<\/tr>\n
    2020<\/td>\n650<\/td>\n<\/tr>\n<\/table>\n
    Pour pr\u00e9dire les ventes pour 2022, utilisez :<\/p>\n
    =PREVISION(2022, B2:B10, A2:A10)<\/code><\/pre>\n
    Cas d’usage 2 : Estimation du prix de l’immobilier<\/h2>\n
    Consid\u00e9rons que vous \u00eates un agent immobilier et que vous disposiez des donn\u00e9es des prix des maisons selon leur superficie pour les derni\u00e8res transactions.<\/p>\n\n\n\n\n\n\n\n
    Superficie (m\u00b2)<\/th>\nPrix (en milliers d’euros)<\/th>\n<\/tr>\n
    50<\/td>\n200<\/td>\n<\/tr>\n
    60<\/td>\n240<\/td>\n<\/tr>\n
    70<\/td>\n280<\/td>\n<\/tr>\n
    80<\/td>\n320<\/td>\n<\/tr>\n
    90<\/td>\n360<\/td>\n<\/tr>\n<\/table>\n
    Pour estimer le prix d’une maison de 75 m\u00b2, vous pouvez utiliser :<\/p>\n
    =PREVISION(75, B2:B6, A2:A6)<\/code><\/pre>\n
    Cette fonction est extr\u00eamement utile pour fournir des estimations rapides bas\u00e9es sur des tendances historiques, facilitant la prise de d\u00e9cisions inform\u00e9es pour les agents immobiliers.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule une valeur par rapport \u00e0 une tendanCe lin\u00e9aire<\/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-6550","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction FORECAST (PREVISION) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction FORECAST (PREVISION) 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\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction FORECAST (PREVISION) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction FORECAST (PREVISION) 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\/\" \/>\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:31+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 (PREVISION) 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\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/forecast\/\",\"name\":\"Fonction FORECAST (PREVISION) 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:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction FORECAST (PREVISION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/forecast\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/forecast\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/forecast\/#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\"}]},{\"@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 (PREVISION) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction FORECAST (PREVISION) 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\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction FORECAST (PREVISION) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction FORECAST (PREVISION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/forecast\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:06:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction FORECAST (PREVISION) 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\/","url":"https:\/\/functiontranslator.com\/fr\/forecast\/","name":"Fonction FORECAST (PREVISION) 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:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction FORECAST (PREVISION) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/forecast\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/forecast\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/forecast\/#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"}]},{"@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\/6550","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=6550"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6550\/revisions"}],"predecessor-version":[{"id":29561,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6550\/revisions\/29561"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}