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.

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" wrote:

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.

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.

"elaine9412" wrote:

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.

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" wrote:

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.

"elaine9412" wrote:

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.

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?

"Duke Carey" wrote:

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" wrote:

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.

"elaine9412" wrote:

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.

one more thing I want to exclude zeros

"Duke Carey" wrote:

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" wrote:

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.

"elaine9412" wrote:

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.

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.

"elaine9412" wrote:

one more thing I want to exclude zeros

"Duke Carey" wrote:

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" wrote:

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.

"elaine9412" wrote:

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.