writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + + + − + − + − + − + − + − +
no edit summary
<div style="font-size:30px">'''TREND(y,x,x1,c)'''</div><br/>
<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==
==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.
*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.
*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 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.
*<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.
*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.