Idiot Question About Averaging

[BrooksTech]

Ive got two columns, A has amounts and B has set percentages literally "40%", "35%", etc. which all are set exactly 5% apart.

I need to see what is the average of all percentages as determined by the amounts in column A, meaning whatever actual is most popular, resulting in a number like say 38%.

(Eg. A1=20, B1=40%, A2=8, B2=35%, etc. )

 

[StephenCrump]

Do you mean weighted average?

=SUMPRODUCT(A1:A2,B1:B2)/SUM(A1:A2)

= 38.6% approx

 

[BrooksTech]

Im not familiar enough with weighted averaging, but your answer seems about what I was expecting. Thanks.

 

[Johnny C]

Weighted averaging just means 'weighting' the %age in terms of the value associated with that average compared to the overall total.

As a rule of thumb, if you have a statistical calculation, just use whatever function you can think of that returns a %age that looks reasonable LOL. That's the art of statistics.