{"id":6710,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/centile-inclure\/"},"modified":"2021-02-26T08:11:37","modified_gmt":"2021-02-26T08:11:37","slug":"percentile-inc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/percentile-inc\/","title":{"rendered":"CENTILE.INCLURE"},"content":{"rendered":"

Pr\u00e9sentation de la fonction<\/h2>\n

La fonction CENTILE.INCLURE est disponible dans Microsoft Excel et Google Sheets. Elle permet de d\u00e9terminer la valeur de donn\u00e9es qui correspond \u00e0 un centile sp\u00e9cifique dans un jeu de donn\u00e9es. Un centile est une mesure statistique qui montre la valeur sous laquelle un pourcentage pr\u00e9d\u00e9fini de donn\u00e9es se situe. Cette fonction est essentielle pour analyser la dispersion et la position centrale des donn\u00e9es dans des \u00e9tudes statistiques.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction CENTILE.INCLURE est : <\/p>\n

CENTILE.INCLURE(plage; k)<\/code><\/pre>\n
O\u00f9 : <\/p>\n
    \n
  • plage<\/code> d\u00e9signe les donn\u00e9es sur lesquelles le calcul du centile doit \u00eatre effectu\u00e9.<\/li>\n
  • k<\/code> est le centile \u00e0 calculer, repr\u00e9sent\u00e9 par un nombre d\u00e9cimal entre 0 et 1 (y compris les extr\u00e9mit\u00e9s). Un k<\/code> de 0 indique le minimum, 0.5 la m\u00e9diane, et 1 le maximum des donn\u00e9es.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    Supposons que vous avez les nombres suivants dans la plage A1:A10 : 10, 20, 30, 40, 50, 60, 70, 80, 90, 100. Pour calculer le 30\u00e8me centile (k = 0.3) de cette s\u00e9rie de donn\u00e9es, la formule serait : =CENTILE.INCLURE(A1:A10; 0.3)<\/code><\/pre>\n
    Exemples d’application pratique<\/h2>\n
    Exemple 1 : Analyse des salaires<\/h3>\n
    Imaginez travaillant dans un d\u00e9partement des ressources humaines, vous souhaitez analyser la r\u00e9partition des salaires pour identifier le seuil en dessous duquel se situent les 25% de salaires les plus bas.<\/p>\n
    =CENTILE.INCLURE(A1:A100; 0.25)<\/code><\/pre>\n
    Cette formule, appliqu\u00e9e \u00e0 la plage A1:A100 contenant les salaires des employ\u00e9s, indiquera le salaire qui d\u00e9passe 25% des salaires les plus bas.<\/p>\n
    Exemple 2 : Gestion de stock<\/h3>\n
    Supposez que vous \u00eates responsable de la gestion de stock dans un entrep\u00f4t et que vous d\u00e9sirez savoir quel volume de stock se trouve 75% du temps en dessous d’un certain niveau, afin de mieux anticiper les besoins en r\u00e9approvisionnement.<\/p>\n
    =CENTILE.INCLURE(B1:B200; 0.75)<\/code><\/pre>\n
    L’application de cette formule \u00e0 B1:B200, qui peut repr\u00e9senter les volumes de diff\u00e9rents articles en stock \u00e0 la fin de chaque journ\u00e9e, vous aide \u00e0 comprendre quelles quantit\u00e9s de stock sont g\u00e9n\u00e9ralement ne d\u00e9pass\u00e9es dans 75% des cas, facilitant ainsi la planification des r\u00e9approvisionnements.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le k-i\u00e8me centile des valeuRs d\u2019une plage<\/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-6710","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction PERCENTILE.INC (CENTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PERCENTILE.INC (CENTILE.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\/percentile-inc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PERCENTILE.INC (CENTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PERCENTILE.INC (CENTILE.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\/percentile-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:11:37+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PERCENTILE.INC (CENTILE.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\/percentile-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/percentile-inc\/\",\"name\":\"Fonction PERCENTILE.INC (CENTILE.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:11:37+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PERCENTILE.INC (CENTILE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/percentile-inc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/percentile-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/percentile-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\":\"CENTILE.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 PERCENTILE.INC (CENTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PERCENTILE.INC (CENTILE.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\/percentile-inc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PERCENTILE.INC (CENTILE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PERCENTILE.INC (CENTILE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/percentile-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:37+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PERCENTILE.INC (CENTILE.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\/percentile-inc\/","url":"https:\/\/functiontranslator.com\/fr\/percentile-inc\/","name":"Fonction PERCENTILE.INC (CENTILE.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:11:37+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PERCENTILE.INC (CENTILE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/percentile-inc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/percentile-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/percentile-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":"CENTILE.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\/6710","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=6710"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6710\/revisions"}],"predecessor-version":[{"id":29721,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6710\/revisions\/29721"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}