{"id":6782,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/stdeva\/"},"modified":"2021-02-26T08:14:11","modified_gmt":"2021-02-26T08:14:11","slug":"stdeva","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/stdeva\/","title":{"rendered":"STDEVA"},"content":{"rendered":"

Fonction STDEVA :<\/strong> La fonction STDEVA de Microsoft Excel et Google Sheets est utilis\u00e9e pour calculer l’\u00e9cart type d’un ensemble de valeurs. Cette fonction inclut \u00e0 la fois les valeurs num\u00e9riques, textuelles et logiques dans son calcul. Il est important de noter que le traitement des valeurs textuelles et logiques diff\u00e8re entre Excel et Google Sheets : dans Excel, les valeurs textuelles sont consid\u00e9r\u00e9es comme 0 et les valeurs TRUE\/FALSE sont trait\u00e9es comme 1\/0, tandis que Google Sheets exclut les valeurs non num\u00e9riques.<\/p>\n

Utilisation et Syntaxe<\/h2>\n

La syntaxe de la fonction STDEVA est la suivante :<\/p>\n

=STDEVA(valeur1, [valeur2], ...)<\/code><\/pre>\n
    \n
  • valeur1, valeur2, …<\/strong> : Repr\u00e9sentent les valeurs ou les plages de cellules pour lesquelles l’\u00e9cart type est \u00e0 calculer.<\/li>\n<\/ul>\n
    Exemples d’application<\/h2>\n
    Voici des exemples concrets d’utilisation de la fonction STDEVA dans diff\u00e9rents contextes.<\/p>\n
    \u00c9valuation de la Variabilit\u00e9 des Scores<\/h2>\n
    Pour analyser la variabilit\u00e9 des scores d’une classe d’\u00e9tudiants afin d’\u00e9valuer la dispersion par rapport \u00e0 la moyenne, consid\u00e9rez le tableau suivant :<\/p>\n\n\n\n\n\n\n\n
    \u00c9l\u00e8ve<\/th>\nScore<\/th>\n<\/tr>\n
    Jean<\/td>\n82<\/td>\n<\/tr>\n
    Isabelle<\/td>\n91<\/td>\n<\/tr>\n
    Marc<\/td>\n78<\/td>\n<\/tr>\n
    L\u00e9a<\/td>\n84<\/td>\n<\/tr>\n
    Thomas<\/td>\n77<\/td>\n<\/tr>\n<\/table>\n
    =STDEVA(B2:B6)<\/code><\/pre>\n
    Cette formule permet de calculer l’\u00e9cart type des scores, donnant ainsi une mesure de la dispersion des scores autour de leur moyenne.<\/p>\n
    Comparaison de Data Sets avec Valeurs Logiques<\/h2>\n
    Une entreprise souhaite \u00e9valuer la variation entre deux ensembles de donn\u00e9es de vente, incluant des valeurs logiques (e.g., TRUE pour une vente r\u00e9ussie, FALSE autrement) :<\/p>\n\n\n\n\n\n\n\n
    Mois<\/th>\nVentes Set 1<\/th>\nVentes Set 2<\/th>\n<\/tr>\n
    Janvier<\/td>\nTRUE<\/td>\n120<\/td>\n<\/tr>\n
    F\u00e9vrier<\/td>\nFALSE<\/td>\n110<\/td>\n<\/tr>\n
    Mars<\/td>\nTRUE<\/td>\n130<\/td>\n<\/tr>\n
    Avril<\/td>\n120<\/td>\nTRUE<\/td>\n<\/tr>\n
    Mai<\/td>\nFALSE<\/td>\n125<\/td>\n<\/tr>\n<\/table>\n
    =STDEVA(B2:B6) \/\/ Pour Set 1 =STDEVA(C2:C6) \/\/ Pour Set 2<\/code><\/pre>\n
    Ces formules calculent l’\u00e9cart type pour chaque ensemble de donn\u00e9es, en tenant compte des valeurs TRUE et FALSE qui, dans Excel, sont converties en 1 et 0 respectivement pour les calculs.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u00c9value l\u2019\u00c9cart type d\u2019une population en se basant sur un \u00c9chantillon de cette population, nombres, texte et valeurs logiques inclus<\/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-6782","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction STDEVA dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction STDEVA 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\/stdeva\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction STDEVA dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction STDEVA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/stdeva\/\" \/>\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:11+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction STDEVA 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdeva\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/stdeva\/\",\"name\":\"Fonction STDEVA 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:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction STDEVA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdeva\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/stdeva\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdeva\/#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\":\"STDEVA\"}]},{\"@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 STDEVA dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction STDEVA 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\/stdeva\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction STDEVA dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction STDEVA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/stdeva\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction STDEVA dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/stdeva\/","url":"https:\/\/functiontranslator.com\/fr\/stdeva\/","name":"Fonction STDEVA 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:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction STDEVA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/stdeva\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/stdeva\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/stdeva\/#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":"STDEVA"}]},{"@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\/6782","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=6782"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6782\/revisions"}],"predecessor-version":[{"id":29791,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6782\/revisions\/29791"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}