Formula - Weighted Moving Average | Propertylogy

Formula – Weighted Moving Average

By on June 13, 2018

When the moving average is needed for investment analysis and the most recent data carries a lot more weight than the earlier ones, the weighted moving average would be a more appropriate formula to use.

There are various methods used to calculate moving average. But 2 of which are the most commonly used by business analysts.

1) Double the latest value and adding 1 to total values

If we take for example, the value is month end and the period is a year, there would be a total of 12 month end values to work with.

(V+Vr)/(N+1) = A

V – Sum of values

Vr – Most recent value

N – Number of values

A – Weighted moving average

2) Use a reducing factor starting from the latest value

Using the previous scenario as example, the most recent value will multiply by 12, the second most recent multiply by 11, and so on until the last value.

Then divide the total sum of value by the number of value which is equivalent to 78. (12+11+10…)

(V1+V2+V3…)/N = A

V1 – Most recent value, V2 second most recent value, and so on

N – Number of values

A – Weighted moving average

If you have your own variables that carry a greater weight, use your own methods to give more weight to more important values.

Support us on Patreon

You May Also Like...

hair1 eye1 abs1
View the latest and lowest Singapore Home Loan rates
Why friends look forward to your FAILURE
Hiring a competent agent
Best EVER excuses for being late to work

Investors and homeowners receive our newsletters. Subscribe to our list.

Get More Real Estate Knowledge & Insights From Our Newsletters

Enter your email below

Send this to a friend