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 ...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''TREND(y,x,x1,c)'''</div><br/>
 +
*<math>y</math> is the set of y values.
 +
*<math>x</math> is the set of x values.
 +
*<math>x_1</math> is the new x value.
 +
*<math>c</math> is the constant value.
  
'''TREND''' ('''Y''',X,N,C)
+
==Description==
 +
*This function calculating the trend line using the given set of <math> y </math> and <math> x </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(y,x,x_1,c)</math>, <math>y</math> is the set of y-values to find the linear trend, <math>x</math> is the set of x- values to find the linear trend, <math>x_1</math> is the set of new x-values  for which the function calculates corresponding new y-values and <math>c</math> is the constant.
 +
*It is either TRUE or FALSE. If c value is TRUE or omitted, then it is calculated normally.
 +
*If <math>c</math> value is FALSE, then <math>c=0</math>, and <math>y=mx</math>. Here <math>y</math> is required. <math>x</math>,<math>x_1</math> and <math>c</math> are optional. 
 +
*If <math>x</math> value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of <math>y</math>. If  <math>x_1<math> value is omitted, then it is assumed to be the same size of <math>x</math>.
 +
*If both <math>x<math> and <math>x_1<math> are omitted, then they are assumed to be the array {1,2,3..} which is the same size of y. 
 +
*<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 x, 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==
 +
DAYS(x)      SALES(y)        x1
 +
1                40          10
 +
2                35          11
 +
3                42          12
 +
4                50          13
 +
5                54          14
 +
6                49         
 +
7                  51   
 +
8                  58
 +
9                  60       
 +
TREND(B1:B9,A1:A9,C1:C5) =
 +
62.611111111111114,etc
 +
TREND(B1:B9,A1:A9,C1:C5,FALSE) =
 +
= 82.84210546,etc
  
X is an optional set of x-values in the relationship y = mx + b
+
==See Also==
 +
*[[Manuals/calci/GROWTH  | GROWTH ]]
 +
*[[Manuals/calci/LINEST  | LINEST ]]
 +
*[[Manuals/calci/LOGEST  | LOGEST ]]
  
N are the new x-values  and C is a logical value specifying whether to force the constant b to equal 0.
+
==References==
 
 
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left">
 
 
 
This function returns the values along a linear trend.
 
 
 
</div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left">
 
 
 
·          <font face="Arial">Use</font> TREND for a polynomial curve fitting by regressing against the same variable raised to different powers.
 
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
 
TREND
 
 
 
</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="5SpaceContent" class="zcontent" align="left">
 
 
 
Lets see an example,
 
 
 
TREND(Y,X,N,C)
 
 
 
'''B                 C'''
 
 
 
10               400
 
 
 
12               560
 
 
 
13               550
 
 
 
14               590
 
 
 
15               750
 
 
 
16               820
 
 
 
17               880
 
 
 
18               910
 
 
 
19
 
 
 
20
 
 
 
21
 
 
 
<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>
 
----
 

Revision as of 02:48, 10 February 2014

TREND(y,x,x1,c)


  • is the set of y values.
  • is the set of x values.
  • is the new x value.
  • is the constant value.

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 c value is TRUE or omitted, then it is calculated normally.
  • If value is FALSE, then , 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 .
  • If both 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 x, use commas to separate values in the same row and semicolons to separate rows.

Examples

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

See Also

References