Weighted Average

Posted by ROSIE on March 16, 2001 8:39 AM

Is there a weighted average funtion in Excel?

Posted by Michelle on March 16, 2001 9:06 AM

For my exponential smoothing calculations I use:

=(sum(of cells)*.75)+(sum( of cells)*.25)

or whatever weights I want to give them for the forecast I want.

Hope this helps.

Posted by Mark W. on March 16, 2001 9:07 AM

Rosie, try:

{=SUM(values*weights)/SUM(weights)}

where "values" and weights are cells references
with the same dimensions (e.g., values in A1:A5
and weights in B1:B5). This is an array formula
which must be entered using Shift+Ctrl+Enter.
The braces, {}, are supplied by Excel -- not
typed by you.