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

Explication de la fonction VARA dans les tableurs<\/h2>\n

La fonction VARA est utilis\u00e9e dans Microsoft Excel et Google Sheets pour calculer la variance d’un \u00e9chantillon de population, y compris les valeurs textuelles et logiques consid\u00e9r\u00e9es comme num\u00e9riques. Les valeurs TRUE sont trait\u00e9es comme 1 et les valeurs FALSE comme 0. Si les valeurs textuelles ne peuvent \u00eatre converties en nombres, une erreur est g\u00e9n\u00e9r\u00e9e.<\/p>\n

Syntaxe et exemples d\u2019utilisation<\/h2>\n

La syntaxe de la fonction VARA est :<\/p>\n

=VARA(valeur1, [valeur2], ...)<\/code><\/pre>\n
o\u00f9 \u00ab\u00a0valeur1\u00a0\u00bb, \u00ab\u00a0valeur2\u00a0\u00bb, etc. peuvent \u00eatre des nombres, des r\u00e9f\u00e9rences de cellules ou des plages.<\/p>\n
Exemple :<\/strong><\/p>\n
    \n
  • Pour calculer la variance des valeurs suivantes : 4, 7, 8, TRUE, \u00ab\u00a05\u00a0\u00bb, la fonction VARA consid\u00e9rera TRUE comme 1 et \u00ab\u00a05\u00a0\u00bb comme 5. La formule \u00e0 saisir serait :<\/li>\n<\/ul>\n
    =VARA(4, 7, 8, TRUE, \"5\")<\/code><\/pre>\n
    Cette fonction calcule la variance en tenant compte des valeurs num\u00e9riques, textuelles et logiques.<\/p>\n
    Applications pratiques avec r\u00e9solutions d\u00e9taill\u00e9es<\/h2>\n
    Cas pratique 1: Analyse des scores de tests<\/h2>\n
    Consid\u00e9rez une analyse de la variance des scores d’un test o\u00f9 certains participants ont des scores incomplets car ils n’ont pas r\u00e9pondu \u00e0 toutes les questions. Les scores manquants sont not\u00e9s par FALSE pour indiquer une absence de r\u00e9ponse.<\/p>\n
    Donn\u00e9es :<\/strong><\/p>\n\n\n\n\n\n\n
    Participant<\/th>\nScore<\/th>\n<\/tr>\n
    Jean<\/td>\n82<\/td>\n<\/tr>\n
    Lucie<\/td>\n90<\/td>\n<\/tr>\n
    Marie<\/td>\nFALSE<\/td>\n<\/tr>\n
    Pierre<\/td>\n78<\/td>\n<\/tr>\n<\/table>\n
    Pour calculer la variance de ces scores, en traitant les absences de r\u00e9ponse comme 0, utilisez :<\/p>\n
    =VARA(82, 90, FALSE, 78)<\/code><\/pre>\n
    Cette m\u00e9thode permet d’obtenir une variance refl\u00e9tant \u00e0 la fois les scores obtenus et les non-r\u00e9ponses.<\/p>\n
    Cas pratique 2: Estimation de la variance dans les enqu\u00eates de satisfaction<\/h2>\n
    Dans le cadre d’une enqu\u00eate de satisfaction client o\u00f9 les r\u00e9ponses sont indiqu\u00e9es par ‘oui’ (TRUE) ou ‘non’ (FALSE), et que vous souhaitez \u00e9valuer l’homog\u00e9n\u00e9it\u00e9 des opinions, consid\u00e9rez la calcul de la variance des r\u00e9ponses.<\/p>\n
    Donn\u00e9es :<\/strong><\/p>\n
    R\u00e9ponses : TRUE, TRUE, FALSE, FALSE, TRUE<\/code><\/pre>\n
    Pour mesurer la variance de ces r\u00e9ponses:<\/p>\n
    =VARA(TRUE, TRUE, FALSE, FALSE, TRUE)<\/code><\/pre>\n
    Cette formule comptabilise chaque \u00ab\u00a0TRUE\u00a0\u00bb comme 1 et chaque \u00ab\u00a0FALSE\u00a0\u00bb comme 0, fournissant ainsi une mesure de la variance des opinions exprim\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    EstimE la variancE d\u2019unE population En sE basant sur un \u00e9chantillon dE cEttE 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-6834","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction VARA dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction VARA 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\/vara\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction VARA dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction VARA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/vara\/\" \/>\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:16:02+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction VARA 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\/vara\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/vara\/\",\"name\":\"Fonction VARA 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:16:02+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction VARA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/vara\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/vara\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/vara\/#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\":\"VARA\"}]},{\"@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 VARA dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction VARA 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\/vara\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction VARA dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction VARA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/vara\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:02+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction VARA 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\/vara\/","url":"https:\/\/functiontranslator.com\/fr\/vara\/","name":"Fonction VARA 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:16:02+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction VARA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/vara\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/vara\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/vara\/#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":"VARA"}]},{"@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\/6834","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=6834"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6834\/revisions"}],"predecessor-version":[{"id":29843,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6834\/revisions\/29843"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}