{"id":6523,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/erfc\/"},"modified":"2021-02-26T08:05:46","modified_gmt":"2021-02-26T08:05:46","slug":"erfc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/erfc\/","title":{"rendered":"ERFC"},"content":{"rendered":"

La fonction ERFC, qui correspond \u00e0 la \u00ab\u00a0fonction compl\u00e9mentaire d’erreur\u00a0\u00bb, est utilis\u00e9e pour calculer la valeur compl\u00e9mentaire de la fonction d’erreur int\u00e9grale. Cette fonction math\u00e9matique est essentielle dans l’analyse de distributions normales de probabilit\u00e9s et trouve son utilit\u00e9 dans des domaines vari\u00e9s tels que l’ing\u00e9nierie, la statistique et la physique, notamment pour des calculs li\u00e9s \u00e0 des distributions de probabilit\u00e9s normales.<\/p>\n

D\u00e9tail de la syntaxe<\/h2>\n

La fonction ERFC fonctionne de mani\u00e8re identique dans Microsoft Excel et Google Sheets. Sa syntaxe est la suivante :<\/p>\n

ERFC(x)<\/code><\/pre>\n
    \n
  • x<\/strong> : La valeur num\u00e9rique pour laquelle vous souhaitez calculer la compl\u00e9mentaire d’erreur.<\/li>\n<\/ul>\n
    La valeur renvoy\u00e9e se situe toujours entre 0 et 1 et repr\u00e9sente la probabilit\u00e9 qu’une variable al\u00e9atoire normalement distribu\u00e9e d\u00e9passe la valeur de x<\/em>.<\/p>\n
    Exemples d’utilisation<\/h2>\n
    Voici comment vous pourriez utiliser la fonction ERFC pour estimer des probabilit\u00e9s dans diff\u00e9rentes situations :<\/p>\n
    =ERFC(1.5)<\/code><\/pre>\n
    Cette formule vous permet de calculer la fonction compl\u00e9mentaire d’erreur pour 1.5.<\/p>\n
    Applications pratiques<\/h2>\n
    Illustrons maintenant quelques cas pratiques o\u00f9 la fonction ERFC peut s’av\u00e9rer b\u00e9n\u00e9fique.<\/p>\n
    Cas pratique 1 : Comparaison des performances de processus<\/h2>\n
    Supposons que vous souhaitiez \u00e9valuer la performance d’un processus de fabrication avec une production normalement distribu\u00e9e. Le processus serait jug\u00e9 acceptable si moins de 2% des pi\u00e8ces sont hors sp\u00e9cifications, ces derni\u00e8res \u00e9tant fix\u00e9es \u00e0 3 \u00e9carts-types au-dessus de la moyenne.<\/p>\n
    Application concr\u00e8te avec ERFC :<\/p>\n
    =ERFC(3)<\/code><\/pre>\n
    Cette op\u00e9ration calcule la probabilit\u00e9 que la production exc\u00e8de 3 \u00e9carts-types de la moyenne, repr\u00e9sentant ainsi la proportion de pi\u00e8ces d\u00e9fectueuses produites par le processus.<\/p>\n
    Cas pratique 2 : Calcul de la fiabilit\u00e9 dans l’ing\u00e9nierie<\/h2>\n
    Dans le domaine de l’ing\u00e9nierie, la fiabilit\u00e9 d’un composant peut \u00eatre repr\u00e9sent\u00e9e par une variable al\u00e9atoire normalement distribu\u00e9e. Imaginez que pour qu\u2019un composant soit consid\u00e9r\u00e9 comme fiable, il doit fonctionner sans faille pendant au moins 10 000 heures, ce qui correspond \u00e0 1.5 fois l\u2019\u00e9cart type au-dessus de la moyenne de temps de d\u00e9faillance de 8 000 heures.<\/p>\n
    Utilisation pratique de la fonction ERFC :<\/p>\n
    =ERFC(1.5)<\/code><\/pre>\n
    Cette formule d\u00e9termine la probabilit\u00e9 que le composant fonctionne moins de 10 000 heures, soit 1,5 \u00e9carts-types au-dessus de la moyenne.<\/p>\n\n\n\n\n
    Fonction<\/th>\nDescription<\/th>\nExemple<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    ERFC(1.5)<\/td>\nCalcule la fonction compl\u00e9mentaire d’erreur pour 1.5<\/td>\nERFC(1.5)<\/td>\n~0.033<\/td>\n<\/tr>\n
    ERFC(3)<\/td>\nCalcule la fonction compl\u00e9mentaire d’erreur pour 3<\/td>\nERFC(3)<\/td>\n~0.000<\/td>\n<\/tr>\n<\/table>\n
    En utilisant la fonction ERFC, vous pouvez effectuer des calculs statistiques complexes de mani\u00e8re simple et pr\u00e9cise dans vos feuilles de calcul pour l’analyse de donn\u00e9es ou la mod\u00e9lisation pr\u00e9dictive.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR de la fonction d\u2019eRReuR compl\u00e9mentaiRe<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316],"tags":[],"class_list":["post-6523","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction ERFC dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ERFC 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\/erfc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ERFC dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ERFC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/erfc\/\" \/>\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:05:46+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ERFC 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\/erfc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/erfc\/\",\"name\":\"Fonction ERFC 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:05:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ERFC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/erfc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/erfc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/erfc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ing\u00e9nierie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/ingenierie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ERFC\"}]},{\"@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 ERFC dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ERFC 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\/erfc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ERFC dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ERFC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/erfc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ERFC 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\/erfc\/","url":"https:\/\/functiontranslator.com\/fr\/erfc\/","name":"Fonction ERFC 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:05:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ERFC d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/erfc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/erfc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/erfc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Ing\u00e9nierie","item":"https:\/\/functiontranslator.com\/fr\/ingenierie\/"},{"@type":"ListItem","position":3,"name":"ERFC"}]},{"@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\/6523","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=6523"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6523\/revisions"}],"predecessor-version":[{"id":29535,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6523\/revisions\/29535"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}