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

La funci\u00f3n RANGO.PERCENTIL.INC, disponible tanto en Microsoft Excel como en Google Sheets, permite calcular el rango percentil de un valor espec\u00edfico dentro de un conjunto de datos, incluyendo los valores extremos. Este art\u00edculo proporciona una gu\u00eda detallada sobre c\u00f3mo utilizar esta funcionalidad, explicando su sintaxis y ofreciendo ejemplos concretos que facilitar\u00e1n su comprensi\u00f3n y aplicaci\u00f3n pr\u00e1ctica.<\/p>\n

Sintaxis de la funci\u00f3n<\/h2>\n

La sintaxis general de RANGO.PERCENTIL.INC se presenta a continuaci\u00f3n:<\/p>\n

RANGO.PERCENTIL.INC(matriz, x, [significancia])<\/code><\/pre>\n
    \n
  • matriz<\/code>: Es el conjunto de datos en el que se desea calcular el rango percentil del valor x<\/code>.<\/li>\n
  • x<\/code>: Es el valor cuyo rango percentil se desea determinar.<\/li>\n
  • significancia<\/code> (opcional): Es el n\u00famero de d\u00edgitos significativos para el resultado. Si se omite, el valor predeterminado es 3.<\/li>\n<\/ul>\n
    Por ejemplo, si tenemos un rango de datos en A1:A10 y queremos calcular el rango percentil del n\u00famero 5, la f\u00f3rmula ser\u00eda:<\/p>\n
    =RANGO.PERCENTIL.INC(A1:A10, 5)<\/code><\/pre>\n
    Ejemplos de aplicaci\u00f3n pr\u00e1ctica<\/h2>\n
    Veamos ahora algunos casos pr\u00e1cticos donde esta funci\u00f3n resulta especialmente \u00fatil.<\/p>\n
    Caso 1: Evaluaci\u00f3n acad\u00e9mica<\/h2>\n
    Imagina que eres un profesor analizando los resultados de ex\u00e1menes. Si las calificaciones est\u00e1n en el rango B1:B30 y deseas saber el rango percentil de un estudiante que ha obtenido 75 puntos, utilizar\u00edas:<\/p>\n
    =RANGO.PERCENTIL.INC(B1:B30, 75)<\/code><\/pre>\n
    Esto indicar\u00e1 el rango percentil de la puntuaci\u00f3n de 75 con respecto a las dem\u00e1s calificaciones del grupo.<\/p>\n
    Caso 2: An\u00e1lisis de ventas<\/h2>\n
    En un contexto comercial, si deseas evaluar las ventas anuales de diferentes productos listadas en el rango C1:C40 y te interesa conocer el rango percentil de una venta espec\u00edfica de $20,000, emplear\u00edas:<\/p>\n
    =RANGO.PERCENTIL.INC(C1:C40, 20000)<\/code><\/pre>\n
    Esto te mostrar\u00e1 c\u00f3mo se sit\u00faa una venta de $20,000 en comparaci\u00f3n con el total de ventas anuales.<\/p>\n
    Utilizar la funci\u00f3n RANGO.PERCENTIL.INC es muy valioso no solo en sectores educativos y empresariales, sino tambi\u00e9n en cualquier contexto donde es crucial entender c\u00f3mo se posiciona un valor dentro de un conjunto de datos m\u00e1s amplio. Al proporcionar un punto de vista percentil, esta herramienta mejora significativamente la interpretaci\u00f3n y la toma de decisiones basadas en datos.<\/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":[540],"tags":[],"class_list":["post-14138","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) 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-inc\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/percentrank-inc\/\" \/>\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:40+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.INC (RANGO.PERCENTIL.INC) 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-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/percentrank-inc\/\",\"name\":\"Funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) 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:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank-inc\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/percentrank-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/percentrank-inc\/#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.INC\"}]},{\"@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.INC (RANGO.PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) 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-inc\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/percentrank-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) 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-inc\/","url":"https:\/\/functiontranslator.com\/es\/percentrank-inc\/","name":"Funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) 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:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTRANK.INC (RANGO.PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/percentrank-inc\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/percentrank-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/percentrank-inc\/#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.INC"}]},{"@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\/14138","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=14138"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14138\/revisions"}],"predecessor-version":[{"id":30229,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14138\/revisions\/30229"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}