{"id":6502,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/somme-carres-ecarts\/"},"modified":"2021-02-26T08:04:55","modified_gmt":"2021-02-26T08:04:55","slug":"devsq","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/devsq\/","title":{"rendered":"SOMME.CARRES.ECARTS"},"content":{"rendered":"

Introduction \u00e0 la fonctionnalit\u00e9 dans Excel et Google Sheets<\/h2>\n

La fonction SOMME.CARRES.ECARTS<\/strong> est utilis\u00e9e pour calculer la somme des carr\u00e9s des \u00e9carts par rapport \u00e0 la moyenne d’une s\u00e9rie de nombres. Cette fonction est essentielle en statistique, car elle permet de mesurer la variance au sein d’un ensemble de donn\u00e9es.<\/p>\n

Syntaxe et utilisation<\/h2>\n

La syntaxe de la fonction SOMME.CARRES.ECARTS<\/strong> est la suivante :<\/p>\n

=SOMME.CARRES.ECARTS(nombre1, [nombre2], ...)<\/code><\/pre>\n
Cette fonction accepte une liste de nombres ou de plages de cellules. Elle commence par calculer la moyenne des valeurs saisies, puis elle additionne les carr\u00e9s des \u00e9carts de chaque nombre par rapport \u00e0 cette moyenne.<\/p>\n
    \n
  • nombre1, nombre2, …<\/strong> : Ces arguments peuvent \u00eatre des nombres, des r\u00e9f\u00e9rences de cellules, ou des plages, pour lesquels vous souhaitez mesurer la somme des carr\u00e9s des \u00e9carts.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Imaginons que vous poss\u00e9dez les notes d’un groupe d’\u00e9l\u00e8ves et souhaitez examiner la variabilit\u00e9 de ces notes.<\/p>\n\n\n\n\n\n\n
    \u00c9l\u00e8ve<\/td>\nNote<\/td>\n<\/tr>\n
    Alice<\/td>\n14<\/td>\n<\/tr>\n
    Bob<\/td>\n18<\/td>\n<\/tr>\n
    Clara<\/td>\n13<\/td>\n<\/tr>\n
    David<\/td>\n16<\/td>\n<\/tr>\n<\/table>\n
    =SOMME.CARRES.ECARTS(14, 18, 13, 16)<\/code><\/pre>\n
    Cette formule vous permet de calculer la somme des carr\u00e9s des \u00e9carts \u00e0 partir de la moyenne des notes.<\/p>\n
    Sc\u00e9narios pratiques<\/h2>\n
    \u00c9valuation de la dispersion dans un ensemble de donn\u00e9es<\/h2>\n
    Imaginez que vous \u00eates un analyste de donn\u00e9es analysant les variations des ventes quotidiennes d’une boutique durant un mois donn\u00e9 :<\/p>\n
      \n
    • 5, 6, 7, 8, 11, 5, 7, 6, 9, 10<\/li>\n<\/ul>\n
      =SOMME.CARRES.ECARTS(5, 6, 7, 8, 11, 5, 7, 6, 9, 10)<\/code><\/pre>\n
      Cette formule aide \u00e0 comprendre les variations des ventes d’un jour \u00e0 l’autre.<\/p>\n
      Comparaison de deux ensembles de donn\u00e9es<\/h2>\n
      Vous pouvez aussi utiliser SOMME.CARRES.ECARTS<\/strong> pour comparer la variabilit\u00e9 entre les scores de deux \u00e9quipes lors d’un tournoi :<\/p>\n
        \n
      • \u00c9quipe A : 10, 12, 14, 16<\/li>\n
      • \u00c9quipe B : 8, 11, 14, 17<\/li>\n<\/ul>\n
        =SOMME.CARRES.ECARTS(10, 12, 14, 16)<\/code><\/pre>\n
        =SOMME.CARRES.ECARTS(8, 11, 14, 17)<\/code><\/pre>\n
        Les sommations obtenues vous permettent de d\u00e9terminer quelle \u00e9quipe a la plus grande variabilit\u00e9 dans ses scores.<\/p>\n
         Ce code HTML offre une explication claire et professionnelle de l’utilisation de la fonction \u00ab\u00a0SOMME.CARRES.ECARTS\u00a0\u00bb dans Excel et Google Sheets, illustr\u00e9e par des contextes pratiques et des exemples pertinents.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Renvoie la somme des caRR\u00e9s des \u00e9caRts<\/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-6502","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction DEVSQ (SOMME.CARRES.ECARTS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DEVSQ (SOMME.CARRES.ECARTS) 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\/devsq\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DEVSQ (SOMME.CARRES.ECARTS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DEVSQ (SOMME.CARRES.ECARTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/devsq\/\" \/>\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:04:55+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DEVSQ (SOMME.CARRES.ECARTS) 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\/devsq\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/devsq\/\",\"name\":\"Fonction DEVSQ (SOMME.CARRES.ECARTS) 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:04:55+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DEVSQ (SOMME.CARRES.ECARTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/devsq\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/devsq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/devsq\/#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\":\"SOMME.CARRES.ECARTS\"}]},{\"@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 DEVSQ (SOMME.CARRES.ECARTS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DEVSQ (SOMME.CARRES.ECARTS) 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\/devsq\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DEVSQ (SOMME.CARRES.ECARTS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DEVSQ (SOMME.CARRES.ECARTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/devsq\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:55+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DEVSQ (SOMME.CARRES.ECARTS) 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\/devsq\/","url":"https:\/\/functiontranslator.com\/fr\/devsq\/","name":"Fonction DEVSQ (SOMME.CARRES.ECARTS) 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:04:55+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DEVSQ (SOMME.CARRES.ECARTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/devsq\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/devsq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/devsq\/#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":"SOMME.CARRES.ECARTS"}]},{"@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\/6502","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=6502"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6502\/revisions"}],"predecessor-version":[{"id":29514,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6502\/revisions\/29514"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}