{"id":6785,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/erreur-type-xy\/"},"modified":"2021-02-26T08:14:16","modified_gmt":"2021-02-26T08:14:16","slug":"steyx","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/steyx\/","title":{"rendered":"ERREUR.TYPE.XY"},"content":{"rendered":"

Introduction \u00e0 la fonction ERREUR.TYPE.XY<\/h2>\n

La fonction ERREUR.TYPE.XY, d\u00e9sign\u00e9e par le code STEYX<\/code> dans Microsoft Excel, est utilis\u00e9e pour calculer l’erreur standard de l’estimation en r\u00e9gression lin\u00e9aire. Elle repr\u00e9sente un outil statistique essentiel, id\u00e9al pour \u00e9valuer la fiabilit\u00e9 des pr\u00e9dictions g\u00e9n\u00e9r\u00e9es par une ligne de tendance.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction STEYX<\/code> dans Excel est la suivante :<\/p>\n

STEYX(donn\u00e9es_y, donn\u00e9es_x)<\/code><\/pre>\n
o\u00f9 :<\/p>\n
    \n
  • donn\u00e9es_y<\/strong> : l’ensemble de points de donn\u00e9es de la variable d\u00e9pendante.<\/li>\n
  • donn\u00e9es_x<\/strong> : l’ensemble de points de donn\u00e9es de la variable ind\u00e9pendante.<\/li>\n<\/ul>\n
    Exemples pratiques<\/h2>\n
    Illustrons l’utilisation de cette fonction avec des exemples concrets.<\/p>\n
    Exemple 1 : Analyse de la performance des ventes<\/h2>\n
    Supposons que vous vouliez examiner la relation entre des d\u00e9penses publicitaires et les ventes d’un produit. Consid\u00e9rez les donn\u00e9es suivantes :<\/p>\n\n\n\n\n\n
    D\u00e9penses publicitaires (x)<\/th>\nVentes (y)<\/th>\n<\/tr>\n
    1000<\/td>\n30000<\/td>\n<\/tr>\n
    2000<\/td>\n35000<\/td>\n<\/tr>\n
    3000<\/td>\n40000<\/td>\n<\/tr>\n<\/table>\n
    Pour d\u00e9terminer l’erreur standard de cette estimation de r\u00e9gression, utilisez la formule suivante dans Excel :<\/p>\n
    =STEYX(B2:B4, A2:A4)<\/code><\/pre>\n
    Le r\u00e9sultat vous indiquera la pr\u00e9cision avec laquelle les d\u00e9penses publicitaires peuvent pr\u00e9dire les ventes.<\/p>\n
    Exemple 2 : Pr\u00e9vision acad\u00e9mique<\/h2>\n
    Imaginez que vous \u00eates un conseiller acad\u00e9mique analysant le lien entre le nombre d’heures d’\u00e9tude et les r\u00e9sultats des examens. Les donn\u00e9es rassembl\u00e9es sont les suivantes :<\/p>\n\n\n\n\n\n\n
    Heures d’\u00e9tude (x)<\/th>\nScore du test (y)<\/th>\n<\/tr>\n
    10<\/td>\n65<\/td>\n<\/tr>\n
    8<\/td>\n70<\/td>\n<\/tr>\n
    15<\/td>\n80<\/td>\n<\/tr>\n
    20<\/td>\n90<\/td>\n<\/tr>\n<\/table>\n
    La formule pour calculer l’erreur standard dans ce cas est :<\/p>\n
    =STEYX(B2:B5, A2:A5)<\/code><\/pre>\n
    Ce chiffre vous aidera \u00e0 \u00e9valuer la fiabilit\u00e9 des heures d’\u00e9tude comme indicateur des performances aux tests.<\/p>\n
    Conclusion<\/h2>\n
    La fonction ERREUR.TYPE.XY est indispensable pour quiconque effectue des pr\u00e9visions statistiques, car elle permet d’obtenir une estimation de la variabilit\u00e9 dans les pr\u00e9dictions de r\u00e9gression lin\u00e9aire. Avec cette fonction, les analystes peuvent quantifier la pr\u00e9cision des pr\u00e9dictions de mani\u00e8re efficace.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019eRReuR type de la valeuR y pR\u00e9vue pouR chaque x de la R\u00e9gRession<\/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-6785","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction STEYX (ERREUR.TYPE.XY) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction STEYX (ERREUR.TYPE.XY) 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\/steyx\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction STEYX (ERREUR.TYPE.XY) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction STEYX (ERREUR.TYPE.XY) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/steyx\/\" \/>\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:14:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction STEYX (ERREUR.TYPE.XY) 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\/steyx\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/steyx\/\",\"name\":\"Fonction STEYX (ERREUR.TYPE.XY) 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:14:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction STEYX (ERREUR.TYPE.XY) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/steyx\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/steyx\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/steyx\/#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\":\"ERREUR.TYPE.XY\"}]},{\"@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 STEYX (ERREUR.TYPE.XY) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction STEYX (ERREUR.TYPE.XY) 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\/steyx\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction STEYX (ERREUR.TYPE.XY) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction STEYX (ERREUR.TYPE.XY) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/steyx\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction STEYX (ERREUR.TYPE.XY) 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\/steyx\/","url":"https:\/\/functiontranslator.com\/fr\/steyx\/","name":"Fonction STEYX (ERREUR.TYPE.XY) 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:14:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction STEYX (ERREUR.TYPE.XY) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/steyx\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/steyx\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/steyx\/#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":"ERREUR.TYPE.XY"}]},{"@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\/6785","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=6785"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6785\/revisions"}],"predecessor-version":[{"id":29794,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6785\/revisions\/29794"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}