Manuals/calci/LINEST - Revision history

Devika at 22:13, 10 August 2018

2018-08-10T22:13:28Z

Devika at 22:15, 14 June 2018

2018-06-14T22:15:17Z

Devika at 22:12, 14 June 2018

2018-06-14T22:12:26Z

Devika at 22:05, 14 June 2018

2018-06-14T22:05:26Z

Jayaram at 07:30, 13 March 2017

2017-03-13T07:30:31Z

Swapna: /* Examples */

2015-05-10T16:20:50Z

Examples

Swapna: /* Examples */

2015-05-10T16:18:32Z

Examples

Swapna at 16:16, 10 May 2015

2015-05-10T16:16:01Z

Swapna at 22:08, 30 January 2014

2014-01-30T22:08:29Z

Swapna at 22:06, 30 January 2014

2014-01-30T22:06:21Z

@@ Line 1: / Line 1: @@
-=LINEST (YRange,XRanges,Constant,Stats) =
+<div style="font-size:30px">'''LINEST (YRange,XRanges,Constant,Stats)'''</div><br/>
 where,
 *<math>YRange</math> is a set of Y  values,
@@ Line 6: / Line 5: @@
 *<math>Constant</math> is a logical value TRUE or FALSE, that decides whether to force the constant 'b' to 0,
 *<math>Stats</math> is a logical value TRUE or FALSE, that decides whether to return additional regression statistics.
+**LINEST(), returns the parameters of a linear trend.
 == Description ==

@@ Line 7: / Line 7: @@
 *<math>Stats</math> is a logical value TRUE or FALSE, that decides whether to return additional regression statistics.
-LINEST() is an array function that calculates the statistics for a line by using the 'least squares' method to calculate a straight line that closely fits the input data.
+LINEST() returns the parameters of a linear trend.
 == Description ==
 *If 'Y' is the point on y-axis, 'X' is the point on x-axis, 'm' is a constant indicating slope of the line and 'b' is the constant value at which the line crosses y-axis (Y intercept),

← Older revision		Revision as of 22:12, 14 June 2018
Line 1:		Line 1:
−	=~~LINEST(Y, X, C , stats)~~LINEST (YRange,XRanges,Constant,Stats) =	+	=LINEST (YRange,XRanges,Constant,Stats) =

	where,		where,

@@ Line 1: / Line 1: @@
-=LINEST(Y, X, C , stats)=
+=LINEST(Y, X, C , stats)LINEST (YRange,XRanges,Constant,Stats) =
 where,
-*<math>Y</math> is a set of Y  values,
+*<math>YRange</math> is a set of Y  values,
-*<math>X</math> is an optional set of X  values,
+*<math>XRanges</math> is an optional set of X  values,
-*<math>C</math> is a logical value TRUE or FALSE, that decides whether to force the constant 'b' to 0,
+*<math>Constant</math> is a logical value TRUE or FALSE, that decides whether to force the constant 'b' to 0,
-*<math>stats</math> is a logical value TRUE or FALSE, that decides whether to return additional regression statistics.
+*<math>Stats</math> is a logical value TRUE or FALSE, that decides whether to return additional regression statistics.
 LINEST() is an array function that calculates the statistics for a line by using the 'least squares' method to calculate a straight line that closely fits the input data.
@@ Line 20: / Line 20: @@
   <math>Y = m1X1 + m2X2 +......+ b</math>
-*Argument values <math>X</math> and <math>Y</math> should be numeric, else Calci displays NaN error message.
+*Argument values <math>XRanges</math> and <math>YRange</math> should be numeric, else Calci displays NaN error message.
 *The length of array of X values should be equal to length of array of Y values, else Calci displays #NULL error message.
-*<math>C</math> is  a logical value that decides whether to make constant 'b' equal to 0.
+*<math>Constant</math> is  a logical value that decides whether to make constant 'b' equal to 0.
-*If <math>C</math> = TRUE or omitted, 'b' is calculated normally. If <math>C</math> = FALSE, 'b' is made equal to 0.
+*If <math>Constant</math> = TRUE or omitted, 'b' is calculated normally. If <math>Constant</math> = FALSE, 'b' is made equal to 0.
-*<math>stats</math> is a logical value that decides whether to display additional regression statistics.
+*<math>Stats</math> is a logical value that decides whether to display additional regression statistics.
-*If <math>stats</math> = TRUE, calci returns additional regresstion statistics. If <math>stats</math> = FALSE or omitted, Calci returns the values of 'm'(slope) and the constant 'b'.
+*If <math>Stats</math> = TRUE, calci returns additional regression statistics. If <math>,Stats</math> = FALSE or omitted, Calci returns the values of 'm'(slope) and the constant 'b'.
 *When there is only one independent X variable, Slope(m) and Y intercept (b) can be calculated using following formulas -

← Older revision		Revision as of 07:30, 13 March 2017
Line 130:		Line 130:
	== References ==		== References ==
	*[http://en.wikipedia.org/wiki/Linear_equation Linear Equation]		*[http://en.wikipedia.org/wiki/Linear_equation Linear Equation]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 94: / Line 94: @@
 |}
-  =LINEST(A2:A6,B2:B6,TRUE,FALSE) : Calculates the statistics of line with Y co-ordinates in cells <br /> A2 to A6 and X co-ordinates in cells B2 to B6.<br />Returns '''m=0''' and '''b=3''' as a result.
+  =LINEST(A2:A6,B2:B6,TRUE,FALSE) : Calculates the statistics of line with Y co-ordinates in cells <br /> A2 to A6 and X co-ordinates in cells B2 to B6. Returns '''m=0''' and '''b=3''' as a result.
-  =LINEST(A2:A6,B2:B6,FALSE,FALSE): Calculates the statistics of line with Y co-ordinates in cells <br /> A2 to A6 and X co-ordinates in cells range B2 to B6.<br />Returns '''m=0.4090909090909091''' and '''b=0''' as a result.
+  =LINEST(A2:A6,B2:B6,FALSE,FALSE): Calculates the statistics of line with Y co-ordinates in cells <br /> A2 to A6 and X co-ordinates in cells range B2 to B6. Returns '''m=0.4090909090909091''' and '''b=0''' as a result.
-  =LINEST(A2:A6,B2:B6,FALSE,TRUE) : Displays the additional regression statistics of line <br />with Y co-ordinates in cells A2 to A6 and <br />X co-ordinates in cells B2 to B6 as shown below -
+  =LINEST(A2:A6,B2:B6,FALSE,TRUE) : Displays the additional regression statistics of line <br />with Y co-ordinates in cells A2 to A6 and X co-ordinates in cells B2 to B6 as shown below:
 <div id="5SpaceContent" class="zcontent" align="left">

← Older revision		Revision as of 16:16, 10 May 2015
Line 120:		Line 120:
	\|}		\|}

		+	==Related Videos==
		+
		+	{{#ev:youtube\|6wbcPbYbq6M\|280\|center\|LINEST}}
		+
	== See Also ==		== See Also ==

← Older revision		Revision as of 22:06, 30 January 2014
Line 29:		Line 29:

	<math>Y intercept (b) = INDEX(LINEST(Y, X),2) </math>		<math>Y intercept (b) = INDEX(LINEST(Y, X),2) </math>
		+	*The additional regression is displayed in the following format where each statistic value is described as below-
		+
		+	{\| class="wikitable"
		+	\|-
		+	\| <math>m_n</math> \|\| <math>m_{n-1}</math> \|\| --- \|\| <math>m_1</math> \|\| <math>b</math>
		+	\|-
		+	\| <math>se_n</math> \|\| <math>se_{n-1}</math> \|\| --- \|\| <math>se_1</math> \|\| <math>se_b</math>
		+	\|-
		+	\| <math>r_2</math> \|\| <math>se_y</math> \|\| \|\| \|\|
		+	\|-
		+	\| <math>F</math> \|\| <math>d_f</math> \|\| \|\| \|\|
		+	\|-
		+	\| <math>ss_{reg}</math> \|\| <math>ss_{resld}</math> \|\| \|\| \|\|
		+	\|}
		+
		+	*<math>m_n</math> is an array of constant multipliers for straight line equation
		+	*<math>b</math> is the constant value of Y when X=0
		+	*<math>se_1</math> is the standard error value for m1
		+	*<math>se_b</math> is the standard error value for constant b
		+	*<math>r_2</math> is the coefficient of determination
		+	*<math>se_y</math> is the standard error value for Y estimate
		+	*<math>F</math> is the observed F value
		+	*<math>d_f</math> is the number of degrees of freedom
		+	*<math>ss_{reg}</math> is the regression sum of squares
		+	*<math>ss_{resld}</math> is the residual sum of squares

	== Examples ==		== Examples ==