Manuals/calci/TREND
Jump to navigation
Jump to search
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 |