{"id":6781,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/ecartype-standard\/"},"modified":"2021-02-26T08:14:09","modified_gmt":"2021-02-26T08:14:09","slug":"stdev-s","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/stdev-s\/","title":{"rendered":"ECARTYPE.STANDARD"},"content":{"rendered":"

Lorsqu’on analyse des donn\u00e9es quantitatives, il est crucial de mesurer leur variabilit\u00e9 ou dispersion par rapport \u00e0 leur moyenne. Pour cela, on peut recourir \u00e0 la fonction de d\u00e9viation standard pour un \u00e9chantillon, nomm\u00e9e STDEV.S<\/strong> dans Microsoft Excel (ECARTYPE.STANDARD<\/strong> en version fran\u00e7aise) et Google Sheets.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de cette fonction est similaire dans Microsoft Excel et Google Sheets :<\/p>\n

 STDEV.S(nombre1; [nombre2]; ...)<\/code> <\/pre>\n
Les \u00e9l\u00e9ments nombre1<\/code>, nombre2<\/code>, etc. sont les arguments repr\u00e9sentant les valeurs ou les plages de cellules dont la d\u00e9viation standard doit \u00eatre calcul\u00e9e.<\/p>\n
Exemples d’utilisation<\/h2>\n
Voici comment on peut utiliser la fonction STDEV.S :<\/p>\n
 =STDEV.S(4, 5, 6, 7, 8) \/\/ Renvoie 1.58, repr\u00e9sentant la d\u00e9viation standard de ces cinq nombres =STDEV.S(A1:A5) \/\/ Calcule la d\u00e9viation standard des valeurs des cellules de A1 \u00e0 A5<\/code> <\/pre>\n
Applications pratiques de la fonction avec exemples<\/h2>\n
La d\u00e9viation standard est utile dans divers domaines tels que les \u00e9tudes scientifiques, l’ing\u00e9nierie de qualit\u00e9, ou la finance, pour \u00e9valuer la variation des donn\u00e9es. Voici quelques applications concr\u00e8tes :<\/p>\n
\u00c9tude de la variabilit\u00e9 des scores aux examens<\/h2>\n
Supposons que vous soyez enseignant et que vous vouliez analyser la variabilit\u00e9 des scores d\u2019un examen pour \u00e9valuer la consistence des performances des \u00e9tudiants. Utilisez la formule :<\/p>\n
 =STDEV.S(15; 18; 22; 20; 16)<\/code> <\/pre>\n
Un r\u00e9sultat \u00e9lev\u00e9 indique une grande variabilit\u00e9 des scores, tandis qu\u2019un r\u00e9sultat faible d\u00e9montre une plus grande coh\u00e9rence dans les performances.<\/p>\n
Analyse de la variabilit\u00e9 des retours d’investissement<\/h2>\n
Imaginez que vous soyez un analyste financier \u00e9tudiant les retours annuels d’un portefeuille de titres pour en \u00e9valuer le risque. La formule suivante peut \u00eatre utilis\u00e9e :<\/p>\n
    \n
  • Retours annuels (en %) : 8, 10, -2, 15, 5<\/li>\n
  • Formule pour calculer la d\u00e9viation standard des retours : =STDEV.S(8; 10; -2; 15; 5)<\/code><\/li>\n<\/ul>\n
    Un chiffre \u00e9lev\u00e9 sugg\u00e8re un risque plus important en raison de la forte variabilit\u00e9 des retours d’ann\u00e9e en ann\u00e9e.<\/p>\n
    Comprendre ces principes de base et savoir les appliquer dans des contextes pratiques est essentiel pour une utilisation efficace des fonctions dans Excel et Google Sheets, ainsi que pour l’interpr\u00e9tation judicieuse des analyses de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u00c9value l\u2019\u00c9cart type d\u2019une population en se basant sur un \u00c9chantillon de cette population<\/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-6781","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction STDEV.S (ECARTYPE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction STDEV.S (ECARTYPE.STANDARD) 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\/stdev-s\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction STDEV.S (ECARTYPE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction STDEV.S (ECARTYPE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/stdev-s\/\" \/>\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:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction STDEV.S (ECARTYPE.STANDARD) 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\/stdev-s\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/stdev-s\/\",\"name\":\"Fonction STDEV.S (ECARTYPE.STANDARD) 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:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction STDEV.S (ECARTYPE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdev-s\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/stdev-s\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdev-s\/#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\":\"ECARTYPE.STANDARD\"}]},{\"@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 STDEV.S (ECARTYPE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction STDEV.S (ECARTYPE.STANDARD) 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\/stdev-s\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction STDEV.S (ECARTYPE.STANDARD) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction STDEV.S (ECARTYPE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/stdev-s\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction STDEV.S (ECARTYPE.STANDARD) 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\/stdev-s\/","url":"https:\/\/functiontranslator.com\/fr\/stdev-s\/","name":"Fonction STDEV.S (ECARTYPE.STANDARD) 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:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction STDEV.S (ECARTYPE.STANDARD) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/stdev-s\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/stdev-s\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/stdev-s\/#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":"ECARTYPE.STANDARD"}]},{"@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\/6781","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=6781"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6781\/revisions"}],"predecessor-version":[{"id":29790,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6781\/revisions\/29790"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}