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

Introduction \u00e0 la fonction \u00c9cart Type Total<\/strong><\/p>\n

Dans Microsoft Excel et Google Sheets, la fonction STDEVPA<\/code> permet de calculer l’\u00e9cart type d’un ensemble de donn\u00e9es, en incluant les valeurs textuelles et les valeurs logiques (TRUE\/FALSE) dans le calcul. Les valeurs textuelles sont consid\u00e9r\u00e9es comme 0, tandis que les valeurs logiques TRUE et FALSE sont prises en compte comme 1 et 0 respectivement.<\/p>\n

Syntaxe<\/h2>\n

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

=STDEVPA(valeur1, [valeur2], ...)<\/code><\/pre>\n
o\u00f9 valeur1<\/code>, valeur2<\/code>, …, repr\u00e9sentent les arguments qui peuvent \u00eatre des nombres, des r\u00e9f\u00e9rences de cellules, ou des plages contenant des donn\u00e9es, y compris des \u00e9l\u00e9ments num\u00e9riques et textuels.<\/p>\n
Exemple simple :<\/p>\n
=STDEVPA(2, \"texte\", TRUE, FALSE, 5, 3)<\/code><\/pre>\n
    \n
  • Les valeurs num\u00e9riques sont utilis\u00e9es telles quelles.<\/li>\n
  • La cha\u00eene de texte \u00ab\u00a0texte\u00a0\u00bb est interpr\u00e9t\u00e9e comme 0.<\/li>\n
  • TRUE est consid\u00e9r\u00e9 comme 1 et FALSE comme 0.<\/li>\n<\/ul>\n
    Cela aboutirait \u00e0 un \u00e9cart type calcul\u00e9 \u00e0 partir des valeurs 2, 0, 1, 0, 5, 3.<\/p>\n
    Utilisations pratiques<\/h2>\n
    Voici maintenant quelques exemples pratiques de l’utilisation de cette fonction.<\/p>\n
    Exemple 1 : Analyse de donn\u00e9es de sondage<\/strong><\/p>\n
    Imaginons que vous disposez d’un ensemble de donn\u00e9es repr\u00e9sentant les r\u00e9ponses \u00e0 un sondage, o\u00f9 les r\u00e9ponses \u00ab\u00a0oui\u00a0\u00bb et \u00ab\u00a0non\u00a0\u00bb sont cod\u00e9es par TRUE et FALSE. Vous souhaitez calculer l’\u00e9cart type de ces r\u00e9ponses pour analyser la variabilit\u00e9 des opinions.<\/p>\n
    =STDEVPA(A2:A100)<\/code><\/pre>\n
    Ici, la plage A2:A100 contient des valeurs TRUE et FALSE. Cette formule vous permettra de saisir l’\u00e9tendue de variation des r\u00e9ponses par rapport \u00e0 la moyenne.<\/p>\n
    Exemple 2 : \u00c9valuation de la diversit\u00e9 des ventes<\/strong><\/p>\n
    Supposez que vous g\u00e9rez un inventaire dans lequel certains articles n’ont pas encore \u00e9t\u00e9 vendus (‘aucun’, interpr\u00e9t\u00e9 comme 0), tandis que d’autres articles ont \u00e9t\u00e9 vendus en quantit\u00e9s variables. Vous pourriez utiliser STDEVPA<\/code> pour \u00e9valuer la variabilit\u00e9 de vos ventes.<\/p>\n
    =STDEVPA(B2:B50)<\/code><\/pre>\n
    Dans cet exemple, B2:B50 inclut des nombres et des occurrences du texte ‘aucun’. Cette statistique vous aidera \u00e0 comprendre \u00e0 quel point les ventes des diff\u00e9rents articles sont stables ou variables.<\/p>\n
    En r\u00e9sum\u00e9, STDEVPA<\/code> est extr\u00eamement b\u00e9n\u00e9fique pour analyser des ensembles de donn\u00e9es comprenant diff\u00e9rents types de donn\u00e9es, et permet de calculer leur \u00e9cart type en int\u00e9grant \u00e0 la fois des valeurs num\u00e9riques et non num\u00e9riques dans l’analyse.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule l\u2019\u00e9Cart type d\u2019une population \u00e0 partir de l\u2019ensemble de la 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-6784","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction STDEVPA dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction STDEVPA 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\/stdevpa\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction STDEVPA dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction STDEVPA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/stdevpa\/\" \/>\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:15+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction STDEVPA 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\/stdevpa\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/stdevpa\/\",\"name\":\"Fonction STDEVPA 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:15+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction STDEVPA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdevpa\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/stdevpa\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/stdevpa\/#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\":\"STDEVPA\"}]},{\"@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 STDEVPA dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction STDEVPA 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\/stdevpa\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction STDEVPA dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction STDEVPA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/stdevpa\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:15+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction STDEVPA 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\/stdevpa\/","url":"https:\/\/functiontranslator.com\/fr\/stdevpa\/","name":"Fonction STDEVPA 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:15+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction STDEVPA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/stdevpa\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/stdevpa\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/stdevpa\/#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":"STDEVPA"}]},{"@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\/6784","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=6784"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6784\/revisions"}],"predecessor-version":[{"id":29793,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6784\/revisions\/29793"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}