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

Introducci\u00f3n a la funci\u00f3n PERCENTIL.EXC<\/h2>\n

La funci\u00f3n PERCENTIL.EXC<\/code> de Excel y Google Sheets se utiliza para determinar el percentil espec\u00edfico de un conjunto de datos, excluyendo los valores situados en el 0% y el 100%. Esto significa que los valores m\u00ednimo y m\u00e1ximo de la muestra no son considerados en el c\u00e1lculo. Esta herramienta es especialmente \u00fatil en estad\u00edsticas descriptivas, donde es necesario analizar la distribuci\u00f3n de los datos sin incluir los extremos.<\/p>\n

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

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

PERCENTIL.EXC(datos, k)<\/code><\/pre>\n
    \n
  • datos<\/strong>: El rango de celdas que contiene el conjunto de datos.<\/li>\n
  • k<\/strong>: El percentil deseado a calcular. Este valor debe ser mayor que 0 y menor que 1.<\/li>\n<\/ul>\n
    Ejemplo de uso b\u00e1sico:<\/p>\n
    =PERCENTIL.EXC(A1:A10, 0.3)<\/code><\/pre>\n
    Este ejemplo determina el percentil 30 del rango de celdas de A1 a A10, excluyendo el valor m\u00ednimo y m\u00e1ximo.<\/p>\n
    Aplicaciones pr\u00e1cticas de la funci\u00f3n<\/h2>\n
    Ejemplo 1: An\u00e1lisis de ex\u00e1menes<\/h3>\n
    Imaginemos que un profesor necesita conocer los percentiles 25 y 75 de las notas de un examen para ajustar la calificaci\u00f3n mediante una curva, y desea omitir los valores at\u00edpicos para hacer una evaluaci\u00f3n m\u00e1s equitativa.<\/p>\n
    Datos de las calificaciones: 55, 60, 65, 70, 75, 80, 85, 90, 95, 100<\/p>\n
     Calificaciones: | 55 | 60 | 65 | 70 | 75 | | 80 | 85 | 90 | 95 | 100 |<\/code><\/pre>\n
    =PERCENTIL.EXC(A1:J1, 0.25) \/\/ Resultado: 62.5 =PERCENTIL.EXC(A1:J1, 0.75) \/\/ Resultado: 87.5<\/code><\/pre>\n
      \n
    • El percentil 25 es 62.5, indicando que el 25% de las calificaciones son inferiores a este valor.<\/li>\n
    • El percentil 75 es 87.5, lo que muestra que el 75% de las calificaciones son inferiores a este valor.<\/li>\n<\/ul>\n
      Ejemplo 2: An\u00e1lisis de ingresos<\/h3>\n
      Una empresa desea analizar la distribuci\u00f3n del salario entre sus empleados, excluyendo los ingresos m\u00e1s bajos y m\u00e1s altos para considerar si es necesario ajustar las escalas salariales.<\/p>\n
      Datos de ingresos: $30,000, $32,000, $34,000, $36,000, $38,000, $40,000, $42,000, $44,000, $46,000, $48,000<\/p>\n
       Ingresos: | 30000 | 32000 | 34000 | 36000 | 38000 | | 40000 | 42000 | 44000 | 46000 | 48000 |<\/code><\/pre>\n
      =PERCENTIL.EXC(A1:J1, 0.10) \/\/ Resultado: 32000 =PERCENTIL.EXC(A1:J1, 0.90) \/\/ Resultado: 46000<\/code><\/pre>\n
        \n
      • El percentil 10 es $32,000, demostrando que el 10% de los ingresos son inferiores a esta cifra, omitiendo los extremos.<\/li>\n
      • El percentil 90 es $46,000, reflejando que el 90% de los ingresos son inferiores a esta cantidad, tambi\u00e9n sin contar los valores extremos.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Devuelve el k-\u00e9simo percentil de los valores de un rango, donde k est\u00e1 en el rango 01, exclusivo<\/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-14134","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.EXC (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\/percentile-exc\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/percentile-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:29+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.EXC (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\/percentile-exc\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/percentile-exc\/\",\"name\":\"Funci\u00f3n PERCENTILE.EXC (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:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/percentile-exc\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/percentile-exc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/percentile-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\":\"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 PERCENTILE.EXC (PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.EXC (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\/percentile-exc\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/percentile-exc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:55:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n PERCENTILE.EXC (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\/percentile-exc\/","url":"https:\/\/functiontranslator.com\/es\/percentile-exc\/","name":"Funci\u00f3n PERCENTILE.EXC (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:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n PERCENTILE.EXC (PERCENTIL.EXC) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/percentile-exc\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/percentile-exc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/percentile-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":"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\/14134","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=14134"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14134\/revisions"}],"predecessor-version":[{"id":30225,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14134\/revisions\/30225"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}