{"id":14137,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/rango-percentil-exc\/"},"modified":"2021-02-26T08:55:36","modified_gmt":"2021-02-26T08:55:36","slug":"percentrank-exc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/percentrank-exc\/","title":{"rendered":"RANGO.PERCENTIL.EXC"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n de Rango Percentil Exclusivo<\/h2>\n

La funci\u00f3n RANGO.PERCENTIL.EXC en Microsoft Excel y Google Sheets permite determinar el rango de un valor espec\u00edfico dentro de un conjunto de datos en t\u00e9rminos de percentiles. Es crucial distinguir entre PERCENTRANK.INC y PERCENTRANK.EXC. La versi\u00f3n \u00abEXC\u00bb no considera el primer y el \u00faltimo percentil, ofreciendo un rango m\u00e1s ‘exclusivo’ y \u00fatil en estad\u00edsticas para evitar la influencia de valores extremadamente altos o bajos en los an\u00e1lisis.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n es la siguiente:<\/p>\n

  RANGO.PERCENTIL.EXC(rango_datos, valor_x, [significancia]) <\/code> <\/pre>\n
    \n
  • rango_datos:<\/strong> Refiere al rango de c\u00e9lulas que contiene los datos.<\/li>\n
  • valor_x:<\/strong> Es el valor que deseamos clasificar dentro del conjunto de datos.<\/li>\n
  • significancia<\/strong> (opcional): Es un valor num\u00e9rico que define el n\u00famero de d\u00edgitos significativos para el resultado. Si no se especifica, el valor predeterminado es 3.<\/li>\n<\/ul>\n
    A continuaci\u00f3n, presentamos algunos ejemplos pr\u00e1cticos de c\u00f3mo usar esta funci\u00f3n.<\/p>\n
      Ejemplo 1: Datos: 5, 1, 9, 7, 2 Valor a clasificar: 7 F\u00f3rmula: RANGO.PERCENTIL.EXC(A2:A6, 7) Resultado: 0.8 <\/code> <\/pre>\n
      Ejemplo 2: Datos: 10, 20, 30, 40, 50 Valor a clasificar: 35 F\u00f3rmula: RANGO.PERCENTIL.EXC(A2:A6, 35, 2) Resultado: 0.75 <\/code> <\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    La funci\u00f3n RANGO.PERCENTIL.EXC es muy \u00fatil en diversos contextos estad\u00edsticos y de an\u00e1lisis de datos. A continuaci\u00f3n, exploraremos dos casos pr\u00e1cticos donde esta funci\u00f3n resulta especialmente beneficiosa:<\/p>\n
    Evaluaci\u00f3n de Estudiantes<\/h2>\n
    Supongamos que un profesor desea analizar el rendimiento de un estudiante en un examen comparado con sus pares. Los resultados del examen figuran del rango A2:A30, y el estudiante obtuvo 85 puntos.<\/p>\n
      F\u00f3rmula para evaluar al estudiante: =RANGO.PERCENTIL.EXC(A2:A30,85) <\/code> <\/pre>\n
    Esta f\u00f3rmula proporciona el percentil exclusivo del estudiante, excluyendo los valores extremos, lo que ofrece una medida m\u00e1s robusta de su desempe\u00f1o.<\/p>\n
    An\u00e1lisis de Ventas<\/h2>\n
    En un contexto empresarial, consideremos una empresa que quiere evaluar el rendimiento de las ventas de un producto espec\u00edfico cuyas cantidades est\u00e1n registradas entre B2:B50. Desean comparar las ventas de 500 unidades con otros valores.<\/p>\n
      F\u00f3rmula para evaluar las ventas: =RANGO.PERCENTIL.EXC(B2:B50, 500) <\/code> <\/pre>\n
    Esta f\u00f3rmula clasifica las ventas de 500 unidades en un percentil, excluyendo los valores m\u00e1s extremos, proporcionando una visi\u00f3n clara de c\u00f3mo se posicionan estas ventas en relaci\u00f3n con el resto sin la influencia de valores at\u00edpicos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el rango de un valor en un conjunto de datos como un porcentaje (0 a 1, exclusivo) del conjunto de datos<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-14137","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\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\/es\/percentrank-exc\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/percentrank-exc\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:55:36+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank-exc\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/percentrank-exc\/\",\"name\":\"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:55:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank-exc\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/percentrank-exc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank-exc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RANGO.PERCENTIL.EXC\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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\/es\/percentrank-exc\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/percentrank-exc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/percentrank-exc\/","url":"https:\/\/functiontranslator.com\/es\/percentrank-exc\/","name":"Funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:55:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.EXC (RANGO.PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/percentrank-exc\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/percentrank-exc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/percentrank-exc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"RANGO.PERCENTIL.EXC"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14137"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14137\/revisions"}],"predecessor-version":[{"id":30228,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14137\/revisions\/30228"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}