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

La fonction QUARTILE est couramment utilis\u00e9e dans Microsoft Excel et Google Sheets pour d\u00e9terminer le quartile d’un jeu de donn\u00e9es, ce qui consiste \u00e0 diviser un ensemble de donn\u00e9es ordonn\u00e9es en quatre groupes \u00e9gaux. Elle est particuli\u00e8rement utile pour l’analyse de la dispersion des donn\u00e9es.<\/p>\n

Description et Syntaxe<\/h2>\n

La fonction QUARTILE calcule les quartiles d\u2019un jeu de donn\u00e9es, offrant une vue de la distribution des valeurs. Les quartiles sont trois valeurs qui partagent les donn\u00e9es en quatre parts \u00e9gales, chaque part repr\u00e9sentant un quart de l’ensemble de donn\u00e9es.<\/p>\n

La syntaxe de la fonction QUARTILE dans Excel est :<\/p>\n

 QUARTILE(array, quart) <\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • array<\/strong> : Ensemble de donn\u00e9es num\u00e9riques ou une r\u00e9f\u00e9rence \u00e0 celles-ci.<\/li>\n
  • quart<\/strong> : Le type de quartile \u00e0 calculer, sp\u00e9cifi\u00e9 par un nombre entre 0 (minimum) et 4 (maximum).<\/li>\n<\/ul>\n
    La syntaxe dans Google Sheets est similaire :<\/p>\n
     QUARTILE(A2:A100, 1) <\/code><\/pre>\n
    Exemples d’utilisation<\/h2>\n
    Supposons que vous disposiez des notes d’\u00e9tudiants dans un cours comme suit :<\/p>\n\n\n\n\n\n\n\n\n\n
    Note<\/th>\n<\/tr>\n
    67<\/td>\n<\/tr>\n
    78<\/td>\n<\/tr>\n
    81<\/td>\n<\/tr>\n
    85<\/td>\n<\/tr>\n
    90<\/td>\n<\/tr>\n
    92<\/td>\n<\/tr>\n
    94<\/td>\n<\/tr>\n<\/table>\n
    Pour calculer le premier quartile dans Excel, vous utiliseriez la formule :<\/p>\n
     =QUARTILE(A2:A8, 1) <\/code><\/pre>\n
    Cela indiquerait un premier quartile de 78.5, si vos donn\u00e9es s’\u00e9tendent de A2 \u00e0 A8.<\/p>\n
    Pour obtenir la m\u00e9diane (le deuxi\u00e8me quartile) :<\/p>\n
     =QUARTILE(A2:A8, 2) <\/code><\/pre>\n
    Cela retournerait une valeur de 85.<\/p>\n
    Cas pratiques<\/h2>\n
    Exemple 1 : Analyse des revenus<\/strong><\/p>\n
    Supposez que vous analysiez le revenu annuel des membres d’une petite entreprise, list\u00e9s ci-apr\u00e8s :<\/p>\n
      \n
    • 32000\u20ac<\/li>\n
    • 54000\u20ac<\/li>\n
    • 39000\u20ac<\/li>\n
    • 62000\u20ac<\/li>\n
    • 58000\u20ac<\/li>\n
    • 47000\u20ac<\/li>\n
    • 75000\u20ac<\/li>\n<\/ul>\n
      Pour \u00e9tudier la distribution des revenus, utilisez la fonction QUARTILE :<\/p>\n
       Premier quartile: =QUARTILE(B2:B8, 1) M\u00e9diane: =QUARTILE(B2:B8, 2) Troisi\u00e8me quartile: =QUARTILE(B2:B8, 3) <\/code><\/pre>\n
      Ces calculs aboutiront respectivement aux valeurs de 39000\u20ac, 54000\u20ac et 62000\u20ac.<\/p>\n
      Exemple 2 : R\u00e9partition des \u00e2ges dans une enqu\u00eate d\u00e9mographique<\/strong><\/p>\n
      La r\u00e9partition des \u00e2ges des participants \u00e0 une \u00e9tude peut \u00eatre r\u00e9v\u00e9l\u00e9e par les \u00e2ges suivants :<\/p>\n
        \n
      • 22, 27, 35, 45, 51, 58, 61, 75, 82<\/li>\n<\/ul>\n
        Les quartiles offriront une compr\u00e9hension des groupes d’\u00e2ge dominants :<\/p>\n
         Q1: =QUARTILE(C2:C10, 1) M\u00e9diane: =QUARTILE(C2:C10, 2) Q3: =QUARTILE(C2:C10, 3) <\/code><\/pre>\n
        Les r\u00e9sultats montrent des \u00e2ges m\u00e9dians de 35, 51 et 61 pour le premier, deuxi\u00e8me et troisi\u00e8me quartiles, respectivement.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Renvoie le quaRtile d\u2019une s\u00e9Rie de donn\u00e9es<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[317],"tags":[],"class_list":["post-6732","post","type-post","status-publish","format-standard","hentry","category-compatibilite"],"acf":[],"yoast_head":"\nFonction QUARTILE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction QUARTILE 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\/quartile\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction QUARTILE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction QUARTILE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/quartile\/\" \/>\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:12:25+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction QUARTILE 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\/quartile\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/quartile\/\",\"name\":\"Fonction QUARTILE 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:12:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction QUARTILE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/quartile\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/quartile\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/quartile\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilit\u00e9\",\"item\":\"https:\/\/functiontranslator.com\/fr\/compatibilite\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"QUARTILE\"}]},{\"@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 QUARTILE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction QUARTILE 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\/quartile\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction QUARTILE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction QUARTILE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/quartile\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction QUARTILE 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\/quartile\/","url":"https:\/\/functiontranslator.com\/fr\/quartile\/","name":"Fonction QUARTILE 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:12:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction QUARTILE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/quartile\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/quartile\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/quartile\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Compatibilit\u00e9","item":"https:\/\/functiontranslator.com\/fr\/compatibilite\/"},{"@type":"ListItem","position":3,"name":"QUARTILE"}]},{"@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\/6732","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=6732"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6732\/revisions"}],"predecessor-version":[{"id":29743,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6732\/revisions\/29743"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}