Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > FORECAST
 

FORECAST(x, known_y's, known_x's)

 
 Returns the future value along a linear trend by using existing values.

 xThe data point for which you want to predict a value.
 known_yThe dependent array or range of cells.
 known_xThe independent array or range of cells.

 REMARKS
 
  		• This function can return an array
     
  		• If "x" is not numeric, then #VALUE! is returned.
     
  		• If "known_y" and "known_x" are empty or contain a different number of data points, then #N/A is returned.
     
  		• If the variance of "known_x" equals zero, then #DIV/0! is returned.

     EXAMPLES
     
     A
    1=FORECAST(30,{6,7,9,15,21},{20,28,31,38,40}) = 10.607
    2=FORECAST(3.2,2,3) = #DIV/0!
    		 
     Functions - F | Index - F | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top