All it takes is a little practice. While the weighted

[hoxesi8100@]

This means that the totals for days 2, 3, 4, and 5 all apply — they just shift one day to the left. Our new Day 5, meanwhile, gets 200 views. Our weights say the same; all that changes are the number of views since they’re tied to the most recent five days.

Using our new data, our weighted moving average is calculated like so:

Day 1: 10 (x 200)
Day 2: 15 (x 150)
Day 3: 15 (x 300)
Day 4: 25 (x 100)
Day 5: 35 (x 200)
As a result, we get a new average, which is: 182.5

In Excel, you’ll need to manually enter this formula in each applicable cell.

WMA = [value 1 x (weight)] + [value 2 x (weight)] + [value 3 x (weight)] + [value 4 x (weight)] + [value 5 x (weight)] / total weight

Better Than Average: Mastering Excel Operations
Once you get the hang of it, I think using the weighted average formula becomes pretty easy.moving average is slightly more complicated, it’s a great way to track performance data over time.

But that’s just the tip of the Excel iceberg. With practice and a little help from our Excel hacks guide, you can master the art of equations. Check it out below.

Editor's note: This post was originally belarus phone number material published in April 2022 and has been updated for comprehensiveness.What is Global Marketing? See 13 Businesses with Brilliant Strategies
Download Now: Free Global Marketing Playbook
Hannah Fleishman
Hannah Fleishman
Updated: January 02, 2025