{"id":6617,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/ordonnee-origine\/"},"modified":"2021-02-26T08:08:43","modified_gmt":"2021-02-26T08:08:43","slug":"intercept","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/intercept\/","title":{"rendered":"ORDONNEE.ORIGINE"},"content":{"rendered":"

L’ordonn\u00e9e \u00e0 l’origine, \u00e9galement connue sous le terme d’interception, est une fonction statistique largement utilis\u00e9e dans les analyses de r\u00e9gression lin\u00e9aire. Elle permet de d\u00e9terminer le point o\u00f9 la droite de r\u00e9gression coupe l’axe des ordonn\u00e9es, ce qui est essentiel pour examiner la relation entre deux variables quantitatives. Cette fonction est impl\u00e9ment\u00e9e dans des logiciels de feuilles de calcul tels que Microsoft Excel et Google Sheets, o\u00f9 elle est appel\u00e9e INTERCEPT<\/code> en anglais et ORDONNEE.ORIGINE<\/code> en fran\u00e7ais.<\/p>\n

Explication du fonctionnement<\/h2>\n

La fonction ORDONNEE.ORIGINE<\/code> calcule l’ordonn\u00e9e \u00e0 l’origine (b) de la droite de r\u00e9gression lin\u00e9aire des y en fonction des x, bas\u00e9e sur l’\u00e9quation y = mx + b, o\u00f9 b repr\u00e9sente justement cette ordonn\u00e9e \u00e0 l’origine.<\/p>\n

Syntaxe dans Excel et Google Sheets :<\/strong><\/p>\n

 ORDONNEE.ORIGINE(y, x)<\/code> <\/pre>\n
    \n
  • y<\/code> : La plage de cellules qui contient les valeurs d\u00e9pendantes.<\/li>\n
  • x<\/code> : La plage de cellules qui contient les valeurs ind\u00e9pendantes.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Ci-dessous, vous trouverez des exemples concrets d\u00e9montrant comment utiliser la fonction ORDONNEE.ORIGINE<\/code> dans diff\u00e9rents sc\u00e9narios.<\/p>\n
    Exemple 1: Analyse de vente<\/h2>\n
    Imaginons que nous avons acc\u00e8s aux donn\u00e9es de vente mensuelles d’une boutique et que nous souhaitons pr\u00e9dire les revenus en fonction du nombre d\u2019heures d\u2019ouverture. Les heures d’ouverture sont enregistr\u00e9es dans la colonne A et les revenus dans la colonne B.<\/p>\n\n\n\n\n\n
    Heures<\/th>\nRevenu (en \u20ac)<\/th>\n<\/tr>\n
    40<\/td>\n200<\/td>\n<\/tr>\n
    50<\/td>\n250<\/td>\n<\/tr>\n
    60<\/td>\n300<\/td>\n<\/tr>\n<\/table>\n
    La formule pour calculer l’ordonn\u00e9e \u00e0 l’origine est :<\/p>\n
     =ORDONNEE.ORIGINE(B1:B3, A1:A3)<\/code> <\/pre>\n
    Apr\u00e8s application de cette formule, nous obtiendrons l’estimation des revenus lorsque le nombre d’heures d’ouverture est z\u00e9ro, ce qui peut aider \u00e0 comprendre le montant fixe des revenus en dehors des heures d’ouverture.<\/p>\n
    Exemple 2: Corr\u00e9lation entre poids et taille dans une \u00e9tude m\u00e9dicale<\/h2>\n
    Consid\u00e9rons une \u00e9tude analysant la relation entre le poids et la taille. Nous pourrions avoir les donn\u00e9es suivantes :<\/p>\n\n\n\n\n\n
    Taille (cm)<\/th>\nPoids (kg)<\/th>\n<\/tr>\n
    150<\/td>\n50<\/td>\n<\/tr>\n
    160<\/td>\n60<\/td>\n<\/tr>\n
    170<\/td>\n70<\/td>\n<\/tr>\n<\/table>\n
    En appliquant la formule suivante :<\/p>\n
     =ORDONNEE.ORIGINE(B1:B3, A1:A3)<\/code> <\/pre>\n
    Cela nous fournira une estimation du poids pour une taille nulle, ce qui est, bien s\u00fbr, irr\u00e9aliste biologiquement, mais fournit une base \u00e0 partir de laquelle le poids augmente proportionnellement \u00e0 la taille. Cette information est particuli\u00e8rement utile lors de l’ajustement de mod\u00e8les pr\u00e9dictifs.<\/p>\n
    La fonction ORDONNEE.ORIGINE<\/code> trouve des applications \u00e9tendues dans les domaines n\u00e9cessitant des mod\u00e9lisations lin\u00e9aires et des pr\u00e9dictions bas\u00e9es sur des donn\u00e9es historiques ou exp\u00e9rimentales.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019oRdonn\u00e9e \u00e0 l\u2019oRigine 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-6617","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction INTERCEPT (ORDONNEE.ORIGINE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction INTERCEPT (ORDONNEE.ORIGINE) 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\/intercept\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction INTERCEPT (ORDONNEE.ORIGINE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction INTERCEPT (ORDONNEE.ORIGINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/intercept\/\" \/>\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:08:43+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction INTERCEPT (ORDONNEE.ORIGINE) 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\/intercept\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/intercept\/\",\"name\":\"Fonction INTERCEPT (ORDONNEE.ORIGINE) 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:08:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction INTERCEPT (ORDONNEE.ORIGINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/intercept\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/intercept\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/intercept\/#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\":\"ORDONNEE.ORIGINE\"}]},{\"@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 INTERCEPT (ORDONNEE.ORIGINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction INTERCEPT (ORDONNEE.ORIGINE) 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\/intercept\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction INTERCEPT (ORDONNEE.ORIGINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction INTERCEPT (ORDONNEE.ORIGINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/intercept\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction INTERCEPT (ORDONNEE.ORIGINE) 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\/intercept\/","url":"https:\/\/functiontranslator.com\/fr\/intercept\/","name":"Fonction INTERCEPT (ORDONNEE.ORIGINE) 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:08:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction INTERCEPT (ORDONNEE.ORIGINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/intercept\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/intercept\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/intercept\/#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":"ORDONNEE.ORIGINE"}]},{"@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\/6617","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=6617"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6617\/revisions"}],"predecessor-version":[{"id":29628,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6617\/revisions\/29628"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}