{"id":177,"date":"2023-11-13T18:13:54","date_gmt":"2023-11-13T18:13:54","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/"},"modified":"2023-12-06T11:35:04","modified_gmt":"2023-12-06T11:35:04","slug":"media-ponderada","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/","title":{"rendered":"Como calcular a m\u00e9dia ponderada no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-2693150178\"><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><div class=\"excel-before-content\" id=\"excel-3871547549\"><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 class=\"has-text-align-left\">Uma m\u00e9dia \u00e9 a melhor maneira de obter uma vis\u00e3o geral dos dados. Mas \u00e0s vezes a m\u00e9dia fornece um valor tendencioso. Nessas situa\u00e7\u00f5es [sempre], a melhor forma \u00e9 calcular a m\u00e9dia ponderada.<\/p><p> E descobri que a melhor maneira \u00e9 usar uma f\u00f3rmula combinando as fun\u00e7\u00f5es SUMPRODUCT e SUM.<\/p><p> Este m\u00e9todo \u00e9 simples e f\u00e1cil de aplicar. Ent\u00e3o, hoje neste artigo, gostaria de compartilhar com voc\u00eas como calcular a m\u00e9dia ponderada no Excel usando SUMPRODUCT e SUM.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> Diferen\u00e7a entre m\u00e9dia normal e ponderada<\/h2><p> No exemplo abaixo, temos 1.658 como m\u00e9dia normal e 1.445 como m\u00e9dia ponderada. Deixe-me esclarecer essa diferen\u00e7a em dois pontos. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"diferente entre a m\u00e9dia ponderada normal e como calcular a m\u00e9dia ponderada no Excel com somaproduto\"><\/figure><\/div><ul><li> <strong>Primeiro:<\/strong> se voc\u00ea multiplicar 1.658 (m\u00e9dia) por 68 (quantidade), obter\u00e1 112.742, que n\u00e3o \u00e9 igual ao valor total. Mas se voc\u00ea multiplicar 1.445 (m\u00e9dia ponderada) por 68 (quantidade), obter\u00e1 98.289, que \u00e9 igual ao valor total.<\/li><li> <strong>Segundo:<\/strong> o Produto 1 tem o pre\u00e7o mais baixo e a maior quantidade, enquanto o Produto 4 tem o pre\u00e7o mais alto e a menor quantidade.<\/li><\/ul><p> No c\u00e1lculo da m\u00e9dia normal voc\u00ea n\u00e3o leva em considera\u00e7\u00e3o a quantidade e se houver altera\u00e7\u00e3o na quantidade n\u00e3o haver\u00e1 efeito no pre\u00e7o m\u00e9dio. E, na m\u00e9dia ponderada, voc\u00ea pode considerar a quantidade como peso.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Passo para calcular a m\u00e9dia ponderada no Excel<\/h2><p> Para calcular a m\u00e9dia ponderada, usamos a mesma tabela de dados que mostrei no exemplo acima. <\/p><div class=\"gb-container gb-container-bafb25cc gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-91201309\"><div class=\"gb-grid-column gb-grid-column-15a917ef\"><div class=\"gb-container gb-container-15a917ef\"><h2 class=\"gb-headline gb-headline-f2deb261 gb-headline-text gb-headline-download-2\"> Obtenha o arquivo Excel <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-18357188\"><div class=\"gb-container gb-container-18357188\"><div class=\"gb-container gb-container-76cbe15e\"> <a class=\"gb-button gb-button-cb63d00a gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-pour-calculer-la-moyenne-mobile-avec-sumproduct.xlsx\" rel=\"nofollow\">Download<\/a> <\/div><\/div><\/div><\/div><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-a-utiliser-pour-calculer-la-moyenne-ponderee-dans-excel-avec-la-formule-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"diferente entre a m\u00e9dia ponderada normal e como calcular a m\u00e9dia ponderada no Excel com somaproduto\"><\/figure><\/div><p> Agora siga estes dois passos simples.<\/p><ul><li> Na c\u00e9lula C7, insira a seguinte f\u00f3rmula: =SUMPRODUCT(B2:B6,C2:C6)\/SUM(B2:B6). <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/entrer-des-formules-dans-le-tableau-de-donnees-a-utiliser-pour-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"insira f\u00f3rmulas na tabela de dados para usar para calcular a m\u00e9dia ponderada no Excel com somaproduto\"><\/figure><\/div><ul><li> Clique OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-ok-dans-le-tableau-de-donnees-a-utiliser-pour-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"clique em ok na tabela de dados a ser usada para calcular a m\u00e9dia ponderada no Excel com somaproduto\"><\/figure><\/div><p> Agora voc\u00ea tem 1.445 como a m\u00e9dia ponderada de pre\u00e7o e produto. Como eu disse, SUMPRODUCT \u00e9 uma forma simples de calcular m\u00e9dia ponderada ou m\u00e9dia ponderada no Excel. A melhor parte do SUMPRODUCT \u00e9 que ele pode multiplicar e adicionar um array em uma \u00fanica c\u00e9lula.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(B2:B6,C2:C6)\/SUM(C2:C6)<\/code><\/pre><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> Como \u00e9 que isso funciona<\/h3><p> Precisamos quebrar essa f\u00f3rmula para entend\u00ea-la. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/les-formules-se-decomposent-pour-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" sizes=\"\" srcset=\"\" alt=\"f\u00f3rmulas se decomp\u00f5em para calcular a m\u00e9dia ponderada no Excel com somaproduto\"><\/figure><\/div><p> Primeiro, SUMPRODUCT calcular\u00e1 o produto do pre\u00e7o e da quantidade de todos os produtos e retornar\u00e1 a soma de todos eles. Depois disso, algumas fun\u00e7\u00f5es fornecer\u00e3o a soma da quantidade. E no final voc\u00ea obter\u00e1 a m\u00e9dia ponderada dividindo os valores das duas fun\u00e7\u00f5es.<\/p><p> Confira: <a href=\"https:\/\/exceladvisor.org\/pt\/condicao-em-soma-produto\/\"><strong>SUMPRODUTIVO<\/strong><\/a><\/p><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> Calcule a m\u00e9dia m\u00f3vel ponderada<\/h2><p> Vamos um pouco mais longe. Vamos passar para a parte de an\u00e1lise de dados. Usando a mesma f\u00f3rmula, voc\u00ea tamb\u00e9m pode calcular a m\u00e9dia m\u00f3vel ponderada. <\/p><div class=\"gb-container gb-container-d0894b79 gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-fb05a72a\"><div class=\"gb-grid-column gb-grid-column-977d91db\"><div class=\"gb-container gb-container-977d91db\"><h2 class=\"gb-headline gb-headline-21846cd9 gb-headline-text gb-headline-download-2\"> Obtenha o arquivo Excel <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-098be44d\"><div class=\"gb-container gb-container-098be44d\"><div class=\"gb-container gb-container-1d96da0a\"> <a class=\"gb-button gb-button-e86530c2 gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-pour-calculer-la-moyenne-mobile-avec-sumproduct.xlsx\" rel=\"nofollow\">Download<\/a> <\/div><\/div><\/div><\/div><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/avec-moyenne-mobile-calculer-la-moyenne-ponderee-avec-sumproduct-1.png\" sizes=\"\" srcset=\"\" alt=\"com m\u00e9dia m\u00f3vel calcular m\u00e9dia ponderada no Excel com somaproduto\"><\/figure><\/div><p> Aqui est\u00e3o as etapas:<\/p><ul><li> Insira a f\u00f3rmula abaixo na c\u00e9lula D4 e arraste-a at\u00e9 o final. =SOMAPRODUTO(B2:B4,C2:C4)\/SOMA(C2:C4) <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-formules-pour-calculer-la-moyenne-mobile-et-calculer-la-moyenne-ponderee-avec-sumproduct-1.png\" sizes=\"\" srcset=\"\" alt=\"adicione f\u00f3rmulas para calcular a m\u00e9dia m\u00f3vel e calcular a m\u00e9dia ponderada no Excel com sumproduct\"><\/figure><\/div><ul><li> Depois de arrastar esta f\u00f3rmula, ela calcular\u00e1 a m\u00e9dia m\u00f3vel com base em 3 meses para cada m\u00eas.<\/li><\/ul><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> Como \u00e9 que isso funciona<\/h3><p> Se voc\u00ea verificar o instant\u00e2neo acima na c\u00e9lula D4, ter\u00e1 a m\u00e9dia m\u00f3vel de janeiro, fevereiro e mar\u00e7o. E, na c\u00e9lula D5, voc\u00ea tem a m\u00e9dia m\u00f3vel de fevereiro, mar\u00e7o e abril.<\/p><p> Assim, toda vez que voc\u00ea passar para um novo m\u00eas, obter\u00e1 a m\u00e9dia m\u00f3vel, incluindo o m\u00eas atual e os \u00faltimos dois meses. Basta tornar as refer\u00eancias de c\u00e9lulas relativas ao arrastar sua f\u00f3rmula. <\/p><div class=\"gb-container gb-container-3c0c09cb gb-container-download-2\"><div class=\"gb-grid-wrapper gb-grid-wrapper-2ce0b1ad\"><div class=\"gb-grid-column gb-grid-column-03e068ab\"><div class=\"gb-container gb-container-03e068ab\"><h2 class=\"gb-headline gb-headline-9978411b gb-headline-text gb-headline-download-2\"> Obtenha o arquivo Excel <\/h2><\/div><\/div><div class=\"gb-grid-column gb-grid-column-3f9fba78\"><div class=\"gb-container gb-container-3f9fba78\"><div class=\"gb-container gb-container-ee718499\"> <a class=\"gb-button gb-button-94105543 gb-button-text gb-button-download-2\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/moyenne-ponderee-avec-somme-du-produit.xlsx\" rel=\"nofollow\">Download<\/a><\/div><\/div><\/div><\/div><\/div><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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/valores-maximos-medios\/\">M\u00e9dia dos 5 valores mais altos do Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/media-de-erros-ignorados-2\/\">Erros m\u00e9dios, mas ignorados (#N\/A e outros erros)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/a-media-exclui-zeros-2\/\">N\u00famero m\u00e9dio, mas exclui zeros<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/media-de-celulas-nao-vazias-2\/\">M\u00e9dia apenas de c\u00e9lulas n\u00e3o vazias<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/porcentagem-media-2\/\">Calcule a m\u00e9dia dos valores percentuais<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-177","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>\u25b7 Como calcular a m\u00e9dia ponderada no Excel?<\/title>\n<meta name=\"description\" content=\"A m\u00e9dia ponderada \u00e9 um dos c\u00e1lculos mais importantes e a soma do produto \u00e9 um dos m\u00e9todos mais simples de calcul\u00e1-la.\" \/>\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\/pt\/media-ponderada\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como calcular a m\u00e9dia ponderada no Excel?\" \/>\n<meta property=\"og:description\" content=\"A m\u00e9dia ponderada \u00e9 um dos c\u00e1lculos mais importantes e a soma do produto \u00e9 um dos m\u00e9todos mais simples de calcul\u00e1-la.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:35:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/\",\"name\":\"\u25b7 Como calcular a m\u00e9dia ponderada no Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\",\"datePublished\":\"2023-11-13T18:13:54+00:00\",\"dateModified\":\"2023-12-06T11:35:04+00:00\",\"description\":\"A m\u00e9dia ponderada \u00e9 um dos c\u00e1lculos mais importantes e a soma do produto \u00e9 um dos m\u00e9todos mais simples de calcul\u00e1-la.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como calcular a m\u00e9dia ponderada no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Como calcular a m\u00e9dia ponderada no Excel?","description":"A m\u00e9dia ponderada \u00e9 um dos c\u00e1lculos mais importantes e a soma do produto \u00e9 um dos m\u00e9todos mais simples de calcul\u00e1-la.","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\/pt\/media-ponderada\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como calcular a m\u00e9dia ponderada no Excel?","og_description":"A m\u00e9dia ponderada \u00e9 um dos c\u00e1lculos mais importantes e a soma do produto \u00e9 um dos m\u00e9todos mais simples de calcul\u00e1-la.","og_url":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:35:04+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/","url":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/","name":"\u25b7 Como calcular a m\u00e9dia ponderada no Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png","datePublished":"2023-11-13T18:13:54+00:00","dateModified":"2023-12-06T11:35:04+00:00","description":"A m\u00e9dia ponderada \u00e9 um dos c\u00e1lculos mais importantes e a soma do produto \u00e9 um dos m\u00e9todos mais simples de calcul\u00e1-la.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/media-ponderada\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/different-entre-la-moyenne-ponderee-normale-et-comment-calculer-la-moyenne-ponderee-dans-Excel-avec-sumproduct.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/media-ponderada\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como calcular a m\u00e9dia ponderada no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=177"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/177\/revisions"}],"predecessor-version":[{"id":875,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/177\/revisions\/875"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}