Manuals/calci/FORECAST

FORECAST(n,y,x)

• $n$ is the data point .
• $y$ is the dependent array of data.
• $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 $FORECAST(n,y,x),n$ is the data point to predict a value. $y$ is the dependent array of data to predict the $y$-value and $x$ is the independent array of data to predict the $y$-value.
• The formula for $FORECAST$ is $a+bx$
• where $a={\bar {y}}-b{\bar {x}}$ and $b={\frac {\sum (x-{\bar {x}})(y-{\bar {y}})}{\sum (x-{\bar {x}})^{2}}}$.
• Here ${\bar {x}}$ and ${\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.
where n, y and x .

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

File:Calci1.gif

---

AVEDEV (N1, N2...) Where N1, N 2 ...   are positive integers.

---

?UNIQee1806e3b9c8b1d6-nowiki-00000002-QINU?

---