weighted average

[elaine9412]

Thanks for my previous help. Now I have the data and I need to do a weighted
average for different groups of data as follows:

group 1:
Total count 3 total count >2<3 total count >1<2
12 9 5
2 7 3
5 8 1

Group 2 has same heading as above but more rows of data:
2 7 1
3 6 1
2 3 1
6 5 1
6 5 1


I have 8 separate groups.

Once again appreciate your help.

 

[Duke Carey]

Weighted average is simple to calculate, but your statement below is really
ambiguous. What do you want to average and how do you want to weight it?

 

[elaine9412]

I want the average of group 1 and give it a weighting of 3. I want the
average of group 2 and give it a weighting of 2.

 

[Duke Carey]

Which column of values gets averaged? 1st? 2nd? 3rd? or some combination?

Your answer also leads to another question. Simply multiplying the average
for group 1 by 3 will do what you want, but by itself it means nothing. Do
you want the weighted average of the 2 groups, given the weights you've just
described? In that case it is =(3*average(group1)+2*average(group2))/5

 

[elaine9412]

Great question. I suppose this is where my dilemna is . I want to know the
total weighted score for group,and speatrately the total average weighted
score gor group 2, this will then tell me if group 1 is rated more highly
than group 2 ..does this make sense?

 

[elaine9412]

one more thing I want to exclude zeros

Which column of values gets averaged? 1st? 2nd? 3rd? or some combination?

Your answer also leads to another question. Simply multiplying the average
for group 1 by 3 will do what you want, but by itself it means nothing. Do
you want the weighted average of the 2 groups, given the weights you've just
described? In that case it is =(3*average(group1)+2*average(group2))/5

 

[Duke Carey]

Elaine -

You are assuming that your posts explain your questions, when they don't.

You are showing 3 columns of numbers per 'group' but don't indicate which of
the columns should be averaged, and your comments about how they should be
weighted make little sense to me.

Total weighted score for the group?

It seems as though it'll be easy to offer you a solution, if you can simply
AND COMPLETELY state what you need to accomplish, what the inputs are and
what the mean. Without that info, we're left to guess.