How To Calculate A Weighted Average In Excel (With Percentages!)
✉️ Join my newsletter
https://steven-bradburn.beehiiv.com/s...
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
https://toptipbio.com/weighted-averag...
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 https://techsmith.z6rjha.net/c/198849...
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website https://toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
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.
Watch video How To Calculate A Weighted Average In Excel (With Percentages!) online, duration hours minute second in high quality that is uploaded to the channel Steven Bradburn 27 July 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 174,400 times and liked it 1.3 thousand visitors.
