{"id":6515,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdvar\/"},"modified":"2021-02-26T08:05:20","modified_gmt":"2021-02-26T08:05:20","slug":"dvar","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dvar\/","title":{"rendered":"BDVAR"},"content":{"rendered":"

Introduction \u00e0 la fonction DVAR<\/h2>\n

La fonction DVAR dans Microsoft Excel et BDVAR dans Google Sheets est utilis\u00e9e pour calculer la variance d’un \u00e9chantillon s\u00e9lectionn\u00e9 dans une base de donn\u00e9es selon des crit\u00e8res d\u00e9finis. Cet outil est essentiel pour l’analyse statistique dans des domaines vari\u00e9s comme les finances, la recherche scientifique ou l’\u00e9ducation.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe pour la fonction DVAR dans Microsoft Excel est : <\/p>\n

=DVAR(base_de_donn\u00e9es, champ, crit\u00e8res)<\/code><\/pre>\n
 Pour Google Sheets (BDVAR), la syntaxe est : <\/p>\n
=BDVAR(base_de_donn\u00e9es, champ, crit\u00e8res)<\/code><\/pre>\n<\/p>\n
    \n
  • base_de_donn\u00e9es<\/strong> : Correspond \u00e0 la plage de cellules contenant vos donn\u00e9es, y compris les en-t\u00eates de colonnes.<\/li>\n
  • champ<\/strong> : D\u00e9signe la colonne sur laquelle le calcul de variance est effectu\u00e9. Ce champ peut \u00eatre identifi\u00e9 soit par le nom de l’en-t\u00eate de la colonne, soit par l’index num\u00e9rique de la colonne dans la base de donn\u00e9es.<\/li>\n
  • crit\u00e8res<\/strong> : D\u00e9signe la plage de cellules qui d\u00e9finit quelles lignes de la base de donn\u00e9es doivent \u00eatre prises en compte dans le calcul. Cette plage doit inclure au moins une colonne d’en-t\u00eate et une ou plusieurs lignes de conditions.<\/li>\n<\/ul>\n
    Exemple :<\/strong>
     Imaginons une base de donn\u00e9es contenant les informations suivantes : <\/p>\n\n\n\n\n\n\n
    \u00c9tudiant<\/th>\nNote<\/th>\nGroupe<\/th>\n<\/tr>\n
    Alice<\/td>\n82<\/td>\n1<\/td>\n<\/tr>\n
    Bob<\/td>\n90<\/td>\n2<\/td>\n<\/tr>\n
    Clara<\/td>\n88<\/td>\n1<\/td>\n<\/tr>\n
    David<\/td>\n75<\/td>\n2<\/td>\n<\/tr>\n<\/table>\n
     Et une plage de crit\u00e8res comme suit : <\/p>\n\n\n\n
    Groupe<\/th>\n<\/tr>\n
    1<\/td>\n<\/tr>\n<\/table>\n
     Pour calculer la variance des notes du groupe 1, la formule serait : <\/p>\n
    =DVAR(A1:C5, \"Note\", G1:G2)<\/code><\/pre>\n
     Pour Google Sheets, elle serait : <\/p>\n
    =BDVAR(A1:C5, \"Note\", G1:G2)<\/code><\/pre>\n<\/p>\n
    Applications pratiques<\/h2>\n
    Voici quelques sc\u00e9narios d’utilisation de la fonction DVAR \/ BDVAR :<\/p>\n
    \u00c9valuation de la dispersion des r\u00e9sultats scolaires<\/h2>\n
    Une \u00e9cole peut utiliser DVAR pour analyser la variabilit\u00e9 des notes entre diff\u00e9rents groupes d’\u00e9tudiants afin d’\u00e9valuer l’efficacit\u00e9 de diverses m\u00e9thodes p\u00e9dagogiques. Cela permet aux administration de possiblement ajuster les approches d’enseignement en fonction des r\u00e9sultats.<\/p>\n
    Analyse financi\u00e8re des ventes<\/h2>\n
    Une entreprise peut utiliser DVAR pour \u00e9tudier la variabilit\u00e9 des ventes de produits dans diverses r\u00e9gions et identifier les produits avec les performances les plus variables, n\u00e9cessitant une attention particuli\u00e8re pour optimiser les strat\u00e9gies de marketing et de distribution.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule la varianCe pour un \u00e9Chantillon 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-6515","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"\nFonction DVAR (BDVAR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DVAR (BDVAR) 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\/dvar\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DVAR (BDVAR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DVAR (BDVAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dvar\/\" \/>\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:05:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DVAR (BDVAR) 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\/dvar\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dvar\/\",\"name\":\"Fonction DVAR (BDVAR) 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:05:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DVAR (BDVAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dvar\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dvar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dvar\/#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\":\"BDVAR\"}]},{\"@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 DVAR (BDVAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DVAR (BDVAR) 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\/dvar\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DVAR (BDVAR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DVAR (BDVAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dvar\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DVAR (BDVAR) 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\/dvar\/","url":"https:\/\/functiontranslator.com\/fr\/dvar\/","name":"Fonction DVAR (BDVAR) 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:05:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DVAR (BDVAR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dvar\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dvar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dvar\/#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":"BDVAR"}]},{"@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\/6515","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=6515"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6515\/revisions"}],"predecessor-version":[{"id":29527,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6515\/revisions\/29527"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}