{"id":6512,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/bdecartypep\/"},"modified":"2021-02-26T08:05:13","modified_gmt":"2021-02-26T08:05:13","slug":"dstdevp","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dstdevp\/","title":{"rendered":"BDECARTYPEP"},"content":{"rendered":"

Description de la fonction :<\/strong> La fonction DSTDEVP<\/code> ou BDECARTYPEP<\/code> en fran\u00e7ais, permet de calculer l’\u00e9cart type d’une population enti\u00e8re \u00e0 partir d’une base de donn\u00e9es structur\u00e9e. Cette fonction est id\u00e9ale pour analyser la variabilit\u00e9 des sous-ensembles de donn\u00e9es au sein d’une base de donn\u00e9es exhaustive.<\/p>\n

Syntaxe et exemples<\/h2>\n

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

BDECARTYPEP(base_de_donn\u00e9es, champ, crit\u00e8res)<\/code><\/pre>\n
    \n
  • base_de_donn\u00e9es<\/strong> : Correspond \u00e0 la plage de cellules qui repr\u00e9sente la base de donn\u00e9es.<\/li>\n
  • champ<\/strong> : Sp\u00e9cifie la colonne sur laquelle l’\u00e9cart type est calcul\u00e9. Ce param\u00e8tre peut \u00eatre un index num\u00e9rique de colonne ou le nom de la colonne entre guillemets.<\/li>\n
  • crit\u00e8res<\/strong> : D\u00e9signe la plage de cellules contenant les crit\u00e8res qui filtreront les donn\u00e9es \u00e0 analyser.<\/li>\n<\/ul>\n
    Exemple :<\/strong> Imaginez que vous disposez d’une base de donn\u00e9es comprenant les salaires par d\u00e9partement au sein d’une soci\u00e9t\u00e9, et vous souhaitez calculer l’\u00e9cart type des salaires du d\u00e9partement des ventes. Voici comment utiliser la fonction :<\/p>\n
    = BDECARTYPEP(A1:C20, \"Salaire\", F1:F2)<\/code><\/pre>\n
    Cette formule d\u00e9termine l’\u00e9cart type des salaires au sein du d\u00e9partement des ventes, o\u00f9 A1:C20<\/code> repr\u00e9sente la base de donn\u00e9es, \u00ab\u00a0Salaire\u00a0\u00bb la colonne des salaires, et F1:F2<\/code> les crit\u00e8res indiquant que le d\u00e9partement concern\u00e9 est celui des ventes.<\/p>\n
    Sc\u00e9narios d’application pratiques<\/h2>\n
    Sc\u00e9nario 1: Analyse de l’\u00e9cart salarial<\/strong><\/p>\n
    Pour examiner les diff\u00e9rences de salaires entre les d\u00e9partements afin de rep\u00e9rer d’\u00e9ventuelles in\u00e9galit\u00e9s :<\/p>\n
      \n
    • Classer les donn\u00e9es salariales par d\u00e9partement.<\/li>\n
    • Utiliser BDECARTYPEP<\/code> pour chaque d\u00e9partement en ajustant les crit\u00e8res de fa\u00e7on \u00e0 cibler chaque d\u00e9partement individuellement.<\/li>\n
    • Comparer les \u00e9carts de type obtenus pour identifier les disparit\u00e9s importantes entre les diff\u00e9rents d\u00e9partements.<\/li>\n<\/ul>\n
      Formules :<\/strong><\/p>\n
      = BDECARTYPEP(A1:C100, \"Salaire\", G1:G2) \/\/ \u00c9cart type pour le d\u00e9partement des ventes = BDECARTYPEP(A1:C100, \"Salaire\", G3:G4) \/\/ \u00c9cart type pour le d\u00e9partement de production<\/code><\/pre>\n
      Sc\u00e9nario 2: Suivi de la variabilit\u00e9 des performances des \u00e9l\u00e8ves<\/strong><\/p>\n
      Un directeur d’\u00e9cole pourrait souhaiter suivre les variations des r\u00e9sultats des tests des \u00e9l\u00e8ves sur plusieurs ann\u00e9es pour \u00e9valuer l’impact des m\u00e9thodes d’enseignement.<\/p>\n
        \n
      • Rassembler les r\u00e9sultats des tests annuels.<\/li>\n
      • Filtrer ces donn\u00e9es par ann\u00e9e, et \u00e9ventuellement par classe ou enseignant.<\/li>\n
      • Calculer l’\u00e9cart type pour ces groupes sp\u00e9cifiques en employant BDECARTYPEP<\/code>.<\/li>\n<\/ul>\n
        Formules :<\/strong><\/p>\n
        = BDECARTYPEP(A1:C300, \"Score\", H1:H2) \/\/ Scores pour l'ann\u00e9e 2021 = BDECARTYPEP(A1:C300, \"Score\", H3:H4) \/\/ Scores pour l'ann\u00e9e 2022<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
        CalCule l\u2019\u00e9Cart type pour l\u2019ensemble d\u2019une population d\u2019entr\u00e9es de base de donn\u00e9es s\u00e9leCtionn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-6512","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DSTDEVP (BDECARTYPEP) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DSTDEVP (BDECARTYPEP) 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\/dstdevp\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DSTDEVP (BDECARTYPEP) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DSTDEVP (BDECARTYPEP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dstdevp\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:05:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DSTDEVP (BDECARTYPEP) 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\/dstdevp\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dstdevp\/\",\"name\":\"Fonction DSTDEVP (BDECARTYPEP) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:05:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DSTDEVP (BDECARTYPEP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dstdevp\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dstdevp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dstdevp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de donn\u00e9es\",\"item\":\"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDECARTYPEP\"}]},{\"@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 DSTDEVP (BDECARTYPEP) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DSTDEVP (BDECARTYPEP) 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\/dstdevp\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DSTDEVP (BDECARTYPEP) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DSTDEVP (BDECARTYPEP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dstdevp\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:05:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DSTDEVP (BDECARTYPEP) 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\/dstdevp\/","url":"https:\/\/functiontranslator.com\/fr\/dstdevp\/","name":"Fonction DSTDEVP (BDECARTYPEP) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:05:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DSTDEVP (BDECARTYPEP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dstdevp\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dstdevp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dstdevp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Base de donn\u00e9es","item":"https:\/\/functiontranslator.com\/fr\/base-de-donnees\/"},{"@type":"ListItem","position":3,"name":"BDECARTYPEP"}]},{"@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\/6512","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=6512"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6512\/revisions"}],"predecessor-version":[{"id":29524,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6512\/revisions\/29524"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}