Difference between revisions of "Manuals/calci/TREND"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''TREND''' ('''Y''',X,N,C) Where Y is the set of y- valuesIn the relationship y = mx + b X is an optional set ...")
 
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''TREND(KnownYs,KnownXs,NewXs,ForceConst)'''</div><br/>
 +
*<math>KnownYs</math> is the set of y values.
 +
*<math>KnownXs</math> is the set of x values.
 +
*<math>NewXs</math> is the new x value.
 +
*<math>ForceConst</math> is the constant value.
 +
**TREND() returns values along a linear trend.
  
−
'''TREND''' ('''Y''',X,N,C)
+
==Description==
 +
*This function calculating the trend line using the given set of <math> KnownYs </math> and <math> KnownXs </math> values.
 +
*Trend line is the straight line which joins two or more points in the upward direction.
 +
*It is calculating using the equation <math> y=mx+b</math>,which is the simple equation for the straight line.
 +
*In this equation <math> x </math> is the independent variable, <math>y</math> is the dependent variable, <math>m</math> is the slope of the line and <math>b</math> is the constant which is equal to <math>y</math> when <math>x=0</math>.
 +
*In <math>TREND(KnownYs,KnownXs,NewXs,ForceConst)</math>, <math>KnownYs</math> is the set of y-values to find the linear trend, <math>KnownXs</math> is the set of x- values to find the linear trend, <math>NewXs</math> is the set of new x-values  for which the function calculates corresponding new y-values and <math>ForceConst</math> is the constant.
 +
*It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
 +
*If <math>ForceConst</math> value is FALSE, then in the equation <math>c=0</math>, and <math>y=mx</math>.
 +
*Here <math>KnownYs</math> is required. <math>KnownXs</math>,<math>NewXs</math> and <math>ForceConst</math> are optional. 
 +
*If <math>KnownXs</math> value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of <math>KnownYs</math>. If  <math>NewXs</math> value is omitted, then it is assumed to be the same size of <math>KnownXs</math>.
 +
*If both <math>KnownXs</math> and <math>NewXs</math> are omitted, then they are assumed to be the array {1,2,3..} which is the same size of KnownYs. 
 +
*<math>TREND</math> function is used for polynomial curve fitting by regressing against the same variable raised to different powers.
 +
*When entering an array constant for an argument such as <math>x</math>, use commas to separate values in the same row and semicolons to separate rows.
  
−
Where Y is the set of y- valuesIn the relationship y = mx + b
+
==Examples==
  
−
X is an optional set of x-values in the relationship y = mx + b
+
{| class="wikitable"
−
 
+
|+Spreadsheet
−
N are the new x-values  and C is a logical value specifying whether to force the constant b to equal 0.
+
|-
−
 
+
! !! DAYS(x) !! SALES(y) !! x1
−
</div>
+
|-
−
----
+
! 1
−
<div id="1SpaceContent" class="zcontent" align="left">
+
| 1 || 40 || 10
−
 
+
|-
−
This function returns the values along a linear trend.
+
! 2
−
 
+
| 2 || 35 || 11
−
</div>
+
|-
−
----
+
! 3
−
<div id="7SpaceContent" class="zcontent" align="left">
+
| 3  || 42  || 12
−
 
+
|-
−
·          <font face="Arial">Use</font> TREND for a polynomial curve fitting by regressing against the same variable raised to different powers.
+
! 4
−
 
+
| 4 ||50  || 13
−
</div>
+
|-
−
----
+
! 5
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
| 5 || 54 || 14
−
 
+
|-  
−
TREND
+
! 6
−
 
+
| 6 || 49 || 
−
</div></div>
+
|-
−
----
+
! 7
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
+
| 7  || 51  || 
−
----
+
|-
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
+
! 8
−
----
+
| 8 || 58  || 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
+
|-
−
----
+
! 9
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
+
| 9 || 60 || 
−
----
+
|}
−
<div id="5SpaceContent" class="zcontent" align="left">
+
     
−
 
+
#=TREND(B1:B9,A1:A9,C1:C5)
−
Lets see an example,
+
62.611111111111114,etc
−
 
+
#=TREND(B1:B9,A1:A9,C1:C5,FALSE)
−
TREND(Y,X,N,C)
+
82.84210546,etc
−
 
 
−
'''B                 C'''
 
−
 
 
−
10               400
 
−
 
 
−
12               560
 
−
 
 
−
13               550
 
−
 
 
−
14               590
 
  
−
15               750
+
==Related Videos==
  
−
16               820
+
{{#ev:youtube|-IaRduS9S2Y|280|center|TREND}}
  
−
17               880
+
==See Also==
 +
*[[Manuals/calci/GROWTH  | GROWTH ]]
 +
*[[Manuals/calci/LINEST  | LINEST ]]
 +
*[[Manuals/calci/LOGEST  | LOGEST ]]
  
−
18               910
+
==References==
 +
*[http://en.wikipedia.org/wiki/Trend_estimation Trend Estimation]
  
−
19
 
  
−
20
 
  
−
21
+
*[[Z_API_Functions | List of Main Z Functions]]
−
 
 
−
<nowiki>=TREND(C2:C9,B2:B9,B10:B12) is 993.3835, 1060.6015 and 1127.8195 </nowiki>
 
−
 
 
−
</div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
−
 
 
−
{| id="TABLE3" class="SpreadSheet blue"
 
−
|- class="even"
 
−
| class=" " |
 
−
| class="  " | Column1
 
−
| class="  " | Column2
 
−
| class="  " | Column3
 
−
| class="                                                          " |
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class="sshl_f " | 10
 
−
| class="sshl_f " | 400
 
−
| class="sshl_f" | 993.3834586466165,1060.6015037593983,1127.8195488721803
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="sshl_f" | 12
 
−
| class="sshl_f" | 560
 
−
| class="sshl_f" |
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class="sshl_f" | 13
 
−
| class="sshl_f" | 550
 
−
| class="SelectTD" |
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class="sshl_f" | 14
 
−
| class="sshl_f" | 590
 
−
| class="sshl_f  " |
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | 15
 
−
| class="sshl_f" | 750
 
−
| class="sshl_f  " |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row6
 
−
| class="sshl_f" | 16
 
−
| class="sshl_f" | 820
 
−
| class="    " |
 
−
|
 
−
|- class="odd"
 
−
| class="sshl_f" | Row7
 
−
| class="sshl_f" | 17
 
−
| class="sshl_f" | 880
 
−
| class=" " |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row8
 
−
| class=" " | 18
 
−
| class=" " | 910
 
−
| class=" " |
 
−
|
 
−
|- class="odd"
 
−
| class="sshl_f" | Row9
 
−
| class="sshl_f " | 19
 
−
|
 
−
| class=" " |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row10
 
−
| class="sshl_f" | 20
 
−
| class="sshl_f" |
 
−
| class=" " |
 
−
|
 
−
|- class="odd"
 
−
| class="sshl_f" | Row11
 
−
| class="sshl_f " | 21
 
−
| class="sshl_f" |
 
−
| class=" " |
 
−
|
 
−
|- class="even"
 
−
| class="sshl_f" | Row12
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
| class="sshl_f" |
 
−
|
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 15:06, 18 June 2018

TREND(KnownYs,KnownXs,NewXs,ForceConst)


  • is the set of y values.
  • is the set of x values.
  • is the new x value.
  • is the constant value.
    • TREND() returns values along a linear trend.

Description

  • This function calculating the trend line using the given set of and values.
  • Trend line is the straight line which joins two or more points in the upward direction.
  • It is calculating using the equation ,which is the simple equation for the straight line.
  • In this equation is the independent variable, is the dependent variable, is the slope of the line and is the constant which is equal to when .
  • In , is the set of y-values to find the linear trend, is the set of x- values to find the linear trend, is the set of new x-values for which the function calculates corresponding new y-values and is the constant.
  • It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
  • If value is FALSE, then in the equation , and .
  • Here is required. , and are optional.
  • If value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of . If value is omitted, then it is assumed to be the same size of .
  • If both and are omitted, then they are assumed to be the array {1,2,3..} which is the same size of KnownYs.
  • function is used for polynomial curve fitting by regressing against the same variable raised to different powers.
  • When entering an array constant for an argument such as , use commas to separate values in the same row and semicolons to separate rows.

Examples

Spreadsheet
DAYS(x) SALES(y) x1
1 1 40 10
2 2 35 11
3 3 42 12
4 4 50 13
5 5 54 14
6 6 49
7 7 51
8 8 58
9 9 60
  1. =TREND(B1:B9,A1:A9,C1:C5)
62.611111111111114,etc
  1. =TREND(B1:B9,A1:A9,C1:C5,FALSE)
82.84210546,etc

Related Videos

TREND

See Also

References


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