Manuals/calci/TREND

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