Manuals/calci/TREND

Revision as of 21:46, 24 October 2013 by MassBot1 (talk | contribs) (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 ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.


This function returns the values along a linear trend.


·          Use TREND for a polynomial curve fitting by regressing against the same variable raised to different powers.


TREND


Syntax

Remarks

Examples

Description

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

=TREND(C2:C9,B2:B9,B10:B12) is 993.3835, 1060.6015 and 1127.8195 


Column1 Column2 Column3
Row1 10 400 993.3834586466165,1060.6015037593983,1127.8195488721803
Row2 12 560
Row3 13 550
Row4 14 590
Row5 15 750
Row6 16 820
Row7 17 880
Row8 18 910
Row9 19
Row10 20
Row11 21
Row12