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

forecast



PureBytes Links

Trading Reference Links







<font size=3 color=black
face=Arial><span style='font-size:12.0pt;mso-ansi-font-size:12.0pt;font-family:
Arial'> In excel using the forecast
function with this data I get a large value. I should be getting the next days
closing  price something in the forties

<font size=3 color=black
face=Arial><span style='font-size:12.0pt;mso-ansi-font-size:12.0pt;font-family:
Arial'>=FORECAST(6,B3:B8,F3:F8)

<span
class=EmailStyle15><span style='font-size:
12.0pt;mso-ansi-font-size:12.0pt;font-family:Arial'>x=6<span
style="mso-spacerun: yes">   Y=2/4/02, 2/1/02, 1/31/02,
1/30/02, 1/29/02, 1/28/02<span style="mso-spacerun:
yes">       X=43.34, 41.99, 42.15, 37.00,
36.85, 37.33

<font size=3 color=black
face=Arial><span style='font-size:12.0pt;mso-ansi-font-size:12.0pt;font-family:
Arial'> 

<font size=3 color=black
face=Arial><span style='font-size:12.0pt;mso-ansi-font-size:12.0pt;font-family:
Arial'>x=37262.75   <span
style="mso-spacerun: yes"> what am I<span style="mso-spacerun:
yes">  doing wrong.