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

Descripci\u00f3n y Sintaxis<\/h2>\n

La funci\u00f3n RANGO.PERCENTIL en Microsoft Excel y PERCENTRANK en Google Sheets se utiliza para determinar el percentil en el que un valor espec\u00edfico se encuentra dentro de un conjunto de datos. Este c\u00e1lculo muestra la posici\u00f3n relativa del valor en cuesti\u00f3n con respecto al resto de los datos en el conjunto.<\/p>\n

El percentil es una medida estad\u00edstica que indica el porcentaje de datos que se encuentra por debajo de un valor especificado.<\/p>\n

Sintaxis en Microsoft Excel<\/h2>\n
RANGO.PERCENTIL(array; k)<\/code><\/pre>\n
    \n
  • array<\/strong>: El conjunto de datos en los que se realizar\u00e1 la b\u00fasqueda.<\/li>\n
  • k<\/strong>: El valor de inter\u00e9s, del cual se busca su percentil. Debe ser un n\u00famero entre 0 y 1.<\/li>\n<\/ul>\n
    Sintaxis en Google Sheets<\/h2>\n
    PERCENTRANK(data, value, [significance])<\/code><\/pre>\n
      \n
    • data<\/strong>: El rango de datos a analizar.<\/li>\n
    • value<\/strong>: El valor para el que se desea calcular el percentil.<\/li>\n
    • significance<\/strong>: (Opcional) El n\u00famero de d\u00edgitos significativos a los que se debe redondear el resultado. Por defecto, es 3 si no se especifica.<\/li>\n<\/ul>\n
      Ejemplos Pr\u00e1cticos<\/h2>\n
      Supongamos que contamos con la serie de datos: 10, 20, 30, 40, y deseamos hallar el percentil del valor 30.<\/p>\n\n\n\n\n
      Funci\u00f3n<\/th>\nF\u00f3rmula<\/th>\nResultado<\/th>\n<\/tr>\n
      Excel<\/td>\n=RANGO.PERCENTIL({10,20,30,40}, 30)<\/td>\n0.6667<\/td>\n<\/tr>\n
      Google Sheets<\/td>\n=PERCENTRANK({10,20,30,40}, 30)<\/td>\n0.666<\/td>\n<\/tr>\n<\/table>\n
      Esto indica que el 66.67% de los datos en Excel y el 66.6% en Google Sheets est\u00e1 por debajo de 30.<\/p>\n
      Casos Pr\u00e1cticos y Aplicaciones<\/h2>\n
      Caso 1: An\u00e1lisis de Ex\u00e1menes<\/h2>\n
      Un profesor desea evaluar c\u00f3mo se desempe\u00f1\u00f3 un estudiante en relaci\u00f3n a sus compa\u00f1eros en un examen. La nota del estudiante fue 78 y las notas del grupo fueron: 65, 70, 75, 85, 90.<\/p>\n
      Excel: =RANGO.PERCENTIL({65,70,75,85,90}, 78) Google Sheets: =PERCENTRANK({65,70,75,85,90}, 78)<\/code><\/pre>\n
      Los resultados indicar\u00e1n el percentil de la nota del estudiante, ayudando al profesor a entender el rendimiento relativo del mismo.<\/p>\n
      Caso 2: Evaluaci\u00f3n de Ventas<\/h2>\n
      Un gerente quiere analizar la performance de ventas de un art\u00edculo espec\u00edfico en comparaci\u00f3n con el total de ventas del mes. Las cifras fueron: $150, $300, $250, $500, y las ventas del art\u00edculo espec\u00edfico fueron $300.<\/p>\n
      Excel: =RANGO.PERCENTIL({150, 300, 250, 500}, 300) Google Sheets: =PERCENTRANK({150, 300, 250, 500}, 300)<\/code><\/pre>\n
      El resultado mostrar\u00e1 el posicionamiento del rendimiento de este producto dentro del total de ventas del mes.<\/p>\n
       Este c\u00f3digo HTML proporciona una descripci\u00f3n clara y precisa sobre el uso y aplicaci\u00f3n de la funci\u00f3n RANGO.PERCENTIL en Excel y PERCENTRANK en Google Sheets, incluyendo ejemplos y casos pr\u00e1cticos para facilitar la comprensi\u00f3n de su utilidad en escenarios reales.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve el rango porcentual de un valor de un 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":[542],"tags":[],"class_list":["post-14139","post","type-post","status-publish","format-standard","hentry","category-compatibilidad"],"acf":[],"yoast_head":"\nFunci\u00f3n PERCENTRANK (RANGO.PERCENTIL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) 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\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/percentrank\/\" \/>\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:42+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 (RANGO.PERCENTIL) 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\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/percentrank\/\",\"name\":\"Funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) 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:42+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/percentrank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compatibilidad\",\"item\":\"https:\/\/functiontranslator.com\/es\/compatibilidad\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RANGO.PERCENTIL\"}]},{\"@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 (RANGO.PERCENTIL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) 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\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/percentrank\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:42+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) 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\/","url":"https:\/\/functiontranslator.com\/es\/percentrank\/","name":"Funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) 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:42+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK (RANGO.PERCENTIL) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/percentrank\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/percentrank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/percentrank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Compatibilidad","item":"https:\/\/functiontranslator.com\/es\/compatibilidad\/"},{"@type":"ListItem","position":3,"name":"RANGO.PERCENTIL"}]},{"@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\/14139","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=14139"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14139\/revisions"}],"predecessor-version":[{"id":30230,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14139\/revisions\/30230"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}