Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging averages
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)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging averages
I don't like complicated forumlas like sumproduct. I would create a new
colum, and in it put the product of #votes*avg sat, for each row. Then, I would sum this for each auto maker, and divide by the total responses. This would give you the average you seek, and would give you a visual indicator of which brand is influencing the stat. "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)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging averages
=SUMPRODUCT(B1:B4,C1:C4)/SUM(B1:B4)
"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)) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging averages
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averages | Excel Discussion (Misc queries) | |||
averaging averages? | Excel Worksheet Functions | |||
Help with averages please | Excel Worksheet Functions | |||
Min & Max Averages | Excel Worksheet Functions | |||
Averages | Excel Worksheet Functions |