{"id":6713,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/rang-pourcentage-inclure\/"},"modified":"2021-02-26T08:11:42","modified_gmt":"2021-02-26T08:11:42","slug":"percentrank-inc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/","title":{"rendered":"RANG.POURCENTAGE.INCLURE"},"content":{"rendered":"

Description g\u00e9n\u00e9rale<\/h2>\n

La fonction RANG.POURCENTAGE.INCLURE<\/strong> dans Microsoft Excel et Google Sheets est con\u00e7ue pour calculer le rang percentile inclusif d’une valeur sp\u00e9cifique au sein d’un ensemble de donn\u00e9es. Cet outil est particuli\u00e8rement utile pour \u00e9valuer la position relative d’une valeur au sein d’un groupe.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction est la suivante :<\/p>\n

=RANG.POURCENTAGE.INCLURE(donn\u00e9es; x; [significatif])<\/code><\/pre>\n
    \n
  • donn\u00e9es<\/strong> : Il s’agit de la plage de cellules ou du tableau contenant les donn\u00e9es.<\/li>\n
  • x<\/strong> : La valeur dont vous souhaitez d\u00e9terminer le rang percentile.<\/li>\n
  • significatif<\/strong> (optionnel) : Nombre de chiffres significatifs pour l’arrondi du r\u00e9sultat. La valeur par d\u00e9faut est 3.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Consid\u00e9rons un ensemble de notes obtenues par des \u00e9tudiants : 10, 20, 30, 40, 50.<\/p>\n
    Pour d\u00e9terminer le rang percentile de la note 30 dans cet ensemble, nous pouvons utiliser la fonction suivante :<\/p>\n
    =RANG.POURCENTAGE.INCLURE(A1:A5; 30)<\/code><\/pre>\n
    Cela renvoie 0.6, signifiant que la note 30 est sup\u00e9rieure \u00e0 60% des notes de l’ensemble.<\/p>\n
    Applications pratiques<\/h2>\n
    Analyse de performance des \u00e9tudiants<\/h2>\n
    Scenario : Un enseignant souhaite \u00e9tudier la position de chaque \u00e9tudiant par rapport \u00e0 l’ensemble de la classe.<\/p>\n
    =RANG.POURCENTAGE.INCLURE(A1:A30; B1)<\/code><\/pre>\n
    La plage A1:A30<\/code> contient les notes de tous les \u00e9tudiants et B1<\/code> repr\u00e9sente la note de l’\u00e9tudiant analys\u00e9. Cette formule aide l’enseignant \u00e0 identifier rapidement le pourcentage d’\u00e9tudiants ayant une note inf\u00e9rieure \u00e0 celle de l’\u00e9tudiant r\u00e9f\u00e9renc\u00e9 en B1.<\/p>\n
    Comparaison des ventes des produits<\/h2>\n
    Un responsable produit souhaite comparer les performances de vente de diff\u00e9rents produits.<\/p>\n
    Les ventes de tous les produits sont enregistr\u00e9es dans les cellules de A1 \u00e0 A50. Pour \u00e9valuer le rang percentile d’un produit sp\u00e9cifique not\u00e9 en B1, utilisez la fonction :<\/p>\n
    =RANG.POURCENTAGE.INCLURE(A1:A50; B1; 2)<\/code><\/pre>\n
    Cette commande offre un aper\u00e7u clair de la performance relative d’un produit par rapport aux autres, en montrant son positionnement en termes de pourcentage par rapport \u00e0 l’ensemble.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le Rang en pouRcentage d\u2019une valeuR 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-6713","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PERCENTRANK.INC (RANG.POURCENTAGE.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\/percentrank-inc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PERCENTRANK.INC (RANG.POURCENTAGE.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\/percentrank-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:42+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PERCENTRANK.INC (RANG.POURCENTAGE.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\/percentrank-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/\",\"name\":\"Fonction PERCENTRANK.INC (RANG.POURCENTAGE.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:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/percentrank-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\":\"RANG.POURCENTAGE.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 PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PERCENTRANK.INC (RANG.POURCENTAGE.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\/percentrank-inc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PERCENTRANK.INC (RANG.POURCENTAGE.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\/percentrank-inc\/","url":"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/","name":"Fonction PERCENTRANK.INC (RANG.POURCENTAGE.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:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PERCENTRANK.INC (RANG.POURCENTAGE.INCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/percentrank-inc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/percentrank-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/percentrank-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":"RANG.POURCENTAGE.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\/6713","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=6713"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6713\/revisions"}],"predecessor-version":[{"id":29724,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6713\/revisions\/29724"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}