Manuals/calci/FORECAST
FORECAST(n,y,x)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is the data point .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} is the dependent array of data.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} is the independent array of data.
Description
- This function gives the predicted value of the dependent variable for the specific value, x, of the independent variable by using a least squares linear regression to predict y values from x values.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FORECAST(n,y,x), n} is the data point to predict a value. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} is the dependent array of data to predict the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} -value and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} is the independent array of data to predict the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} -value.
- The formula for Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FORECAST} is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a+bx}
- where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a=\bar{y}-b \bar{x}} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b=\frac{\sum (x-\bar{x})(y-\bar{y})}{\sum(x-\bar{x})^2}} .
- Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{x}} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{y}} are the sample means of x and y.
- This function will give the result as error when
1. Any one of the value is nonnumeric. 2. The values of x and y are empty or contain a different number of data points. 3. The variance of x 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.
See Also