{"id":6516,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bdvarp\/"},"modified":"2021-02-26T08:05:23","modified_gmt":"2021-02-26T08:05:23","slug":"dvarp","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/dvarp\/","title":{"rendered":"BDVARP"},"content":{"rendered":"<h2>Introduction \u00e0 la fonction DVARP (BDVARP)<\/h2>\n<p> La fonction DVARP, appel\u00e9e BDVARP dans Google Sheets, est utilis\u00e9e pour calculer la variance totale d&rsquo;une population au sein d&rsquo;une base de donn\u00e9es selon des crit\u00e8res sp\u00e9cifiques. Elle est essentielle pour analyser la dispersion des donn\u00e9es en comparaison avec la moyenne de la population.<\/p>\n<h2>Syntaxe de la fonction<\/h2>\n<p>La syntaxe varie l\u00e9g\u00e8rement entre Microsoft Excel et Google Sheets:<\/p>\n<ul>\n<li><strong>Excel:<\/strong> <code>DVARP(base_de_donn\u00e9es; champ; crit\u00e8res)<\/code><\/li>\n<li><strong>Google Sheets:<\/strong> <code>BDVARP(base_de_donn\u00e9es; champ; crit\u00e8res)<\/code><\/li>\n<\/ul>\n<p>O\u00f9:<\/p>\n<ul>\n<li><strong>base_de_donn\u00e9es<\/strong> d\u00e9signe la plage de cellules formant la base de donn\u00e9es.<\/li>\n<li><strong>champ<\/strong> r\u00e9f\u00e8re \u00e0 la colonne utilis\u00e9e pour le calcul, pouvant \u00eatre identifi\u00e9e par son nom (entre guillemets) ou par le num\u00e9ro de la colonne.<\/li>\n<li><strong>crit\u00e8res<\/strong> fait r\u00e9f\u00e9rence \u00e0 la plage de cellules qui sp\u00e9cifie les conditions utilis\u00e9es pour filtrer les donn\u00e9es de la base.<\/li>\n<\/ul>\n<h2>Exemples de syntaxe<\/h2>\n<pre> <code> =DVARP(A1:C10, \"Revenu\", E1:E2) =BDVARP(A1:C10, 2, G1:G2) <\/code> <\/pre>\n<h2>Sc\u00e9narios pratiques d&rsquo;utilisation<\/h2>\n<p>Ci-dessous quelques contextes pertinents pour l&#8217;emploi de DVARP:<\/p>\n<h2>\u00c9valuation de la dispersion des salaires dans une entreprise<\/h2>\n<p> Imaginez une base de donn\u00e9es avec les informations telles que le d\u00e9partement, l&rsquo;\u00e2ge et le salaire des employ\u00e9s. Pour calculer la variance des salaires au sein du d\u00e9partement des ventes, la fonction DVARP peut \u00eatre utilis\u00e9e de la mani\u00e8re suivante:<\/p>\n<pre> <code> \/\/ Hypoth\u00e8ses : \/\/ A1:C10 contient les donn\u00e9es avec A1: \"Dept\", B1: \"\u00c2ge\", C1: \"Salaire\" \/\/ E1:E2 contient les crit\u00e8res avec E1: \"Dept\", E2: \"Ventes\" =DVARP(A1:C10; \"Salaire\"; E1:E2) <\/code> <\/pre>\n<p>Cette formule permet de calculer la variance des salaires de tous les employ\u00e9s dans le d\u00e9partement des ventes.<\/p>\n<h2>Comparaison de la variance des \u00e2ges entre diff\u00e9rents d\u00e9partements<\/h2>\n<p>Pour \u00e9tudier la variation d&rsquo;\u00e2ge entre diff\u00e9rents d\u00e9partements, utilisez BDVARP dans Google Sheets en appliquant divers crit\u00e8res:<\/p>\n<pre> <code> \/\/ Pour le d\u00e9partement des Ressources Humaines =BDVARP(A1:C10, \"\u00c2ge\", {\"Dept\";\"RH\"}) \/\/ Pour le d\u00e9partement de la Technologie =BDVARP(A1:C10, \"\u00c2ge\", {\"Dept\";\"Tech\"}) <\/code> <\/pre>\n<p>Ces formules facilitent la comparaison de la dispersion d&rsquo;\u00e2ge entre les employ\u00e9s des d\u00e9partements des Ressources Humaines et de la Technologie.<\/p>\n<h2>Conclusion<\/h2>\n<p>La fonction DVARP constitue un outil statistique puissant dans Excel et Google Sheets. Elle permet de mesurer la variance pour une population enti\u00e8re bas\u00e9e sur des crit\u00e8res pr\u00e9cis, offrant ainsi une aide significative pour l&rsquo;analyse de donn\u00e9es dans une vari\u00e9t\u00e9 de secteurs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CalCule la varianCe 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-6516","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction DVARP (BDVARP) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction DVARP (BDVARP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/dvarp\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction DVARP (BDVARP) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction DVARP (BDVARP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/dvarp\/\" \/>\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:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction DVARP (BDVARP) 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\/dvarp\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/dvarp\/\",\"name\":\"Fonction DVARP (BDVARP) 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:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction DVARP (BDVARP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/dvarp\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/dvarp\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/dvarp\/#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\":\"BDVARP\"}]},{\"@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 DVARP (BDVARP) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction DVARP (BDVARP) 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\/dvarp\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction DVARP (BDVARP) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction DVARP (BDVARP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/dvarp\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction DVARP (BDVARP) 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\/dvarp\/","url":"https:\/\/functiontranslator.com\/fr\/dvarp\/","name":"Fonction DVARP (BDVARP) 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:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction DVARP (BDVARP) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/dvarp\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/dvarp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/dvarp\/#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":"BDVARP"}]},{"@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\/6516","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=6516"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6516\/revisions"}],"predecessor-version":[{"id":29528,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6516\/revisions\/29528"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}