{"id":6832,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/var-p-n\/"},"modified":"2021-02-26T08:15:57","modified_gmt":"2021-02-26T08:15:57","slug":"var-p","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/var-p\/","title":{"rendered":"VAR.P.N"},"content":{"rendered":"

Description de la Syntaxe<\/h2>\n

La fonction VAR.P<\/code> (appel\u00e9e VAR.P.N<\/code> dans Excel et VARP<\/code> dans Google Sheets) est utilis\u00e9e pour calculer la variance d’une population enti\u00e8re. Elle mesure la moyenne des carr\u00e9s des \u00e9carts de chaque donn\u00e9e par rapport \u00e0 la moyenne arithm\u00e9tique totale, un outil essentiel en statistique pour analyser la dispersion des donn\u00e9es.<\/p>\n

Syntaxe dans Excel:<\/p>\n

VAR.P(Nombre1, [Nombre2], ...)<\/code><\/pre>\n
Syntaxe dans Google Sheets:<\/p>\n
VARP(valeur1, [valeur2, ...])<\/code><\/pre>\n
Les arguments ‘Nombre1’, ‘Nombre2’, … dans Excel et ‘valeur1’, ‘valeur2’, … dans Google Sheets peuvent \u00eatre entre 2 et 254 valeurs num\u00e9riques ou r\u00e9f\u00e9rences de plages de cellules destin\u00e9es au calcul de la variance de la population.<\/p>\n
Exemples d’Utilisation<\/h2>\n
1. Calcule de la variance d’un ensemble de donn\u00e9es :<\/p>\n
Consid\u00e9rons les r\u00e9sultats de tests suivants pour une classe enti\u00e8re: 15, 20, 22, 12, 17 et 13. Pour calculer la variance de ces scores, utilisez la syntaxe ci-dessous :<\/p>\n\n\n\n
Excel<\/th>\nGoogle Sheets<\/th>\n<\/tr>\n
\n
=VAR.P(15, 20, 22, 12, 17, 13)<\/code><\/pre>\n<\/td>\n
\n
=VARP(15, 20, 22, 12, 17, 13)<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n
2. Application avec des plages de cellules :<\/p>\n
Pour des donn\u00e9es situ\u00e9es, par exemple, entre la cellule A1 et A6, vous pouvez proc\u00e9der de la mani\u00e8re suivante :<\/p>\n\n\n\n
Excel<\/th>\nGoogle Sheets<\/th>\n<\/tr>\n
\n
=VAR.P(A1:A6)<\/code><\/pre>\n<\/td>\n
\n
=VARP(A1:A6)<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n
Cas Pratiques<\/h2>\n
D\u00e9couvrons deux sc\u00e9narios pratiques o\u00f9 la fonction VAR.P<\/code> peut \u00eatre pertinente.<\/p>\n
Analyse de la Stabilit\u00e9 des Ventes<\/h2>\n
Un directeur des ventes souhaite \u00e9valuer la stabilit\u00e9 des chiffres de vente journaliers sur une semaine. Les montants sont les suivants : 100, 120, 90, 110, 105, 95, 85. On calcule la variance des ventes de cette mani\u00e8re :<\/p>\n
Excel: =VAR.P(100, 120, 90, 110, 105, 95, 85) Google Sheets: =VARP(100, 120, 90, 110, 105, 95, 85)<\/code><\/pre>\n
Une variance faible indiquera des ventes stables, tandis qu’une forte variance signalera de grandes disparit\u00e9s dans les ventes quotidiennes.<\/p>\n
Comparaison de Performances dans une Course<\/h2>\n
Un entra\u00eeneur souhaite \u00e9valuer la coh\u00e9rence des performances de ses athl\u00e8tes \u00e0 travers leurs temps en secondes lors de diff\u00e9rentes courses. Les temps enregistr\u00e9s sont : 300, 305, 290, 310, 295. On utilise alors la fonction de variance comme suit :<\/p>\n
Excel: =VAR.P(300, 305, 290, 310, 295) Google Sheets: =VARP(300, 305, 290, 310, 295)<\/code><\/pre>\n
Une variance r\u00e9duite ici indiquerait une consistance des performances entre les athl\u00e8tes, ce qui peut \u00eatre crucial pour les strat\u00e9gies comme les courses de relais.<\/p>\n","protected":false},"excerpt":{"rendered":"
CalCule la varianCe sur la base de l\u2019ensemble de la population<\/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-6832","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction VAR.P (VAR.P.N) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction VAR.P (VAR.P.N) 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\/var-p\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction VAR.P (VAR.P.N) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction VAR.P (VAR.P.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/var-p\/\" \/>\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:15:57+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction VAR.P (VAR.P.N) 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\/var-p\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/var-p\/\",\"name\":\"Fonction VAR.P (VAR.P.N) 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:15:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction VAR.P (VAR.P.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/var-p\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/var-p\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/var-p\/#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\":\"VAR.P.N\"}]},{\"@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 VAR.P (VAR.P.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction VAR.P (VAR.P.N) 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\/var-p\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction VAR.P (VAR.P.N) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction VAR.P (VAR.P.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/var-p\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction VAR.P (VAR.P.N) 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\/var-p\/","url":"https:\/\/functiontranslator.com\/fr\/var-p\/","name":"Fonction VAR.P (VAR.P.N) 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:15:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction VAR.P (VAR.P.N) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/var-p\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/var-p\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/var-p\/#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":"VAR.P.N"}]},{"@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\/6832","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=6832"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6832\/revisions"}],"predecessor-version":[{"id":29841,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6832\/revisions\/29841"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}