{"id":720,"date":"2023-09-25T11:03:23","date_gmt":"2023-09-25T11:03:23","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/"},"modified":"2023-12-25T10:23:49","modified_gmt":"2023-12-25T10:23:49","slug":"porcentaje-promedio-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/","title":{"rendered":"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1936679662\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Para calcular el promedio de porcentajes en Excel, puedes utilizar la funci\u00f3n PROMEDIO. Consulte el rango donde tiene los valores, luego presione Enter para obtener el resultado. Todo lo que necesitas hacer es que la celda en la que uses esta f\u00f3rmula debe tener el formato de celda de porcentaje. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79276\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\" sizes=\"auto, \" srcset=\"\" alt=\"promedio de valores porcentaje\" width=\"614\" height=\"332\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para esto.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula de porcentaje promedio<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n para hacer esto:<\/p>\n<ol type=\"1\">\n<li> Primero, en una celda de tipo =PROMEDIO.<\/li>\n<li> Ahora ingrese el par\u00e9ntesis inicial \u00ab(\u00ab.<\/li>\n<li> Despu\u00e9s de eso, consulte el rango en el que tiene los valores que desea promediar.<\/li>\n<li> Al final, ingrese el par\u00e9ntesis de cierre y presione Enter para obtener el resultado.<\/li>\n<\/ol>\n<p> En el momento en que presiona Enter, devuelve el promedio de los valores porcentuales del rango.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGE(A1:A3)<\/code><\/pre>\n<p> Excel es lo suficientemente inteligente como para cambiar el formato de celda a porcentaje cuando presiona Enter.<\/p>\n<h2 class=\"wp-block-heading\"> Media ponderada de porcentajes<\/h2>\n<p> S\u00ed, tambi\u00e9n puedes <a href=\"https:\/\/exceladvisor.org\/es\/peso-promedio\/\">calcular el promedio ponderado<\/a> de porcentajes. A continuaci\u00f3n tenemos el n\u00famero de estudiantes que obtuvieron puntuaciones por encima del porcentaje de losa. Y ahora necesitas calcular el promedio ponderado de estos valores porcentuales. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79277\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-moyenne-ponderee-des-pourcentages.png\" sizes=\"auto, \" srcset=\"\" alt=\"promedio ponderado de porcentajes\" width=\"636\" height=\"290\"><\/figure>\n<\/div>\n<p> Esta f\u00f3rmula es una combinaci\u00f3n de SUMPRODUCT y SUM.<\/p>\n<ol>\n<li> SUMPRODUCT multiplica cada n\u00famero de estudiantes por el porcentaje y luego suma todos estos productos.<\/li>\n<li> SUM devuelve el n\u00famero total de estudiantes (suma del n\u00famero de estudiantes).<\/li>\n<li> En \u00faltima instancia, divide los dos valores para obtener el promedio ponderado de los porcentajes.<\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Utilice PROMEDIOI<\/h2>\n<p> Tambi\u00e9n puede utilizar AVERAGEIF para promediar porcentajes o crear una condici\u00f3n para calcular el promedio. Supongamos que desea promediar valores superiores al 50%. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79278\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-moyenne-si-pour-les-valeurs-en-pourcentage.png\" sizes=\"auto, \" srcset=\"\" alt=\"valores-promedio-porcentuales\" width=\"563\" height=\"368\"><\/figure>\n<\/div>\n<p> Puedes utilizar la siguiente f\u00f3rmula:<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=AVERAGEIF(A2:A12,\"&gt;50%\")<\/code><\/pre>\n<p> Esto s\u00f3lo tiene en cuenta las celdas donde el porcentaje es superior a 50. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/pourcentage-moyen.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/valores-maximos-promedio\/\">Promedio de los 5 valores m\u00e1s altos en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/peso-promedio\/\">Calcular promedio ponderado en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/errores-promedio-ignorados-2\/\">Promedio pero ignorar errores (#N\/A y otros errores)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/el-promedio-excluye-ceros-2\/\">N\u00famero promedio pero excluye ceros<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para calcular el promedio de porcentajes en Excel, puedes utilizar la funci\u00f3n PROMEDIO. Consulte el rango donde tiene los valores, luego presione Enter para obtener el resultado. Todo lo que necesitas hacer es que la celda en la que uses esta f\u00f3rmula debe tener el formato de celda de porcentaje. En este tutorial, aprenderemos c\u00f3mo [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-720","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?\" \/>\n<meta property=\"og:description\" content=\"Para calcular el promedio de porcentajes en Excel, puedes utilizar la funci\u00f3n PROMEDIO. Consulte el rango donde tiene los valores, luego presione Enter para obtener el resultado. Todo lo que necesitas hacer es que la celda en la que uses esta f\u00f3rmula debe tener el formato de celda de porcentaje. En este tutorial, aprenderemos c\u00f3mo [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/\",\"name\":\"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\",\"datePublished\":\"2023-09-25T11:03:23+00:00\",\"dateModified\":\"2023-12-25T10:23:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?","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:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?","og_description":"Para calcular el promedio de porcentajes en Excel, puedes utilizar la funci\u00f3n PROMEDIO. Consulte el rango donde tiene los valores, luego presione Enter para obtener el resultado. Todo lo que necesitas hacer es que la celda en la que uses esta f\u00f3rmula debe tener el formato de celda de porcentaje. En este tutorial, aprenderemos c\u00f3mo [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:49+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/","url":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/","name":"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png","datePublished":"2023-09-25T11:03:23+00:00","dateModified":"2023-12-25T10:23:49+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-moyenne-des-valeurs-en-pourcentage.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/porcentaje-promedio-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo calcular el promedio de los valores porcentuales?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=720"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/720\/revisions"}],"predecessor-version":[{"id":875,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/720\/revisions\/875"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}