Difference between revisions of "Manuals/calci/TREND"

Revision as of 14:05, 18 June 2018

TREND(y,x,x1,c)

(KnownYs,KnownXs,NewXs,ForceConst)

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownYs} is the set of y values.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownXs} is the set of x values.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewXs} is the new x value.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ForceConst} is the constant value.
- TREND() returns values along a linear trend.

Description

This function calculating the trend line using the given set of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownYs } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownXs } values.
Trend line is the straight line which joins two or more points in the upward direction.
It is calculating using the equation Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y=mx+b} ,which is the simple equation for the straight line.
In this equation Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } is the independent variable, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} is the dependent variable, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} is the slope of the line and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b} is the constant which is equal to Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y} when Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x=0} .
In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle TREND(KnownYs,KnownXs,NewXs,ForceConst)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownYs} is the set of y-values to find the linear trend, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownXs} is the set of x- values to find the linear trend, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewXs} is the set of new x-values for which the function calculates corresponding new y-values and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ForceConst} is the constant.
It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ForceConst} value is FALSE, then in the equation Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle c=0} , and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y=mx} . Here Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownYs} is required. $KnownXs$ ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewXs} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle ForceConst} are optional.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownXs} value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownYs} . If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewXs} value is omitted, then it is assumed to be the same size of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownXs} .
If both Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle KnownXs} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewXs} are omitted, then they are assumed to be the array {1,2,3..} which is the same size of KnownYs.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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/>
-*<math>y</math> is the set of y values.
+(KnownYs,KnownXs,NewXs,ForceConst)
-*<math>x</math> is the set of x values.
+*<math>KnownYs</math> is the set of y values.
-*<math>x_1</math> is the new x value.
+*<math>KnownXs</math> is the set of x values.
-*<math>c</math> is the constant value.
+*<math>NewXs</math> is the new x 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>. Here <math>KnownYs</math> is required. <math>KnownXs</math>,<math>NewXs</math> and <math>ForceConst</math> are optional.
-*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>.
+*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>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 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 <math>x</math>, use commas to separate values in the same row and semicolons to separate rows.

Difference between revisions of "Manuals/calci/TREND"

Revision as of 14:05, 18 June 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search