If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
weighted average
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 23 total count 12 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. |
#2
|
|||
|
|||
weighted average
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 23 total count 12 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. |
#3
|
|||
|
|||
weighted average
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 23 total count 12 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. |
#4
|
|||
|
|||
weighted average
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 23 total count 12 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. |
#5
|
|||
|
|||
weighted average
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 23 total count 12 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. |
#6
|
|||
|
|||
weighted average
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 23 total count 12 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. |
#7
|
|||
|
|||
weighted average
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 23 total count 12 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. |
Thread Tools | |
Display Modes | |
|
|