Difference between revisions of "Manuals/calci/FORECAST"

Latest revision as of 16:07, 10 August 2018

FORECAST (x,KnownYs,KnownXs)

$x$ is the data point .
$KnownYs$ is the dependent array of data.
is the independent array of data.
- FORECAST(), returns a value along a linear trend.

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(x,KnownYs,KnownXs)$ , $x$ is the data point to predict a value.
$KnownYs$ is the dependent array of data to predict the $y$ -value and $KnownXs$ 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 non-numeric.
 2. The values of  $KnownXs$  and  $KnownYs$  are empty or contain a different number of data points.
 3. The variance of  $x$  is zero.

ZOS

The syntax is to calculate this function in ZOS is
- $x$ 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

Spreadsheet
	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.

References

FORECAST

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''FORECAST(n,y,x)'''</div><br/>
+<div style="font-size:30px">'''FORECAST (x,KnownYs,KnownXs) '''</div><br/>
-*<math>n</math>  is the data point .
+*<math>x</math>  is the data point .
-*<math>y</math>  is the dependent array of data.
+*<math>KnownYs</math>  is the dependent array of data.
-*<math>x</math>  is the independent array of data.
+*<math>KnownXs</math>  is the independent array of data.
+**FORECAST(), returns a value along a linear trend.
 ==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.
+*This function gives  the predicted value of the dependent variable  for the specific value <math>x</math>, of the independent variable  by using a least squares  linear regression to predict <math>y</math> values from <math>x</math> values.
-*In <math>FORECAST(n,y,x), n</math> is the data point to predict a value. <math>y</math> is the dependent array of data to predict the <math>y</math>-value and <math>x</math> is the independent array of data to predict the <math>y</math>-value.
+*In <math>FORECAST (x,KnownYs,KnownXs)</math>, <math>x</math> is the data point to predict a value.
-*The formula for <math>FORECAST</math> is <math> a+bx</math>
+*<math>KnownYs</math> is the dependent array of data to predict the <math>y</math>-value and <math>KnownXs</math> is the independent array of data to predict the <math>y</math>-value.
+*The formula for <math>FORECAST</math> is <math>a+bx</math>
 *where <math>a=\bar{y}-b \bar{x}</math>  and  <math> b=\frac{\sum (x-\bar{x})(y-\bar{y})}{\sum(x-\bar{x})^2}</math>.
-*Here <math>\bar{x}</math> and <math>\bar{y}</math> are the sample means of x and y.
+*Here <math>\bar{x}</math> and <math>\bar{y}</math> are the sample means of <math>x</math> and <math>y</math>.
 *This function will give the result as error when
-. Any one of the value is nonnumeric.
+. Any one of the value is non-numeric.
-. The values of x and y are empty or contain a different number of data points.
+. The values of <math>KnownXs</math> and <math>KnownYs</math> are empty or contain a different number of data points.
-. The variance of x is zero.
+. The variance of <math>x</math> is zero.
+==ZOS==
+*The syntax is to calculate this function in ZOS is <math>FORECAST (x, KnownYs, KnownXs)</math>
+**<math>x</math> 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==
-#y={5,9,11,18,32,4}
-x={
-FORECAST(26,B1:B6,C1:C6)=13.16666667
-#y={}
-x={-42,34,-13,25}
-FORECAST(18,C5:C8,D5:D8)=2.119541779
-#y={51,14,0,60}
-x={46,-1,29,18}
-FORECAST(24,D1:D4,E1:E4)=31.71054889
-#y={2,5,9,17}
-x={4,14,28}
-FORECAST(10,B1:B4,C1:C3)=NAN.
 {| class="wikitable"
 |+Spreadsheet
 |-
-! !! A !! B !! C !! D!! E
+! !! A !! B !! C !! D!! E !!F
 |-
 ! 1
-| 5 || 30 || -28 ||-42 ||46
+| 5 || 30 || -28 ||-42 ||51 ||46
 |-
 ! 2
-| 9 || 32 ||-18 || 34 || -1
+| 9 || 32 ||-18 || 34 || 14 || -1
 |-
 ! 3
-| 11  || 15  ||35 ||-13|| 29
+| 11  || 15  ||35 ||-13|| 0 ||29
 |-
 ! 4
-| 18 ||28  ||12  ||25 ||18
+| 18 ||28  ||12  ||25 ||60 ||18
 |-
 ! 5
-| 32 || 41 ||  || ||
+| 32 || 41 || 2 || 5|| 9 ||17
 |-
 ! 6
-| 4  || 10
+| 4  || 10 || 4 ||  14 || 28
 |}
-=FORECAST(25,A1:B2,C1:D2) = 16.41772152
+# =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.
+==Related Videos==
+{{#ev:youtube|ksCVXXh5_hk|280|center|FORECAST}}
 ==See Also==
@@ Line 59: / Line 62: @@
 *[[Manuals/calci/LINEST  | LINEST]]
 *[[Manuals/calci/LOGEST| LOGEST ]]
+==References==
+*[https://support.microsoft.com/en-us/kb/828236 FORECAST ]
-==References==
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/FORECAST"

Latest revision as of 16:07, 10 August 2018

Contents

Description

ZOS

Examples

Related Videos

See Also

References

Navigation menu

Search

	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

	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

	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