View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Weighted Averages?

Not sure why you use the terms 'weight' and 'average' so I may have missed
the point

You seem to be talking about a geometric series
a + ar + ar² + ar³ ...... ar^(n-1)
In your case r = 1.1 (a 10% increase each time) and n=9 (you have 10
numbers)
You could look at http://en.wikipedia.org/wiki/Geometric_series and do some
algebra

But I put 1 in A1
In A1 I use =A1*1.1
This I copied down to A10
In A11 I used =SUM(A1:A10)
Then I used Solver to make A11 equal 200 by changing A1; it gave an answer
of 12.5490789765023
I also used Goal Seek and it gave the same result (of course)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kevin" wrote in message
...

Assume that 10 numbers = 200

What formula would I use to average (weight) these 10 numbers so that the
2nd number is 10% greater than the 1st, the 3rd number is 10% greater than
the 2nd, the 4th number is 10% greater than the 3rd, etc . . . and the
total
of 10 numbers will equal 200?

I'm sure someone knows the answer!

Thanx in advance

Kevin


--
Kevin