Difference between revisions of "Manuals/calci/FORECAST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 52: Line 52:
  
 
==References==
 
==References==
*[https://support.microsoft.com/en-us/kb/828236 FORECAST]
+
*[https://support.microsoft.com/en-us/kb/828236 FORECAST ]

Revision as of 14:27, 8 May 2015

FORECAST(n,y,x)


  • is the data point .
  • is the dependent array of data.
  • is the independent array of data.

Description

  • This function gives the predicted value of the dependent variable for the specific value , of the independent variable by using a least squares linear regression to predict values from values.
  • In , is the data point to predict a value.
  • is the dependent array of data to predict the -value and is the independent array of data to predict the -value.
  • The formula for is
  • where and .
  • Here and are the sample means of and .
  • This function will give the result as error when
 1. Any one of the value is non-numeric.
 2. The values of  and  are empty or contain a different number of data points.
 3. The variance of  is zero.

Examples

Spreadsheet
A B C D E F
1 5 30 -28 -42 51 46
2 9 32 -18 34 14 -1
3 11 15 35 -13 0 29
4 18 28 12 25 60 18
5 32 41 2 5 9 17
6 4 10 4 14 28
  1. =FORECAST(26,A1:A6,B1:B6) = 13.16666667
  2. =FORECAST(18,C1:C4,D1:D4) = 2.119541779
  3. =FORECAST(24,E1:E4,F1:F4) = 31.71054889
  4. =FORECAST(10,C5:F5,C6:E6) = NAN.

See Also

References