View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Calculate weighted average for 1 column

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

"Jul2010" wrote in message
...
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