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

Dans cet article, nous explorons une fonction cruciale dans MS Excel et Google Sheets, particuli\u00e8rement utile pour l’analyse statistique des donn\u00e9es : QUARTILE.EXC<\/code> (d\u00e9nomm\u00e9e QUARTILE.EXCLURE<\/code> dans certaines versions francophones d’Excel). Cette fonction est indispensable pour analyser la distribution au sein d’un ensemble de donn\u00e9es.<\/p>\n

Syntaxe et fonctionnement<\/h2>\n

La fonction QUARTILE.EXC<\/code> calcule les quartiles d’un ensemble de donn\u00e9es en excluant les valeurs minima et maxima, ce qui offre une perspective plus raffin\u00e9e de la r\u00e9partition interne. Les quartiles illustrent la valeur sous laquelle se situe une proportion sp\u00e9cifique de donn\u00e9es dans un ensemble.<\/p>\n

Voici la syntaxe de la fonction :<\/p>\n

QUARTILE.EXC(plage, quart)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • plage<\/strong> : La plage de cellules qui contient les donn\u00e9es num\u00e9riques.<\/li>\n
  • quart<\/strong> : Un nombre qui sp\u00e9cifie le quartile \u00e0 calculer. Ce param\u00e8tre doit \u00eatre compris entre 1 et 3 (1 pour le premier quartile, 2 pour la m\u00e9diane et 3 pour le troisi\u00e8me quartile).<\/li>\n<\/ul>\n
    Exemple :<\/strong><\/p>\n
    =QUARTILE.EXC(A1:A10, 1) =QUARTILE.EXC(A1:A10, 3)<\/code><\/pre>\n
    Applications pratiques de QUARTILE.EXC<\/h2>\n
    Exemple 1 : Analyse de donn\u00e9es de ventes<\/h2>\n
    Imaginons que vous disposiez des montants des ventes mensuelles d\u2019une entreprise pour une ann\u00e9e compl\u00e8te dans la plage A1:A12. Pour \u00e9valuer la performance de chaque trimestre, vous pourriez calculer les premier et troisi\u00e8me quartiles de cette s\u00e9rie :<\/p>\n
    Ventes mensuelles : A1:A12 Premier quartile (Q1) : =QUARTILE.EXC(A1:A12, 1) Troisi\u00e8me quartile (Q3) : =QUARTILE.EXC(A1:A12, 3)<\/code><\/pre>\n
    Cette analyse vous permet de voir comment les ventes varient au-del\u00e0 des indicateurs classiques comme la moyenne. Un troisi\u00e8me quartile \u00e9lev\u00e9 signifie que 75 % des mois pr\u00e9sentent des ventes inf\u00e9rieures \u00e0 cette valeur, ce qui aide \u00e0 identifier les pics de performance.<\/p>\n
    Exemple 2 : \u00c9valuation de la distribution des notes d\u2019un examen<\/h2>\n
    Consid\u00e9rons les notes d\u2019\u00e9tudiants pour un examen sp\u00e9cifique, r\u00e9pertori\u00e9es dans les cellules A1:A30. Pour examiner la distribution des performances, les quartiles peuvent \u00eatre tr\u00e8s r\u00e9v\u00e9lateurs :<\/p>\n
    Notes : A1:A30 Premier quartile (Q1) : =QUARTILE.EXC(A1:A30, 1) M\u00e9diane (Q2) : =QUARTILE.EXC(A1:A30, 2) Troisi\u00e8me quartile (Q3) : =QUARTILE.EXC(A1:A30, 3)<\/code><\/pre>\n
    Ces r\u00e9sultats illustrent non seulement la m\u00e9diane (Q2) mais aussi comment se r\u00e9partissent les moiti\u00e9s inf\u00e9rieure (Q1) et sup\u00e9rieure (Q3) des r\u00e9sultats de la classe. Cette information est essentielle pour ajuster la difficult\u00e9 des futurs examens ou pour offrir du soutien cibl\u00e9 pour certains groupes d’\u00e9tudiants.<\/p>\n
    En r\u00e9sum\u00e9, QUARTILE.EXC<\/code> est un outil puissant pour l’analyse statistique dans Excel et Google Sheets, offrant une compr\u00e9hension approfondie des ensembles de donn\u00e9es, surtout quand il est crucial d’exclure les valeurs extr\u00eames pour mieux comprendre leur distribution.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le quaRtile d\u2019un jeu de donn\u00e9es en fonction des valeuRs du centile compRises entRe 01, exclues<\/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-6733","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction QUARTILE.EXC (QUARTILE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction QUARTILE.EXC (QUARTILE.EXCLURE) 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-exc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction QUARTILE.EXC (QUARTILE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction QUARTILE.EXC (QUARTILE.EXCLURE) 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-exc\/\" \/>\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:28+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.EXC (QUARTILE.EXCLURE) 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-exc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/quartile-exc\/\",\"name\":\"Fonction QUARTILE.EXC (QUARTILE.EXCLURE) 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:28+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction QUARTILE.EXC (QUARTILE.EXCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/quartile-exc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/quartile-exc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/quartile-exc\/#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\":\"QUARTILE.EXCLURE\"}]},{\"@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.EXC (QUARTILE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction QUARTILE.EXC (QUARTILE.EXCLURE) 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-exc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction QUARTILE.EXC (QUARTILE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction QUARTILE.EXC (QUARTILE.EXCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/quartile-exc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:28+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction QUARTILE.EXC (QUARTILE.EXCLURE) 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-exc\/","url":"https:\/\/functiontranslator.com\/fr\/quartile-exc\/","name":"Fonction QUARTILE.EXC (QUARTILE.EXCLURE) 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:28+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction QUARTILE.EXC (QUARTILE.EXCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/quartile-exc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/quartile-exc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/quartile-exc\/#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":"QUARTILE.EXCLURE"}]},{"@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\/6733","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=6733"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6733\/revisions"}],"predecessor-version":[{"id":29744,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6733\/revisions\/29744"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}