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/>
-*<math>y</math> is the set of y values.
+*<math>KnownYs</math> is the set of y values.
-*<math>x</math> is the set of x values.
+*<math>KnownXs</math> is the set of x values.
-*<math>x_1</math> is the new x value.
+*<math>NewXs</math> is the new x value.
-*<math>c</math> is the constant value.
+*<math>ForceConst</math> is the constant value.
+**TREND() returns values along a linear trend.
 ==Description==
-*This function calculating the trend line using the given set of <math> y </math> and <math> x </math> values.
+*This function calculating the trend line using the given set of <math> KnownYs </math> and <math> KnownXs </math> values.
 *Trend line is the straight line which joins two or more points in the upward direction.
 *It is calculating using the equation <math> y=mx+b</math>,which is the simple equation for the straight line.
 *In this equation <math> x </math> is the independent variable, <math>y</math> is the dependent variable, <math>m</math> is the slope of the line and <math>b</math> is the constant which is equal to <math>y</math> when <math>x=0</math>.
-*In <math>TREND(y,x,x_1,c)</math>, <math>y</math> is the set of y-values to find the linear trend, <math>x</math> is the set of x- values to find the linear trend, <math>x_1</math> is the set of new x-values  for which the function calculates corresponding new y-values and <math>c</math> is the constant.
+*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 c value is TRUE or omitted, then it is calculated normally.
+*It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
-*If <math>c</math> value is FALSE, then <math>c=0</math>, and <math>y=mx</math>. Here <math>y</math> is required. <math>x</math>,<math>x_1</math> and <math>c</math> are optional.
+*If <math>ForceConst</math> value is FALSE, then in the equation <math>c=0</math>, and <math>y=mx</math>.
-*If <math>x</math> value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of <math>y</math>. If  <math>x_1<math> value is omitted, then it is assumed to be the same size of <math>x</math>.
+*Here <math>KnownYs</math> is required. <math>KnownXs</math>,<math>NewXs</math> and <math>ForceConst</math> are optional.
-*If both <math>x<math> and <math>x_1<math> are omitted, then they are assumed to be the array {1,2,3..} which is the same size of y.
+*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.
 *<math>TREND</math> 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.
+*When entering an array constant for an argument such as <math>x</math>, use commas to separate values in the same row and semicolons to separate rows.
 ==Examples==
-DAYS(x)       SALES(y)        x1
-               40           10
+{| class="wikitable"
-                35           11
+|+Spreadsheet
-                42           12
+|-
-                50           13
+! !! DAYS(x) !! SALES(y) !! x1
-                54           14
+|-
-                49
+! 1
-                 51
+| 1 || 40 || 10
-                 58
+|-
-                 60
+! 2
-TREND(B1:B9,A1:A9,C1:C5) =
+| 2 || 35 || 11
-.611111111111114,etc
+|-
-TREND(B1:B9,A1:A9,C1:C5,FALSE) =
+! 3
-=  82.84210546,etc
+| 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)
+.611111111111114,etc
+#=TREND(B1:B9,A1:A9,C1:C5,FALSE)
+.84210546,etc
+==Related Videos==
+{{#ev:youtube|-IaRduS9S2Y|280|center|TREND}}
 ==See Also==
@@ Line 40: / Line 70: @@
 ==References==
+*[http://en.wikipedia.org/wiki/Trend_estimation Trend Estimation]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

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