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.