Manuals/calci/FORECAST
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
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 |
- =FORECAST(26,A1:A6,B1:B6) = 13.16666667
- =FORECAST(18,C1:C4,D1:D4) = 2.119541779
- =FORECAST(24,E1:E4,F1:F4) = 31.71054889
- =FORECAST(10,C5:F5,C6:E6) = NAN.