C
Chip
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))
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))