The expression "average of an average" is math heresy but your approach isn't
really doing that and is giving the correct answer so lets all go and buy a
Toyota who edge it by a full percentage point

Mike


"Chip" wrote:

Howdy,

I work at a car dealership and we sell both Hondas and Toyotas. I've done a
survey with my customers who own cars. I did this to find out if people who
own Hondas are more satisfied than people with Toyotas.

I want to "average the averages" below to find out if Honda owners are more
happy than Toyota owners. Here's some sample data:

Honda
Product #votes Average satisfaction grade per vote
Civic 1,211 75%
Accord 811 82%
Del Sol 355 55%
Passport 561 55%

Toyota
Corolla 1,356 88%
Camry 334 36%
Supra 284 36%
Landcrser 5 36%

How would I average the averages? Would I use the SUMPRODUCT formula for
each set? In other words, if the Honda set was in columns A through C, I
would do this, right?

=SUMPRODUCT(C1:C4,B1:B4/SUM(B1:B4))