If you Google for Weighted Standard Deviation, here's the first link:

http://www.itl.nist.gov/div898/softw...2/weightsd.pdf

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


"bondcrash" wrote
in message ...

i need to give different weights to 8 chrnological data - the higher to
most recent data and so forth. sum of all the weights must be one


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile:
http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=486545