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.
• $ForceConst$ 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.

Examples

Spreadsheet

	DAYS(x)	SALES(y)	x1
1	1	40	10
2	2	35	11
3	3	42	12
4	4	50	13
5	5	54	14
6	6	49
7	7	51
8	8	58
9	9	60

1. =TREND(B1:B9,A1:A9,C1:C5)

62.611111111111114,etc

1. =TREND(B1:B9,A1:A9,C1:C5,FALSE)

82.84210546,etc

Related Videos

TREND

See Also

• GROWTH
• LINEST
• LOGEST

References

• Trend Estimation

• List of Main Z Functions

• Z3 home