Manuals/calci/STEYX - Revision history

Devika: /* Description */

2018-06-18T19:58:46Z

Description

Devika: /* Description */

2018-06-18T19:58:08Z

Description

Devika at 19:57, 18 June 2018

2018-06-18T19:57:32Z

Devika at 19:54, 18 June 2018

2018-06-18T19:54:04Z

Jayaram at 07:35, 13 March 2017

2017-03-13T07:35:36Z

Devika at 05:44, 7 October 2015

2015-10-07T05:44:49Z

Swapna at 20:06, 26 June 2015

2015-06-26T20:06:52Z

Devika: /* References */

2015-05-11T18:22:54Z

References

Abin: /* Examples */

2014-01-30T10:55:51Z

Examples

Abin: /* Examples */

2014-01-30T10:55:14Z

Examples

@@ Line 9: / Line 9: @@
 *The standard error for this line provides a measure of the error in the prediction of <math> KnownYs </math> for an individual <math> KnownXs </math>.
 *The equation for the standard error of the predicted <math> y </math> is:
-<math>\sqrt{\frac{1}{(n-2)}\left [ {\sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
+<math>\sqrt{\frac{1}{(n-2)}\left [ \sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
 where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>.
 *In <math>STEYX (KnownYs,KnownXs)</math>, <math>KnownYs </math> is the array of the numeric dependent values and <math> KnownXs </math> is the array of the independent values.

@@ Line 9: / Line 9: @@
 *The standard error for this line provides a measure of the error in the prediction of <math> KnownYs </math> for an individual <math> KnownXs </math>.
 *The equation for the standard error of the predicted <math> y </math> is:
-<math>\sqrt{\frac{1}{(n-2)}\left [ \sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
+<math>\sqrt{\frac{1}{(n-2)}\left [ {\sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
 where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>.
 *In <math>STEYX (KnownYs,KnownXs)</math>, <math>KnownYs </math> is the array of the numeric dependent values and <math> KnownXs </math> is the array of the independent values.

@@ Line 6: / Line 6: @@
 ==Description==
 *This function gives the standard error of the regression, which also is known as the standard error of the estimate.
-*It is calculates the  standard error for the straight line of best fit through a supplied set of <math> x </math> and <math> y </math> values.
+*It is calculates the  standard error for the straight line of best fit through a supplied set of <math> KnownXs</math> and <math> KnownYs</math> values.
-*The standard error for this line provides a measure of the error in the prediction of <math> y </math> for an individual <math> x </math>.
+*The standard error for this line provides a measure of the error in the prediction of <math> KnownYs </math> for an individual <math> KnownXs </math>.
 *The equation for the standard error of the predicted <math> y </math> is:
 <math>\sqrt{\frac{1}{(n-2)}\left [ \sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
@@ Line 16: / Line 16: @@
 *This function will return the result as error when
 . Any one of the argument is non-numeric.
-. <math>KnownYs</math> and <math>KnownXs</math> are empty or that have less than three data points.
+. KnownYs and KnownXs are empty or that have less than three data points.
-. <math>KnownYs</math> and <math>KnownXs </math> have a different number of data points.
+. KnownYs and KnownXs  have a different number of data points.
 ==Examples==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''STEYX(y,x)'''</div><br/>
+<div style="font-size:30px">'''STEYX (KnownYs,KnownXs) '''</div><br/>
-*<math>y</math> is set of dependent values.
+*<math>KnownYs</math> is set of dependent values.
-*<math>x </math> is the set of independent  values.
+*<math>KnownXs </math> is the set of independent  values.
 ==Description==
@@ Line 10: / Line 11: @@
 <math>\sqrt{\frac{1}{(n-2)}\left [ \sum(y-\bar{y})^2-\frac{[\sum(x-\bar{x})(y-\bar{y})]^2}{\sum(x-\bar{x})^2} \right ]}</math>
 where <math>\bar{x}</math> and <math>\bar{y}</math> are the sample mean <math> x </math> and <math> y </math>.
-*In <math> STEYX(y,x)</math>, <math>y </math> is the array of the numeric dependent values and <math> x </math> is the array of the independent values.
+*In <math>STEYX (KnownYs,KnownXs)</math>, <math>KnownYs </math> is the array of the numeric dependent values and <math> KnownXs </math> is the array of the independent values.
 *The arguments can be be either numbers or names, array,constants or references that contain numbers.
 *Suppose the array contains text,logical values or empty cells, like that values are not considered.
 *This function will return the result as error when
 . Any one of the argument is non-numeric.
-. <math>x</math> and <math>y </math> are empty or that have less than three data points.
+. <math>KnownYs</math> and <math>KnownXs</math> are empty or that have less than three data points.
-. <math>x</math> and <math>y </math> have a different number of data points.
+. <math>KnownYs</math> and <math>KnownXs </math> have a different number of data points.
 ==Examples==

← Older revision		Revision as of 07:35, 13 March 2017
Line 73:		Line 73:
	==References==		==References==
	*[http://www.ncssm.edu/courses/math/Talks/PDFS/Standard%20Errors%20for%20Regression%20Equations.pdf Standard Error]		*[http://www.ncssm.edu/courses/math/Talks/PDFS/Standard%20Errors%20for%20Regression%20Equations.pdf Standard Error]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 32: / Line 32: @@
 |}
-  =STEYX(A1:F1,A2:F2) = 1.4350701130
+  =STEYX(A1:F1,A2:F2) = 1.4525201161135368
 .
 {| class="wikitable"
@@ Line 46: / Line 46: @@
 |}
-  =STEYX(A1:E1,A2:E2)) = 5.944184833375
+  =STEYX(A1:E1,A2:E2)) = 5.944184833375669
 .
 {| class="wikitable"

← Older revision		Revision as of 20:06, 26 June 2015
Line 61:		Line 61:

	=STEYX(A1:A5,B1:B4) = NAN		=STEYX(A1:A5,B1:B4) = NAN
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|npmg9yvkz3g\|280\|center\|Standard Error Of Estimate}}

	==See Also==		==See Also==

← Older revision		Revision as of 18:22, 11 May 2015
Line 68:		Line 68:

	==References==		==References==
		+	*[http://www.ncssm.edu/courses/math/Talks/PDFS/Standard%20Errors%20for%20Regression%20Equations.pdf Standard Error]

@@ Line 32: / Line 32: @@
 |}
-  =STEYX(A1:F1,A2:F2)=1.4350701130
+  =STEYX(A1:F1,A2:F2) = 1.4350701130
 .
 {| class="wikitable"
@@ Line 46: / Line 46: @@
 |}
-  =STEYX(A1:E1,A2:E2))=5.944184833375
+  =STEYX(A1:E1,A2:E2)) = 5.944184833375
 .
 {| class="wikitable"
@@ Line 59: / Line 59: @@
 | 10 || 4 || 7 || 5 ||
 |}
-y={1,2,4,5,8}
-x={10,4,7,5}
+  =STEYX(A1:A5,B1:B4) = NAN
 ==See Also==

@@ Line 19: / Line 19: @@
 ==Examples==
-.y={6,8,10,13,15,5}
+.
- x={1,4,9,11,20,3}
+{| class="wikitable"
-STEYX(G1:G6,H1:H6)=1.4350701130
+|+Spreadsheet
-.y={2,9,1,8,17}
+|-
-x={10,4,11,2,6}
+! !! A !! B !! C !! D!! E !!F
-STEYX(A1:A5,B1:B5)=5.944184833375
+|-
-.y={1,2,4,5,8}
+! 1
 x={10,4,7,5}
-STEYX(A1:A5,B1:B4)=NAN
+ =STEYX(A1:A5,B1:B4)=NAN
 ==See Also==