{"id":6772,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/pente\/"},"modified":"2021-02-26T08:13:49","modified_gmt":"2021-02-26T08:13:49","slug":"slope","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/slope\/","title":{"rendered":"PENTE"},"content":{"rendered":"

Introduction \u00e0 la fonction de calcul de pente<\/h2>\n

La fonction de calcul de pente dans MS Excel et Google Sheets est essentielle pour l’analyse statistique, notamment pour les analyses de r\u00e9gression lin\u00e9aire. Elle sert \u00e0 d\u00e9terminer la pente de la droite de r\u00e9gression lin\u00e9aire d\u2019un ensemble de donn\u00e9es appari\u00e9es.<\/p>\n

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

Voici la syntaxe de cette fonction dans MS Excel et Google Sheets :<\/p>\n

=PENTE(donn\u00e9es_y; donn\u00e9es_x)<\/code><\/pre>\n
o\u00f9 donn\u00e9es_y<\/code> correspond \u00e0 la plage des valeurs d\u00e9pendantes et donn\u00e9es_x<\/code> \u00e0 la plage des valeurs ind\u00e9pendantes.<\/p>\n
Exemple d\u2019utilisation :<\/p>\n
    \n
  • Si dans une feuille de calcul, A1:A5<\/code> contient les valeurs x et B1:B5<\/code> les valeurs y correspondantes, la formule pour calculer la pente de ces donn\u00e9es serait :\n
    =PENTE(B1:B5; A1:A5)<\/code><\/pre>\n<\/li>\n<\/ul>\n
    Zones d’application<\/h2>\n
    Cette fonction est largement utilis\u00e9e dans divers domaines comme l’\u00e9conomie, la biologie et l’ing\u00e9nierie pour mod\u00e9liser les relations entre deux variables quantitatives.<\/p>\n
    Exemples pratiques<\/h2>\n
    Ci-dessous, vous trouverez quelques sc\u00e9narios o\u00f9 cette fonction peut se r\u00e9v\u00e9ler particuli\u00e8rement pr\u00e9cieuse.<\/p>\n
    Sc\u00e9nario 1 : Analyse \u00e9conomique<\/h2>\n
    Imaginons qu\u2019un \u00e9conomiste cherche \u00e0 analyser la relation entre le revenu des m\u00e9nages (x) et leur consommation (y). Les donn\u00e9es sont repr\u00e9sent\u00e9es comme suit :<\/p>\n\n\n\n\n\n\n\n
    Revenu (x)<\/th>\nConsommation (y)<\/th>\n<\/tr>\n
    30000<\/td>\n22000<\/td>\n<\/tr>\n
    40000<\/td>\n27000<\/td>\n<\/tr>\n
    50000<\/td>\n32000<\/td>\n<\/tr>\n
    60000<\/td>\n37000<\/td>\n<\/tr>\n
    70000<\/td>\n42000<\/td>\n<\/tr>\n<\/table>\n
    Pour calculer le coefficient de pente, utilisez la formule suivante : <\/p>\n
    =PENTE(B2:B6; A2:A6)<\/code><\/pre>\n
     Ce calcul vous fournira la pente de la r\u00e9gression lin\u00e9aire, et offrira une estimation de l\u2019augmentation moyenne de la consommation pour chaque augmentation unitaire du revenu.<\/p>\n
    Sc\u00e9nario 2 : Recherche scientifique<\/h2>\n
    Un biologiste \u00e9tudie l’impact de la quantit\u00e9 d’engrais utilis\u00e9e sur la croissance des plantes. Les donn\u00e9es collect\u00e9es se pr\u00e9sentent comme suit :<\/p>\n\n\n\n\n\n\n\n
    Engrais (x en grammes)<\/th>\nCroissance (y en cm)<\/th>\n<\/tr>\n
    10<\/td>\n5<\/td>\n<\/tr>\n
    20<\/td>\n12<\/td>\n<\/tr>\n
    30<\/td>\n19<\/td>\n<\/tr>\n
    40<\/td>\n25<\/td>\n<\/tr>\n
    50<\/td>\n32<\/td>\n<\/tr>\n<\/table>\n
    Pour obtenir l’\u00e9quation de la pente, appliquez la formule suivante : <\/p>\n
    =PENTE(B2:B6; A2:A6)<\/code><\/pre>\n
     Ce r\u00e9sultat vous permettra d’\u00e9valuer l’efficacit\u00e9 de l’engrais sur la croissance des plantes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la pente d\u2019une dRoite de R\u00e9gRession 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-6772","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction SLOPE (PENTE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SLOPE (PENTE) 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\/slope\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SLOPE (PENTE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SLOPE (PENTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/slope\/\" \/>\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:13:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SLOPE (PENTE) 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\/slope\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/slope\/\",\"name\":\"Fonction SLOPE (PENTE) 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:13:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SLOPE (PENTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/slope\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/slope\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/slope\/#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\":\"PENTE\"}]},{\"@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 SLOPE (PENTE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SLOPE (PENTE) 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\/slope\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SLOPE (PENTE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SLOPE (PENTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/slope\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SLOPE (PENTE) 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\/slope\/","url":"https:\/\/functiontranslator.com\/fr\/slope\/","name":"Fonction SLOPE (PENTE) 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:13:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SLOPE (PENTE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/slope\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/slope\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/slope\/#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":"PENTE"}]},{"@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\/6772","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=6772"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6772\/revisions"}],"predecessor-version":[{"id":29782,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6772\/revisions\/29782"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}