How To Calculate A Weighted Average In Excel (With Percentages!)

Подробнее о видео

✉️ Join my newsletter


In this tutorial, I'm going to show you how to calculate a weighted average in Microsoft Excel with percentages. The weighted average is similar to the standard arithmetic average, except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

ONLINE GUIDE


VIDEO CHAPTERS
00:00 Intro
00:15 My example data
00:57 Calculating the average
01:40 Step 1 - Multiply the score by weight
02:13 Step 2 - Sum these values
02:29 Step 3 - Divide by the sum of the weights
03:33 Calculate weighted average with the SUMPRODUCT function
04:27 Wrapping up

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor
YouTube SEO
Software (Microsoft Excel 365 ProPlus)

FOLLOW US
Website
Facebook
Twitter

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.