Changes

3,402 bytes added , 02:46, 25 October 2013

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 ..."

<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 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>
----

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/TREND (view source)

Revision as of 02:46, 25 October 2013