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

La funci\u00f3n PERCENTIL.INC, conocida as\u00ed en versiones en espa\u00f1ol de Excel y como PERCENTILE.INC en Google Sheets, se emplea para calcular el valor de un determinado percentil en un conjunto de datos. Un percentil representa el valor por debajo del cual se encuentra un porcentaje espec\u00edfico de los datos en un conjunto, siendo fundamental en an\u00e1lisis estad\u00edsticos para determinar rangos o realizar comparaciones.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

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

PERCENTIL.INC(rango_de_datos, k)<\/code><\/pre>\n
    \n
  • rango_de_datos<\/strong>: conjunto de datos donde se calcula el percentil.<\/li>\n
  • k<\/strong>: Es el percentil que se desea calcular, expresado como un decimal entre 0 y 1, donde 0 representa el m\u00ednimo (0%) y 1 el m\u00e1ximo (100%).<\/li>\n<\/ul>\n
    Ejemplo 1:<\/p>\n
    =PERCENTIL.INC(A1:A10, 0.9)<\/code><\/pre>\n
    Este ejemplo calcula el percentil 90 para los datos del rango A1 a A10.<\/p>\n
    Ejemplo 2:<\/p>\n
    =PERCENTIL.INC(B1:B20, 0.25)<\/code><\/pre>\n
    Este c\u00e1lculo encuentra el primer cuartil, es decir, el percentil 25 de los datos en las celdas B1 hasta B20.<\/p>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    PERCENTIL.INC se puede aplicar en una variedad de contextos como an\u00e1lisis financiero, evaluaci\u00f3n acad\u00e9mica o investigaci\u00f3n de mercado. A continuaci\u00f3n, se detallan dos ejemplos pr\u00e1cticos de su uso:<\/p>\n
    Caso 1: An\u00e1lisis de Evaluaciones<\/h2>\n
    Supongamos que un profesor desea conocer el percentil 75 de las calificaciones de sus estudiantes para identificar aquellos que superan el desempe\u00f1o promedio. Las notas est\u00e1n en el rango F1:F30.<\/p>\n
    =PERCENTIL.INC(F1:F30, 0.75)<\/code><\/pre>\n
    Este resultado indica la nota m\u00ednima para estar en el 25% superior, informaci\u00f3n \u00fatil para el reconocimiento acad\u00e9mico y para comprender mejor el rendimiento general.<\/p>\n
    Caso 2: Segmentaci\u00f3n de Consumidores en Marketing<\/h2>\n
    En un estudio de mercado, es \u00fatil segmentar a los clientes en funci\u00f3n de su gasto. Consideremos que los datos de gasto est\u00e1n en G1:G50.<\/p>\n
    =PERCENTIL.INC(G1:G50, 0.5)<\/code><\/pre>\n
    Este c\u00e1lculo determina la mediana del gasto, dividiendo a los clientes en dos grupos: los que gastan m\u00e1s y los que gastan menos de la mediana, facilitando la implementaci\u00f3n de estrategias de marketing diferenciadas.<\/p>\n
    En conclusi\u00f3n, PERCENTIL.INC es una herramienta potente para el an\u00e1lisis de distribuciones de datos, apoyando la toma de decisiones basadas en la ubicaci\u00f3n relativa de valores dentro de un conjunto.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el k-\u00e9simo percentil de los valores de un rango<\/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-14135","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n PERCENTILE.INC (PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.INC (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\/percentile-inc\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PERCENTILE.INC (PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.INC (PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/percentile-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:31+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 PERCENTILE.INC (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\/percentile-inc\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/percentile-inc\/\",\"name\":\"Funci\u00f3n PERCENTILE.INC (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:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.INC (PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/percentile-inc\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/percentile-inc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/percentile-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\":\"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 PERCENTILE.INC (PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.INC (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\/percentile-inc\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PERCENTILE.INC (PERCENTIL.INC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.INC (PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/percentile-inc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PERCENTILE.INC (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\/percentile-inc\/","url":"https:\/\/functiontranslator.com\/es\/percentile-inc\/","name":"Funci\u00f3n PERCENTILE.INC (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:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.INC (PERCENTIL.INC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/percentile-inc\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/percentile-inc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/percentile-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":"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\/14135","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=14135"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14135\/revisions"}],"predecessor-version":[{"id":30226,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14135\/revisions\/30226"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}