On 9/22/2009 5:48:00 PM, leyo123 wrote:
>Hi,
>Thanks.
>This is related to filters.
>In your reply, Total =x+y+z.
>Here, I am doing a Montecarlo
>analysis and see the effect on
>"Total".I want to create
>random vector with -1 and + 1
>as values, multiply with x,
>mustily with y and multiply
>with z and add together to get
>"Total". Hope I explained it
>...
>Thanks
_____________________________
You seem to pretend that by manipulating 3 data sets in your own taste, the result of the manipulation will be one more reliable or "smoother" ... maybe. But, there is no big logic in simple arithmetic manipulations. There are plenty of referenced and traceable smoothing techniques ... ksmooth, exponential just to name some common ones.
Do + in the work sheet, abstract. Making yourself understood will attract interest and might result in some kind of tool if not already existing. How many wild data sets do you expect ? Maybe your project falls in the PCA category [Principal Component Analysis].
jmG