Weighted Average Charts by Volume: trendlines

[ojj00u]

Hi,

I am trying to produce a chart with the following data:


x-axis Y-Value Volume
10 1.95% 717
11 1.93% 519
12 2.31% 909
13 1.85% 866
14 1.95% 718
15 1.60% 810
16 1.60% 937
17 1.80% 890
18 2.10% 1572
19 1.05% 1333
20 0.99% 1520

Such that the 1.95 value at point 10 will occur 717 times, so that
can plot a trendline through the points plotted in order that thi
takes volume into account.

Any ideas welcome???

Thanks,

O

 

[Jon Peltier]

OJ -

See what stats guru Jerry Lewis said about weighted linear regression in
this post from January:

http://www.google.com/groups?selm=3FFC11D7.3060403@no_e-mail.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______