Difference between revisions of "Manuals/calci/FORECAST"

From ZCubes Wiki
Jump to navigation Jump to search
 
(21 intermediate revisions by 4 users not shown)
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==
 
==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> , where <math>a=\bar{y}-b \bar{x} and b=summation(x-x(bar))(y-y(bar)/summation(x-x(bar))^2. Here x(bar) and y(bar) 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.
+
*<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.
−
2. The values of x and y are empty or contain a different number of data points.
+
*The formula for <math>FORECAST</math> is <math>a+bx</math>  
−
3. The variance of x is zero.
+
*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>.  
−
where n, y and x .
+
*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  
 +
  1. Any one of the value is non-numeric.
 +
  2. The values of <math>KnownXs</math> and <math>KnownYs</math> are empty or contain a different number of data points.
 +
  3. The variance of <math>x</math> is zero.
  
−
'''FORECAST'''('''x1''',''' ky1’s, kx1’s''')
+
==ZOS==
  
−
'''Where X1'''   is the data point, ky1 is the dependent array or range of data and ky2
+
*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])
  
−
is the independent array or range of data.
+
==Examples==
  
−
</div>
+
{| class="wikitable"
−
----
+
|+Spreadsheet
−
<div id="1SpaceContent" class="zcontent" align="left">
+
|-
−
 
+
! !! A !! B !! C !! D!! E !!F
−
It Predicts or calculates a future value by using existing values. The predicted value is a y1-value for a given x1-value.
+
|-
 +
! 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.
  
−
</div>
+
==Related Videos==
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left">
 
  
−
·          FORECAST displays an error, when x is nonnumeric.
+
{{#ev:youtube|ksCVXXh5_hk|280|center|FORECAST}}
  
−
·          when the variance of kx1’s equals zero FORECAST displays errror.
+
==See Also==
 +
*[[Manuals/calci/GROWTH| GROWTH]]
 +
*[[Manuals/calci/LINEST  | LINEST]]
 +
*[[Manuals/calci/LOGEST| LOGEST ]]
  
−
·          The equation for FORECAST is a+bx, where:
+
==References==
 +
*[https://support.microsoft.com/en-us/kb/828236 FORECAST ]
  
−
and:
 
−
 
−
and where x and y are the sample means AVERAGE(kx1's) and AVERAGE(ky1's).
 
−
 
−
</div>
 
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">FORECAST</div></div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class="  " |
 
−
<div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
| Column1
 
−
| class="  " | Column2
 
−
| class="  " | Column3
 
−
| class="  " | Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="  sshl_f " | 4
 
−
| class="sshl_f " | 25
 
−
| class="sshl_f" | 4.730174
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 5
 
−
| class="sshl_f" | 23
 
−
| class="sshl_f SelectTD SelectTD" |
 
−
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 8
 
−
| class="sshl_f" | 32
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 17
 
−
| class="sshl_f" | 36
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class=" " | 22
 
−
| class="sshl_f " | 40
 
−
| class="sshl_f" |
 
−
| 0
 
−
|- class="even"
 
−
| Row6
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
 
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ...   are positive integers.</font></font> '''</font></font></div>
 
−
----
 
−
<div id="5SpaceContent" class="zcontent" align="left">
 
  
−
<font size="3">UNIQee1806e3b9c8b1d6-nowiki-00000002-QINU</font>
+
*[[Z_API_Functions | List of Main Z Functions]]
  
−
</div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 16:07, 10 August 2018

FORECAST (x,KnownYs,KnownXs)


  • is the data point .
  • 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 , of the independent variable by using a least squares linear regression to predict values from values.
  • In , is the data point to predict a value.
  • is the dependent array of data to predict the -value and is the independent array of data to predict the -value.
  • The formula for is
  • where and .
  • Here and are the sample means of and .
  • This function will give the result as error when
 1. Any one of the value is non-numeric.
 2. The values of  and  are empty or contain a different number of data points.
 3. The variance of  is zero.

ZOS

  • The syntax is to calculate this function in ZOS is
    • 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
  1. =FORECAST(26,A1:A6,B1:B6) = 13.16666667
  2. =FORECAST(18,C1:C4,D1:D4) = 2.119541779
  3. =FORECAST(24,E1:E4,F1:F4) = 31.71054889
  4. =FORECAST(10,C5:F5,C6:E6) = NAN.

Related Videos

FORECAST

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/FORECAST&oldid=211029"