Difference between revisions of "Manuals/calci/FORECAST"
Jump to navigation
Jump to search
Line 52: | Line 52: | ||
# =FORECAST(24,E1:E4,F1:F4) = 31.71054889 | # =FORECAST(24,E1:E4,F1:F4) = 31.71054889 | ||
# =FORECAST(10,C5:F5,C6:E6) = NAN. | # =FORECAST(10,C5:F5,C6:E6) = NAN. | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|ksCVXXh5_hk|280|center|FORECAST}} | ||
==See Also== | ==See Also== |
Revision as of 14:27, 24 June 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.
ZOS
- The syntax is to calculate this function in ZOS is
- is the data points.
- For e.g.,FORECAST(30,[10,12,16,21,35],[9,14,23,39,76])
- FORECAST(61,[22..28],[43..49])
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.