Calculate weighted average for 1 column

J

Jul2010

Hi
I 'm looking for ways to calculated weighted average for 1 column, random
values as follows. I do not have frequences/quantities values.
1.3
1.4
1.6
1.7
1.7
1.8
1.6
1.6
1.7
1.6
 
F

Fred Smith

What do you want to weight them by? Without a second variable, the only
thing you can do is calculate the average, as in:
=average(A:A)

Regards,
Fred
 
D

David Biddulph

See the answers which were given to the very similar question asked by
"Julia" on this group an hour or so ago.
If you don't have weightings, you can calculate only an average, not a
weighted average.
 
D

David Biddulph

To expand on my answer, if you don't understand the concept of a weighted
average:

You have ten values listed in your example, and the average is 1.6
If instead of the ten values you had persented your data in the form
1.3
1

1.4
1

1.6
4

1.7
3

1.8
1


listing the values in one column and the number of occurrences in the second
column, then you could calculate the weighted average with the formula
=SUMPRODUCT(A1:A5,B1:B5)/SUM(B1:B5)
and again get the answer 1.6. If you had just averaged the five values on
column A (with =AVERAGE(A1:A5)) you would have got the answer 1.56, but by
including the weighting factors in column B it gives you the weighted
average of 1.6.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top