Posted By

Scooter on 12/25/08


Tagged

excel


Versions (?)

Weighted Average


 / Published in: Other
 

URL: http://support.microsoft.com/default.aspx/kb/214049

I've been doing some sales forecasting for next year and needed to do a weighted average on historical data so that I could give stronger emphasis to more recent numbers. An ordinary average may be too high in situations where the oldest number is significantly higher than more recent numbers (due to introduction of a new product, for example).

  1. =SUMPRODUCT(A2:A3,B2:B3)/SUM(B2:B3)

Report this snippet  

You need to login to post a comment.