{"id":14165,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/jerarquia-media\/"},"modified":"2021-02-26T08:56:47","modified_gmt":"2021-02-26T08:56:47","slug":"rank-avg","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/rank-avg\/","title":{"rendered":"JERARQUIA.MEDIA"},"content":{"rendered":"

La funci\u00f3n JERARQUIA.MEDIA en Excel y en Google Tablas es una herramienta \u00fatil para calcular y organizar el rango promedio de elementos en una lista proporcionada. Se utiliza para determinar el rango de un n\u00famero espec\u00edfico en un conjunto de n\u00fameros, donde varios n\u00fameros id\u00e9nticos comparten el promedio de los rangos que ocupar\u00edan si se clasificaran individualmente.<\/p>\n

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

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

JERARQUIA.MEDIA(valor; referencia; [orden])<\/code><\/pre>\n
    \n
  • valor<\/code>: El n\u00famero que quieres encontrar el rango.<\/li>\n
  • referencia<\/code>: Es un rango de celdas o un array donde buscas el rango del valor<\/code>.<\/li>\n
  • [orden]<\/code>: Es un argumento opcional que determina el orden de clasificaci\u00f3n. 0 o omitido para ordenar de forma descendente, 1 para ordenar de manera ascendente.<\/li>\n<\/ul>\n
    A continuaci\u00f3n, se ofrecen ejemplos pr\u00e1cticos del uso de JERARQUIA.MEDIA:<\/p>\n
    =JERARQUIA.MEDIA(5, {1,2,3,4,5,6,7,8,9,10}) \/\/ Devuelve 5 =JERARQUIA.MEDIA(3, A1:A10, 1) \/\/ Suponiendo que A1:A10 contienen n\u00fameros del 1 al 10<\/code><\/pre>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    A continuaci\u00f3n se describen situaciones reales donde se puede aplicar la funci\u00f3n JERARQUIA.MEDIA.<\/p>\n
    Evaluaci\u00f3n de posiciones en competencias<\/h2>\n
    Imagina que tienes los tiempos de llegada de corredores en una carrera y quieres determinar la posici\u00f3n de cada uno, en caso de haber empates.<\/p>\n
    Supongamos los siguientes tiempos (en minutos): 1. Juan: 34 2. Ana: 37 3. Luis: 34 4. Mar\u00eda: 45 5. Carla: 37 F\u00f3rmula para Juan: =JERARQUIA.MEDIA(34, {34, 37, 34, 45, 37}, 0) Resultado: 1.5<\/code><\/pre>\n
    Con este resultado, comprendemos que Juan y Luis, al tener el mismo tiempo de 34 minutos, comparten las posiciones 1 y 2, promediando a 1.5.<\/p>\n
    An\u00e1lisis de ventas<\/h2>\n
    En un conjunto de datos de ventas anuales de vendedores, podr\u00edas querer saber c\u00f3mo se clasifica cada vendedor respecto a los dem\u00e1s.<\/p>\n
    Venta anual (en miles): 1. Vendedor A: $155 2. Vendedor B: $120 3. Vendedor C: $155 4. Vendedor D: $130 F\u00f3rmula para Vendedor A: =JERARQUIA.MEDIA(155, {155, 120, 155, 130}, 0) Resultado: 1.5<\/code><\/pre>\n
    Este resultado muestra que el vendedor A y C tienen la misma venta y por eso comparten las posiciones 1 y 2, con un promedio de 1.5 en el rango.<\/p>\n
    Esta funci\u00f3n resulta fundamental cuando es crucial entender no s\u00f3lo la posici\u00f3n individual sino tambi\u00e9n c\u00f3mo se distribuye esa posici\u00f3n en caso de existir empates en los datos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve la jerarqu\u00eda de un n\u00famero en una lista de n\u00fameros<\/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-14165","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n RANK.AVG (JERARQUIA.MEDIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) 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\/rank-avg\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/rank-avg\/\" \/>\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:56:47+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 RANK.AVG (JERARQUIA.MEDIA) 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\/rank-avg\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/rank-avg\/\",\"name\":\"Funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) 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:56:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/rank-avg\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/rank-avg\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/rank-avg\/#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\":\"JERARQUIA.MEDIA\"}]},{\"@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 RANK.AVG (JERARQUIA.MEDIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) 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\/rank-avg\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/rank-avg\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) 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\/rank-avg\/","url":"https:\/\/functiontranslator.com\/es\/rank-avg\/","name":"Funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) 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:56:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n RANK.AVG (JERARQUIA.MEDIA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/rank-avg\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/rank-avg\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/rank-avg\/#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":"JERARQUIA.MEDIA"}]},{"@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\/14165","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=14165"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14165\/revisions"}],"predecessor-version":[{"id":30256,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14165\/revisions\/30256"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}