Difference between revisions of "Manuals/calci/TREND"

From ZCubes Wiki
Jump to navigation Jump to search
 
(7 intermediate revisions by 4 users not shown)
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==
 
==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>.  
−
*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.  
 
*<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.
Line 38: Line 40:
 
|-
 
|-
 
! 5
 
! 5
−
| 5 || 54 || 14
+
| 5 || 54 || 14  
 +
|-
 
! 6
 
! 6
 
| 6 || 49 ||   
 
| 6 || 49 ||   
Line 51: Line 54:
 
| 9 || 60 ||   
 
| 9 || 60 ||   
 
|}
 
|}
−
DAYS(x)       SALES(y)        x1
+
        
−
1                40          10
+
#=TREND(B1:B9,A1:A9,C1:C5)
−
2                35          11
+
62.611111111111114,etc
−
3                42          12
+
#=TREND(B1:B9,A1:A9,C1:C5,FALSE)
−
4                50          13
+
  82.84210546,etc
−
5                54          14
+
 
−
6                49         
+
==Related Videos==
−
7                  51   
+
 
−
8                  58
+
{{#ev:youtube|-IaRduS9S2Y|280|center|TREND}}
−
9                  60       
 
−
TREND(B1:B9,A1:A9,C1:C5) =
 
−
62.611111111111114,etc
 
−
TREND(B1:B9,A1:A9,C1:C5,FALSE) =
 
−
= 82.84210546,etc
 
  
 
==See Also==
 
==See Also==
Line 72: Line 70:
  
 
==References==
 
==References==
 +
*[http://en.wikipedia.org/wiki/Trend_estimation Trend Estimation]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 15:06, 18 June 2018

TREND(KnownYs,KnownXs,NewXs,ForceConst)


  • is the set of y values.
  • is the set of x values.
  • 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 and values.
  • Trend line is the straight line which joins two or more points in the upward direction.
  • It is calculating using the equation ,which is the simple equation for the straight line.
  • In this equation is the independent variable, is the dependent variable, is the slope of the line and is the constant which is equal to when .
  • In , is the set of y-values to find the linear trend, is the set of x- values to find the linear trend, is the set of new x-values for which the function calculates corresponding new y-values and is the constant.
  • It is either TRUE or FALSE. If ForceConst value is TRUE or omitted, then it is calculated normally.
  • If value is FALSE, then in the equation , and .
  • Here is required. , and are optional.
  • If value is omitted, then it is assumed to be the array{1,2,3..} which is the same size of . If value is omitted, then it is assumed to be the same size of .
  • If both and are omitted, then they are assumed to be the array {1,2,3..} which is the same size of KnownYs.
  • 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 , 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

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/TREND&oldid=210349"