writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + − '''TREND''' ('''Y''',X,N,C)+ + + + + + + + + + + + − Where Y is the set of y- valuesIn the relationship y = mx + b+ + + + + + + + + + + + + + + − X is an optional set of x-values in the relationship y = mx + b+ + + + − N are the new x-values and C is a logical value specifying whether to force the constant b to equal 0.+ − − </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> − ----
no edit summary
<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.
==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.
==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==
*[[Manuals/calci/GROWTH | GROWTH ]]
*[[Manuals/calci/LINEST | LINEST ]]
*[[Manuals/calci/LOGEST | LOGEST ]]
==References==