Manuals/calci/FORECAST
Jump to navigation
Jump to search
FORECAST(x1, ky1’s, kx1’s)
Where X1 is the data point, ky1 is the dependent array or range of data and ky2
is the independent array or range of data.
It Predicts or calculates a future value by using existing values. The predicted value is a y1-value for a given x1-value.
· FORECAST displays an error, when x is nonnumeric.
· when the variance of kx1’s equals zero FORECAST displays errror.
· The equation for FORECAST is a+bx, where:
and:
and where x and y are the sample means AVERAGE(kx1's) and AVERAGE(ky1's).
FORECAST
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 4 | 25 | 4.730174 | |
| Row2 | 5 | 23 | ||
| Row3 | 8 | 32 | ||
| Row4 | 17 | 36 | ||
| Row5 | 22 | 40 | 0 | |
| Row6 |
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
=FORECAST (25, C1R1:C1R6, C2R1:C2R6) is 4.7302.