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

Description de la fonction<\/h2>\n

La fonction QUARTILE.INC, disponible dans Microsoft Excel et sous le nom QUARTILE.INCLURE dans Google Sheets, est utilis\u00e9e pour calculer les quartiles d’une distribution de donn\u00e9es. Un quartile est une mesure statistique qui divise un ensemble de donn\u00e9es en quatre parts \u00e9gales, offrant ainsi une vision claire de la dispersion et de la tendance centrale des donn\u00e9es.<\/p>\n

Syntaxe<\/h2>\n

La syntaxe de la fonction QUARTILE.INC est identique dans Excel et Google Sheets :<\/p>\n

QUARTILE.INC(donn\u00e9es; quart)<\/code><\/pre>\n
    \n
  • donn\u00e9es<\/code> : La plage de cellules ou l\u2019ensemble des valeurs pour lesquelles les quartiles sont \u00e0 d\u00e9terminer.<\/li>\n
  • quart<\/code> : L’indice du quartile \u00e0 calculer. Les valeurs accept\u00e9es sont de 0 \u00e0 4, o\u00f9 0 indique le minimum, 1 correspond au premier quartile, 2 \u00e0 la m\u00e9diane, 3 au troisi\u00e8me quartile et 4 au maximum.<\/li>\n<\/ul>\n
    Exemples pratiques<\/h2>\n
    Voici quelques exemples pour illustrer l’application de QUARTILE.INC.<\/p>\n
    Exemple 1 : Analyse de salaires<\/h2>\n
    Supposons que vous disposiez d’une liste des salaires annuels des employ\u00e9s d’une entreprise, exprim\u00e9s en euros : 35000, 42000, 48000, 51000, 55000, 61000, 68000, 72000.<\/p>\n
    =QUARTILE.INC(A1:A8; 1) \/\/ Calcul du premier quartile =QUARTILE.INC(A1:A8; 2) \/\/ Calcul de la m\u00e9diane =QUARTILE.INC(A1:A8; 3) \/\/ Calcul du troisi\u00e8me quartile<\/code><\/pre>\n
    Dans cet exemple r\u00e9alisable sur Excel ou Google Sheets, nous obtenons :<\/p>\n
      \n
    • Le premier quartile (Q1), indiquant la valeur sous laquelle se situent 25% des salaires.<\/li>\n
    • La m\u00e9diane (Q2), qui divise l’ensemble des donn\u00e9es en deux parts \u00e9gales.<\/li>\n
    • Le troisi\u00e8me quartile (Q3), situant 75% des salaires en dessous de cette valeur.<\/li>\n<\/ul>\n
      Exemple 2 : Distribution des scores d’un examen<\/h2>\n
      Considerons les scores obtenus par 50 \u00e9tudiants dans un examen.<\/p>\n
      =QUARTILE.INC(B1:B50; 0) \/\/ Score minimal =QUARTILE.INC(B1:B50; 1) \/\/ Premier quartile =QUARTILE.INC(B1:B50; 2) \/\/ M\u00e9diane =QUARTILE.INC(B1:B50; 3) \/\/ Troisi\u00e8me quartile =QUARTILE.INC(B1:B50; 4) \/\/ Score maximal<\/code><\/pre>\n
      Cette s\u00e9quence de calculs permet de d\u00e9terminer rapidement :<\/p>\n
        \n
      • Le score le plus bas.<\/li>\n
      • La valeur sous laquelle se situent les 25% des scores les plus bas.<\/li>\n
      • La m\u00e9diane, qui partage les donn\u00e9es en deux moiti\u00e9s.<\/li>\n
      • La valeur sous laquelle se situent les 75% des scores.<\/li>\n
      • Le score le plus \u00e9lev\u00e9.<\/li>\n<\/ul>\n
        Ce type d’analyse est utile pour \u00e9valuer les performances des \u00e9tudiants et peut orienter les ajustements des m\u00e9thodes p\u00e9dagogiques ou du niveau de difficult\u00e9 des examens.<\/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":[315],"tags":[],"class_list":["post-6734","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction QUARTILE.INC (QUARTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction QUARTILE.INC (QUARTILE.INCLURE) 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-inc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction QUARTILE.INC (QUARTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction QUARTILE.INC (QUARTILE.INCLURE) 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-inc\/\" \/>\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:30+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.INC (QUARTILE.INCLURE) 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-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/quartile-inc\/\",\"name\":\"Fonction QUARTILE.INC (QUARTILE.INCLURE) 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:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction QUARTILE.INC (QUARTILE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/quartile-inc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/quartile-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/quartile-inc\/#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.INCLURE\"}]},{\"@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.INC (QUARTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction QUARTILE.INC (QUARTILE.INCLURE) 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-inc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction QUARTILE.INC (QUARTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction QUARTILE.INC (QUARTILE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/quartile-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction QUARTILE.INC (QUARTILE.INCLURE) 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-inc\/","url":"https:\/\/functiontranslator.com\/fr\/quartile-inc\/","name":"Fonction QUARTILE.INC (QUARTILE.INCLURE) 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:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction QUARTILE.INC (QUARTILE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/quartile-inc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/quartile-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/quartile-inc\/#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.INCLURE"}]},{"@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\/6734","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=6734"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6734\/revisions"}],"predecessor-version":[{"id":29745,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6734\/revisions\/29745"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}