Weighted Average?

R

RussG

Is there a weighted average function, whereby I could create a textbox in the
Footer section that would give me the average of one column, weighted by
another?
If not, is "sumproduct" an available function?

Thanks!
RG
 
B

BruceM

I'm not sure just what you are trying to do, but you can put an unbound text
box into the report footer (or a group footer) with an expression as its
Control Source:
=Avg([SomeField]) * Avg([OtherField])
or whatever exactly the weighting number is (the meaning of "weighted by
another" is unclear). Note that you can't use a calculated control in such
a situation. If Avg([SomeField]) is already in a text box, you still need
to use the expression in the weighted text box. You can't refer to the
calculated control itself.
 
M

Marshall Barton

RussG said:
Is there a weighted average function, whereby I could create a textbox in the
Footer section that would give me the average of one column, weighted by
another?
If not, is "sumproduct" an available function?
Click to expand...


I believe the usual weighted average is:

Sum(amt * wgt) / Sum(wgt)
 
Top