Difference between revisions of "Manuals/calci/FORECAST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 15: Line 15:
 
   2. The values of x and y are empty or contain a different number of data points.
 
   2. The values of x and y are empty or contain a different number of data points.
 
   3. The variance of x is zero.
 
   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.
 
 
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left">
 
 
It Predicts or calculates a future value by using existing values. The predicted value is a y1-value for a given x1-value.
 
 
</div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
 
·          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).
 
 
</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>
 
 
</div>
 
----
 

Revision as of 05:27, 14 January 2014

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.