A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

weighted average



 
 
Thread Tools Display Modes
  #1  
Old August 28th, 2008, 04:40 AM posted to microsoft.public.excel.worksheet.functions
elaine9412
external usenet poster
 
Posts: 6
Default 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  
Old August 28th, 2008, 01:03 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
external usenet poster
 
Posts: 1,027
Default 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  
Old August 28th, 2008, 03:28 PM posted to microsoft.public.excel.worksheet.functions
elaine9412
external usenet poster
 
Posts: 6
Default 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  
Old August 28th, 2008, 03:41 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
external usenet poster
 
Posts: 1,027
Default 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  
Old August 28th, 2008, 06:30 PM posted to microsoft.public.excel.worksheet.functions
elaine9412
external usenet poster
 
Posts: 6
Default 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  
Old August 28th, 2008, 06:31 PM posted to microsoft.public.excel.worksheet.functions
elaine9412
external usenet poster
 
Posts: 6
Default 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  
Old August 28th, 2008, 07:40 PM posted to microsoft.public.excel.worksheet.functions
Duke Carey
external usenet poster
 
Posts: 1,027
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.