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.

Examples

1. y={5,9,11,18,32,4}

x={30,32,15,28,41,10} FORECAST(26,B1:B6,C1:C6)=13.16666667

1. y={-28,-18,35,12}

x={-42,34,-13,25} FORECAST(18,C5:C8,D5:D8)=2.119541779

1. y={51,14,0,60}

x={46,-1,29,18} FORECAST(24,D1:D4,E1:E4)=31.71054889

1. y={2,5,9,17}

x={4,14,28} FORECAST(10,B1:B4,C1:C3)=NAN.

See Also

• GROWTH
• LINEST
• LOGEST