Difference between revisions of "Manuals/calci/TREND"

Latest revision as of 14:06, 18 June 2018

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.

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

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

62.611111111111114,etc

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

82.84210546,etc

References

Trend Estimation

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''TREND(y,x,x1,c)'''</div><br/>
+<div style="font-size:30px">'''TREND(KnownYs,KnownXs,NewXs,ForceConst)'''</div><br/>
-(KnownYs,KnownXs,NewXs,ForceConst)
 *<math>KnownYs</math> is the set of y values.
 *<math>KnownXs</math> is the set of x values.
@@ Line 14: / Line 13: @@
 *In <math>TREND(KnownYs,KnownXs,NewXs,ForceConst)</math>, <math>KnownYs</math> is the set of y-values to find the linear trend, <math>KnownXs</math> is the set of x- values to find the linear trend, <math>NewXs</math> is the set of new x-values  for which the function calculates corresponding new y-values and <math>ForceConst</math> is the constant.
 *It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
-*If <math>ForceConst</math> value is FALSE, then in the equation <math>c=0</math>, and <math>y=mx</math>. Here <math>KnownYs</math> is required. <math>KnownXs</math>,<math>NewXs</math> and <math>ForceConst</math> are optional.
+*If <math>ForceConst</math> value is FALSE, then in the equation <math>c=0</math>, and <math>y=mx</math>.
+*Here <math>KnownYs</math> is required. <math>KnownXs</math>,<math>NewXs</math> and <math>ForceConst</math> are optional.
 *If <math>KnownXs</math> value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of <math>KnownYs</math>. If  <math>NewXs</math> value is omitted, then it is assumed to be the same size of <math>KnownXs</math>.
 *If both <math>KnownXs</math> and <math>NewXs</math> are omitted, then they are assumed to be the array {1,2,3..} which is the same size of KnownYs.

Difference between revisions of "Manuals/calci/TREND"

Latest revision as of 14:06, 18 June 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search