Manuals/calci/TREND

TREND(KnownYs,KnownXs,NewXs,ForceConst)

$KnownYs$ is the set of y values.
$KnownXs$ is the set of x values.
$NewXs$ is the new x value.
is the constant value.
- TREND() returns values along a linear trend.

Description

This function calculating the trend line using the given set of $KnownYs$ and $KnownXs$ values.
Trend line is the straight line which joins two or more points in the upward direction.
It is calculating using the equation $y=mx+b$ ,which is the simple equation for the straight line.
In this equation $x$ is the independent variable, $y$ is the dependent variable, $m$ is the slope of the line and $b$ is the constant which is equal to $y$ when $x=0$ .
In $TREND(KnownYs,KnownXs,NewXs,ForceConst)$ , $KnownYs$ is the set of y-values to find the linear trend, $KnownXs$ is the set of x- values to find the linear trend, $NewXs$ is the set of new x-values for which the function calculates corresponding new y-values and $ForceConst$ is the constant.
It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
If $ForceConst$ value is FALSE, then in the equation $c=0$ , and $y=mx$ .
Here $KnownYs$ is required. $KnownXs$ , $NewXs$ and $ForceConst$ are optional.
If $KnownXs$ value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of $KnownYs$ . If $NewXs$ value is omitted, then it is assumed to be the same size of $KnownXs$ .
If both $KnownXs$ and $NewXs$ are omitted, then they are assumed to be the array {1,2,3..} which is the same size of KnownYs.
$TREND$ 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.