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

La fonction RANG.POURCENTAGE.EXCLURE dans Excel et Google Sheets permet de d\u00e9terminer le rang en pourcentage d’une valeur donn\u00e9e au sein d’un ensemble de donn\u00e9es, tout en excluant les 1% les valeurs les plus hautes et les plus basses. Cette fonction est particuli\u00e8rement utile pour l’analyse statistique afin d’occulter les valeurs aberrantes qui pourraient fausser l’\u00e9valuation globale des donn\u00e9es. <\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction RANG.POURCENTAGE.EXCLURE : <\/p>\n

=RANG.POURCENTAGE.EXCLURE(matrice; x; [significatif])<\/code><\/pre>\n
    \n
  • matrice<\/strong> : Correspond \u00e0 l’ensemble de donn\u00e9es dans lequel vous souhaitez d\u00e9terminer le rang en pourcentage de la valeur x<\/strong>. Il s’agit d’une plage de cellules.<\/li>\n
  • x<\/strong> : La valeur pour laquelle vous voulez calculer le rang en pourcentage.<\/li>\n
  • significatif<\/strong> (optionnel) : Le nombre de chiffres significatifs pour le r\u00e9sultat. Par d\u00e9faut, le calcul se fait avec trois chiffres significatifs.<\/li>\n<\/ul>\n
     Voici un exemple d\u2019utilisation de cette fonction : <\/p>\n
    =RANG.POURCENTAGE.EXCLURE(A1:A10; 5)<\/code><\/pre>\n
     Dans cet exemple, Excel calculera le rang en pourcentage de la valeur 5 parmi les valeurs de A1 \u00e0 A10, en \u00e9liminant les 1% de valeurs les plus hautes et les plus basses. <\/p>\n
    Exemples pratiques d’application<\/h2>\n
     Examinons quelques scenarios o\u00f9 cette fonction s’av\u00e8re utile. <\/p>\n
    Sc\u00e9nario 1 : Analyse des r\u00e9sultats d’un test<\/h2>\n
     Consid\u00e9rons des r\u00e9sultats de tests obtenus aupr\u00e8s de 100 \u00e9l\u00e8ves. Pour \u00e9tablir le rang en pourcentage de chaque score tout en excluant les scores extr\u00eames, vous pouvez utiliser la formule suivante : <\/p>\n
    =RANG.POURCENTAGE.EXCLURE(B$2:B$101; B2)<\/code><\/pre>\n
     Cette formule permet d’\u00e9valuer le rang du score de l\u2019\u00e9l\u00e8ve en B2. Vous pouvez reproduire cette formule pour tous les scores dans la colonne B. <\/p>\n
    Sc\u00e9nario 2 : \u00c9valuation des prix de l’immobilier<\/h2>\n
     Un groupe d’agents immobiliers pourrait vouloir estimer la position relative des prix de biens immobiliers dans un quartier, sans prendre en compte les extr\u00eames. Pour cela, ils pourraient utiliser : <\/p>\n
    =RANG.POURCENTAGE.EXCLURE(C$1:C$100; C10)<\/code><\/pre>\n
     Cette formule donnerait une perspective plus repr\u00e9sentative du prix du bien en C10, en excluant les biens aux prix inhabituellement \u00e9lev\u00e9s ou bas. <\/p>\n
     Ainsi, la fonction RANG.POURCENTAGE.EXCLURE est essentielle pour filtrer les valeurs atypiques et effectuer des analyses qui refl\u00e8tent plus fid\u00e8lement la condition de la majorit\u00e9 des donn\u00e9es consid\u00e9r\u00e9es. <\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le Rang d\u2019une valeuR d\u2019un jeu de donn\u00e9es sous foRme de pouRcentage (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-6712","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PERCENTRANK.EXC (RANG.POURCENTAGE.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\/percentrank-exc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PERCENTRANK.EXC (RANG.POURCENTAGE.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\/percentrank-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:11:40+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.EXC (RANG.POURCENTAGE.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\/percentrank-exc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/percentrank-exc\/\",\"name\":\"Fonction PERCENTRANK.EXC (RANG.POURCENTAGE.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:11:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/percentrank-exc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/percentrank-exc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/percentrank-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\":\"RANG.POURCENTAGE.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 PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PERCENTRANK.EXC (RANG.POURCENTAGE.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\/percentrank-exc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/percentrank-exc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PERCENTRANK.EXC (RANG.POURCENTAGE.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\/percentrank-exc\/","url":"https:\/\/functiontranslator.com\/fr\/percentrank-exc\/","name":"Fonction PERCENTRANK.EXC (RANG.POURCENTAGE.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:11:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PERCENTRANK.EXC (RANG.POURCENTAGE.EXCLURE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/percentrank-exc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/percentrank-exc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/percentrank-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":"RANG.POURCENTAGE.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\/6712","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=6712"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6712\/revisions"}],"predecessor-version":[{"id":29723,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6712\/revisions\/29723"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}