[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Forecasting or Prediction formula



PureBytes Links

Trading Reference Links

Hi All,

I can't seem to find a ms function that works like excel's Forecast 
function. 

In essence,i want the function to calculate,(predict), a future y 
value given an existing x value and arrays of previous x and y 
values. The approach is to fit a linear regression line to the 
historical x and y data and then use this line to predict a future y 
value given an x value. 

Anybody know how i can do this in ms?

Speak to you soon.

Cheers
 bruce


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/BefplB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/