Como Calcular Média Ponderada no Excel

Cledison Nascimento 25/07/2019 Atualizado em: 02/04/2021 Comente! Aprender Excel Intermediário

Aprenda como calcular média ponderada no Excel.

Mas o que é a média ponderada?

Baixe agora planilha para poder praticar o que ensinamos neste tutorial:

A média ponderada é muito usada para fins estatísticos, pois ela consiste em uma medida de tendência central.

Diferente da média aritmética ou média simples que somamos todos os valores e dividimos pelo número de dados do tal conjunto, na média ponderada multiplicamos o valor de cada dado pelo peso de seu dado.

Vamos a prática

Clique na célula C15 e digite =MÉDIA(

Selecione os valores da coluna Nota

Pressione Enter e pronto. Já temos a média;

Agora vamos calcular média ponderada no Excel.

Cadastre seu email aqui no blog para receber em primeira mão todas as novidades, posts e videoaulas que postarmos.

Receber conteúdos de Excel

Preencha abaixo para receber conteúdos avançados de Excel.

Fique tranquilo, seu e-mail está completamente SEGURO conosco!

É muito importante que você me adicione na sua lista de contatos, para que os próximos emails não caiam no SPAM. Adicione este email: edson@ninjadoexcel.com.br

Clique na célula C16 e digite =SOMARPRODUTO(

Vamos indicar duas matrizes.

A primeira é a matriz Nota:

A segunda matriz é o Peso:

Feche o parente e chama a função SOMA:

Selecione novamente a coluna Peso:

Pressione Enter:

Viram como valores não são exatamente iguais?

O que acontece é que para as disciplinas de Física, Língua Portuguesa e Matemática são atribuídos pesos maior enquanto que para Filosofia, Geografia e História foram atribuídos pesos menor.

E a média ponderada baseia-se nesses pesos.

Conhece mais alguma maneira? Deixe sua opinião nos comentários.

Grande abraço e até o próximo artigo

Curso de Excel Básico ao Avançado

Quer aprender mais sobre Excel do Básico ao Avançado e se tornar um Ninja do Excel? Conheça o Curso de Excel Completo.

Veja também:

Artigo anterior Quer fazer investimento? Veja como calcular rendimentos no Excel

Próximo artigo Como ativar o Power View no Excel – Post atualizado

.epc-ovr[class*=epc-s] #footer ::-moz-selection,.epc-ovr[class*=epc-s] #sidebar-promo ::-moz-selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::-moz-selection,.epc-ovr[class*=epc-s] .capture-wrap ::-moz-selection{background:#1fac61;}.epc-ovr[class*=epc-s] #footer ::selection,.epc-ovr[class*=epc-s] #sidebar-promo ::selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::selection,.epc-ovr[class*=epc-s] .capture-wrap ::selection{background:#1fac61;}.epc-ovr[class*="epc-"] .sidebar section[class*="epico_pages"] a,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_links"] a,.epc-ovr .wp-calendar>caption,.epc-ovr input[type="submit"],.epc-ovr #header #nav input.search-submit[type="submit"],.epc-ovr #header .not-found input.search-submit[type="submit"],.epc-ovr.zen #sidebar-after-content .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .uberaviso,.epc-ovr[class*="epc-"] .fw.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .sc.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] #sidebar-after-content .sb.capture-wrap .uf-submit,.epc-ovr[class*="epc-"] .epico_author a[class*=button],.epc-ovr[class*="epc-"] input[type="submit"],.epc-ovr[class*="epc-"] .fw.capture-wrap a.uf-submit,.epc-ovr[class*="epc-"] .sb.capture-wrap a.uf-submit,.epc-ovr[class*="epc-"] .not-found input.search-submit[type="submit"]{background:#1fac61;}.epc-ovr .pagination .page-numbers.current{background:#1fac61 !important;}.epc-ovr #footer .widget_tag_cloud a:hover,.epc-ovr .loop-meta,.epc-ovr #menu-primary-items .sub-menu li a:hover,.epc-ovr .epc-button-border-primary,.epc-ovr #footer .search-field:hover,.epc-ovr #footer .search-field:focus,.epc-ovr .author-profile,.epc-ovr.page-template-landing{border-left:5px solid #1fac61 !important;}.epc-ovr #credits,.epc-ovr[class*="epc-"] .sidebar .epico_pop,.epc-ovr[class*="epc-"] .sidebar .epico_pop > div,.epc-ovr[class*="epc-"] #footer .epico_social a:hover,.epc-ovr .comment-reply-link{border-color:#1fac61 !important;}.epc-ovr .epc-button-border-primary,.epc-ovr #footer .epico_social a:hover,.epc-ovr #sidebar-top li:hover::before,.epc-ovr #menu-primary .sub-menu li a:hover::before,.epc-ovr #footer li:hover::before,.epc-ovr #menu-primary li.menu-item-has-children a:hover::before,.epc-ovr #menu-secondary li a:hover::before,.epc-ovr #search-toggle:hover::after,.epc-ovr .search-close .search-text,.epc-ovr #search-toggle::before,.epc-ovr #search-toggle:hover .search-text,.epc-ovr .search-text:hover,.epc-ovr #zen:hover i,.epc-ovr #zen.zen-active i,.epc-ovr #zen.zen-active:hover i,.epc-ovr.zen #footer a{color:rgba(31,172,97,.8) !important;}.epc-ovr .sidebar .epico_pop h3[class*="title"]::before,.epc-ovr .sidebar section[class*="epico_pages"] h3[class*="title"]::before{color:rgba(31,172,97,.8);}.epc-ovr[class*="epc-"] .fw.capture-wrap .uf-arrow svg polygon,.epc-ovr[class*="epc-"] .sb.capture-wrap .uf-arrow svg polygon,.epc-ovr[class*="epc-"] #sidebar-after-content .sb.capture-wrap .uf-arrow svg polygon,.epc-ovr.zen #sidebar-after-content .sb.capture-wrap .uf-arrow svg polygon{fill:#1fac61;}@media only screen and (max-width:680px){.epc-ovr #menu-primary>ul>li a:hover::before,.epc-ovr #menu-primary li a:hover::before,.epc-ovr #nav-toggle:hover .nav-text,.epc-ovr .nav-active #nav-toggle .nav-text{color:rgba(31,172,97,.8) !important;}.epc-ovr #menu-primary-items>li a:hover{border-left:5px solid rgba(31,172,97,.8) !important;}.epc-ovr .nav-active #nav-toggle span::before,.epc-ovr .nav-active #nav-toggle span::after,.epc-ovr #nav-toggle:hover .screen-reader-text,.epc-ovr #nav-toggle:hover .screen-reader-text::after,.epc-ovr #nav-toggle:hover .screen-reader-text::before{background:#1fac61 !important;}}@media only screen and (min-width:680px){.epc-ovr #header .menu-items > li > a{color:#1fac61;}}[class*="epc-"] #menu-secondary li a.menu-item:hover::before,.epc-ovr #page .sidebar .epico_pop h3[class*="title"]::before,.epc-ovr #page .sidebar section[class*="epico_pages"] h3[class*="title"]::before,.epc-ovr #page a:not(.elementor-button):not(.wp-block-button__link):not(.uf-submit):not(.uf-link):not(.uf-page):not(.uf-social):not(.wp-block-file__button):not(.post-page-numbers):not(.comments-link-byline):not(.category-link),.epc-ovr.plural .format-default .entry-author,.epc-ovr #breadcrumbs a,.epc-ovr #branding a,.epc-ovr #header .menu-items > li > a:hover,.epc-ovr #footer .widget_tag_cloud a:hover::before,.epc-ovr #zen.zen-active:hover i,.epc-ovr.page-template-landing #footer a,.epc-ovr .uf-wrap .uf a:not(.uf-submit){color:#1fac61 !important;}.epc-ovr #page #main-container .pagination a.page-numbers,.epc-ovr[class*="epc-"].plural .format-default .entry-author,.epc-ovr[class*=epc-s] #page #main-container .epico_author a[class*=button]{color:#fff !important;}.epc-ovr[class*=epc-s] #footer ::-moz-selection,.epc-ovr[class*=epc-s] #sidebar-promo ::-moz-selection,.epc-ovr[class*=epc-s] section[class*="pop-id"] ::-moz-selection,.epc-ovr[class*=epc-s] .capture-wrap ::-moz-selection,.epc-ovr #footer ::selection,.epc-ovr #sidebar-promo ::selection,.epc-ovr section[class*="pop-id"] ::selection,.epc-ovr .capture-wrap ::selection,.epc-ovr .epico_social a,.epc-ovr[class*=epc-s] .epico_author a[class*=button]{color:#fff;}.epc-ovr.epc-1 .uf_epicoepico_pop a,.epc-ovr.epc-2 .uf_epicoepico_pop a,.epc-ovr.epc-3 .uf_epicoepico_pop a{color:#aebbc2;}.epc-ovr #page a:not(.epico-pop_link):not(.elementor-button):not(.wp-block-button__link):not(.uf-submit):not(.uf-link):not(.uf-page):not(.uf-social):not(.wp-block-file__button):not(.post-page-numbers):not(.comments-link-byline):not(.category-link):not(.epico-pop-link):hover,.epc-ovr .comment-reply-link,.epc-ovr.page-template-landing #footer a:hover,.epc-ovr #breadcrumbs a:hover{color:#344146;}.epc-ovr .comment-reply-link:hover{border-color:#344146 !important;}.epc-ovr input[type="submit"]:hover,.epc-ovr #nav input.search-submit[type="submit"]:hover,.epc-ovr .not-found input.search-submit[type="submit"]:hover,.epc-ovr #nav input.search-submit[type="submit"]:active,.epc-ovr .not-found input.search-submit[type="submit"]:active,.epc-ovr[class*=epc-s].zen #sidebar-after-content .sb.capture-wrap .uf-submit:hover,.epc-ovr .pagination .page-numbers.current:active,.epc-ovr .pagination .page-numbers.current:hover{background:rgba(31,172,97,.6) !important;}.epc-ovr[class*=epc-s] .fw.capture-wrap .uf-submit:hover,.epc-ovr[class*=epc-s] .sb.capture-wrap .uf-submit:hover,.epc-ovr .sc.capture-wrap .uf-submit:hover,.epc-ovr #sidebar-after-content .sb.capture-wrap .uf-submit:hover,.epc-ovr[class*=epc-s] .epico_author a[class*=button]:hover,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_pages"] a:hover,.epc-ovr[class*="epc-"] .sidebar section[class*="epico_links"] a:hover{background:rgba(31,172,97,.6);}.epc-ovr #page .content a.elementor-button,.epc-ovr #main-container .content a.elementor-button:hover{color:#fff;}.wordpress[class*="epc-"] #sidebar-subsidiary{background-color:#f4f4f4;color:rgba(0,0,0,.5);border-bottom:0px;}[class*="epc-"] #sidebar-subsidiary .epico_social a{background:rgba(0,0,0,.2);box-shadow:0 0 0 10px #f4f4f4;}[class*="epc-"] #sidebar-subsidiary .epico_social a:hover{box-shadow:0 0 0 10px rgba(0,0,0,.2);}.page-template-tpl-helper-pb[class*="epc-"],.page-template-tpl-helper-pb-alt[class*="epc-"],.page-template-tpl-helper-min-pb[class*="epc-"],.page-template-landing[class*="epc-"]{background-color:#fff !important;}.page-template-landing[class*="epc-"] #page,.page-template-tpl-helper-min-pb[class*="epc-"] #page{border-top:none !important;}[class*="epc-s"].plural .loop-meta{background:#42b267;}[class*="epc-s"].plural .loop-meta h1,[class*="epc-s"].plural .loop-meta p,[class*="epc-s"].plural #page .loop-meta li::before{color:rgba(255,255,255,.9);background:#42b267;}[class*="epc-s"].plural #page .loop-meta a{color:rgba(255,255,255,.6) !important;}.epc-syst,.epc-syst label,.epc-syst textarea,.epc-syst input:not([type=submit]):not([type=radio]):not([type=checkbox]):not([type=file]),.epc-syst select[multiple=multiple],.epc-syst.epc-button,.epc-syst input[type="submit"],.epc-syst a.uf-button,button.uf-button,.epc-syst .not-found input.search-submit[type="submit"],.epc-syst #nav input.search-submit[type="submit"],.epc-syst #comments .comment-reply-link,.epc-syst #comments .comment-reply-login,.epc-syst .epico_author a[class*=button],.epc-syst.wordpress div.uberaviso a[class*="button"],.epc-syst.wordpress .mejs-controls a:focus>.mejs-offscreen,.epc-syst .format-quote p:first-child::before,.epc-syst .format-quote p:first-child::after,.epc-syst .epico-related-posts h4.related-post-title,.epc-syst .placeholder,.epc-syst .editor-tag,.epc-syst .uf-title-inner,.epc-syst .wp-block-calendar table{font-family:ui-sans-serif,-apple-system,Segoe UI,system-ui,Roboto,Helvetica Neue,Arial,Noto Sans,Liberation Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji,Twemoji Mozilla;}.epc-syst li.fa,.epc-syst li.fa::before,.epc-syst .fa,.epc-syst textarea.fa,.epc-syst input:not([type=submit]):not([type=radio]):not([type=checkbox]):not([type=file]).fa,.epc-syst .not-found input.search-submit[type="submit"],.epc-syst #search-wrap input.fa[type="search"],.epc-syst #nav input.search-submit[type="submit"],.epc-syst #respond #submit,.epc-syst .capture-wrap form input[class*="uf-"]{font-family:FontAwesome,ui-sans-serif,-apple-system,Segoe UI,system-ui,Roboto,Helvetica Neue,Arial,Noto Sans,Liberation Sans,sans-serif,Apple Color Emoji,Segoe UI Emoji,Segoe UI Symbol,Noto Color Emoji,Twemoji Mozilla !important;}@media screen and (max-width:420px){.social-likes__counter{display:none;}.sticky-active .social-total-shares{right:0;}.sticky-active #social-bar-sticky #social-close{right:5px;}}#cs-uf-epicoepico_capture_sc.sc{border:0px;background:#1f8b57;border-bottom:10px solid #1f8b57;}#cs-uf-epicoepico_capture_sc.sc .capture:nth-child(2){background:#27ad5f;}#cs-uf-epicoepico_capture_sc.sc .capture .capture-title{color:#fff;}#cs-uf-epicoepico_capture_sc.sc .capture .capture-notice,#cs-uf-epicoepico_capture_sc.sc .capture .capture-notice strong{color:#fff;}#cs-uf-epicoepico_capture_sc.sc .capture .capture-icon i::before,#cs-uf-epicoepico_capture_sc.sc .capture-inner .capture-iconinner i::before{color:#b3c1c7;}#cs-uf-epicoepico_capture_sc.sc .capture .capture-intro{color:#fff;}#cs-uf-epicoepico_capture_sc.sc .capture .capture-intro,#cs-uf-epicoepico_capture_sc.sc .capture .capture-intro *{color:#fff;}#cs-uf-epicoepico_capture_sc.sc .capture form .uf-email,#cs-uf-epicoepico_capture_sc.sc .capture form .uf-name{background:#fff;border:1px solid rgba(0,0,0,.2);color:#687e87;}#cs-uf-epicoepico_capture_sc.sc .capture form .uf-email:focus{background:#fff;border:1px solid rgba(0,0,0,.2);}#cs-uf-epicoepico_capture_sc.sc .capture form .uf-email::-webkit-input-placeholder,#cs-uf-epicoepico_capture_sc.sc .capture form .uf-name::-webkit-input-placeholder{color:#687e87 !important;}#cs-uf-epicoepico_capture_sc.sc .capture form .uf-email:-ms-input-placeholder,#cs-uf-epicoepico_capture_sc.sc .capture form .uf-name:-ms-input-placeholder{color:#687e87 !important;}#cs-uf-epicoepico_capture_sc.sc .capture .uf-submit:hover{background:#ff7657;}#cs-uf-epicoepico_capture_sc.sc.capture-wrap .capture-form{border-bottom:0px;}#cs-uf-epicoepico_capture_sc.sc .capture .uf-submit{background:#ffad00 !important;color:#fff;}#cs-uf-epicoepico_capture_sc.sc .uf-arrow svg polygon{fill:#00c7c0 !important;}#cs-uf-epicoepico_capture_sc .capture-inner:last-child{background-color:#1f8b57;}body.custom-background{background-color:#f4f4f4;}