Manuals/calci/STDEVA - Revision history

Devika at 22:18, 8 August 2018

2018-08-08T22:18:04Z

Devika at 21:19, 12 June 2018

2018-06-12T21:19:22Z

Devika: /* Description */

2018-02-28T19:34:59Z

Description

Jayaram at 07:20, 13 March 2017

2017-03-13T07:20:36Z

Jayaram at 11:33, 9 March 2017

2017-03-09T11:33:53Z

Devika: /* Examples */

2015-10-07T05:29:28Z

Examples

Swapna at 20:58, 25 June 2015

2015-06-25T20:58:37Z

Devika: /* References */

2015-05-11T18:16:57Z

References

Abin: /* Examples */

2014-01-30T10:11:22Z

Examples

Abin at 10:10, 30 January 2014

2014-01-30T10:10:32Z

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''STDEVA()'''</div><br/>
 *Parameters are set of numbers.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''STDEVA(n1,n2,n3…)'''</div><br/>
+<div style="font-size:30px">'''STDEVA()'''</div><br/>
-*<math>n1,n2,n3... </math>  are numbers.
+*Parameters are set of numbers.
 ==Description==
@@ Line 7: / Line 7: @@
 *It is the  used as a measure of the dispersion or variation in a distribution.
 *It is calculated as the square root of variance.
-*In <math>STDEVA(n1,n2,n3...)</math>, <math>n1,n2,n3...</math>, are numbers to find the standard deviation. *Here  <math> n1 ,</math> is required. <math> n2,n3,..</math> are optional.
+*In <math>STDEVA()</math>, Parameters are set of numbers to find the standard deviation.
 *Instead of numbers we can use the single array or a reference of a array.
 *<math> STDEVA </math> is defined by the formula:

@@ Line 12: / Line 12: @@
 <math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math>
 where <math> \bar{x} </math> is the sample mean of x and n is the total numbers in the given data.
-*It is calculated using <math> "n-1" </math> method.
+*It is calculated using  "n-1"  method.
 *This function consider our given data as the sample population.
 *Suppose it consider the data as the entire population, we can use the  [[Manuals/calci/STDEVPA  | STDEVPA ]]    function.

← Older revision		Revision as of 07:20, 13 March 2017
Line 56:		Line 56:


−	[[Z_API_Functions \| List of Main Z Functions]]	+	*[[Z_API_Functions \| List of Main Z Functions]]

−	[[ Z3 \| Z3 home ]]	+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 11:33, 9 March 2017
Line 54:		Line 54:
	==References==		==References==
	*[http://en.wikipedia.org/wiki/Standard_deviation Standard Deviation]		*[http://en.wikipedia.org/wiki/Standard_deviation Standard Deviation]
		+
		+
		+	[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	[[ Z3 \| Z3 home ]]

@@ Line 40: / Line 40: @@
 #=STDEVA(A1:G1) = 267.0566196431
 #=STDEVA(4,8,TRUE) = 3.51188458428
-#=STDEVA(12,18,27,32,false) = 8.958236433584458
+#=STDEVA(12,18,27,32,false) = 12.617448236470002
 ==Related Videos==

← Older revision		Revision as of 18:16, 11 May 2015
Line 49:		Line 49:

	==References==		==References==
		+	*[http://en.wikipedia.org/wiki/Standard_deviation Standard Deviation]

@@ Line 37: / Line 37: @@
 |}
-#STDEVA(A2:E2)=39.8660256358
+#=STDEVA(A2:E2) = 39.8660256358
-#STDEVA(A1:G1)=267.0566196431
+#=STDEVA(A1:G1) = 267.0566196431
-#STDEVA(4,8,TRUE) = 3.51188458428
+#=STDEVA(4,8,TRUE) = 3.51188458428
-#STDEVA(12,18,27,32,false)= 8.958236433584458
+#=STDEVA(12,18,27,32,false) = 8.958236433584458
 ==See Also==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''STDEVA(n1,n2,n3…)'''</div><br/>
 *<math>n1,n2,n3... </math>  are numbers.
 ==Description==
-*This function gives the standard deviation based on a given sample including the logical value and text.
+*This function gives the Standard Deviation based on a given sample including the logical value and text.
-*Standard deviation is a quantity expressing by how much the members of a group differ from the mean value for the group.
+*Standard Deviation is a quantity expressing by how much the members of a group differ from the mean value for the group.
 *It is the  used as a measure of the dispersion or variation in a distribution.
 *It is calculated as the square root of variance.
-*In <math>STDEVA(n1,n2,n3...), n1,n2,n3...</math>, are numbers to find the standard deviation.
+*In <math>STDEVA(n1,n2,n3...)</math>, <math>n1,n2,n3...</math>, are numbers to find the standard deviation. *Here  <math> n1 ,</math> is required. <math> n2,n3,..</math> are optional.
 *Instead of numbers we can use the single array or a reference of a array.
-*<math> STDEVA </math> is defined by the formula:<math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math> where <math> \bar{x} </math> is the sample mean of x and n is the total numbers in the given data.
+*<math> STDEVA </math> is defined by the formula:
 *It is calculated using <math> "n-1" </math> method.
-*This function is considering our given data is the sample of the population.
+*This function consider our given data as the sample population.
-*Suppose it should consider the data as the entire population, we can use the  [[Manuals/calci/STDEVPA  | STDEVPA ]]    function.
+*Suppose it consider the data as the entire population, we can use the  [[Manuals/calci/STDEVPA  | STDEVPA ]]    function.
 *The arguments can be be either numbers or names, array,constants or references that contain numbers.
-*Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a rference.
+*Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a reference.
-*Suppose the arguments containing TRUE which is eveluate as 1, and the arguments containing FALSE which is evaluate as 0.
+*Suppose the arguments containing TRUE which is evaluate as 1, and the arguments containing FALSE which is evaluate as 0.
 *Suppose the array contains the empty cells and text values like that values are not considered.
-*Suppose the function don't want to consider the logical values and text representations of numbers in a reference , we can use the [[Manuals/calci/STDEV  | STDEV ]] function.
+*Suppose the function don't want to consider the logical values and text representations of numbers in a reference, we can use the [[Manuals/calci/STDEV  | STDEV ]] function.
 *This function will return the result as error when
-. Any one of the argument is nonnumeric.
+. Any one of the argument is non-numeric.
 . The arguments containing the error values or text that cannot be translated in to numbers.
 ==Examples==
@@ Line 42: / Line 41: @@
 #STDEVA(4,8,TRUE) = 3.51188458428
 #STDEVA(12,18,27,32,false)= 8.958236433584458
 ==See Also==
@@ Line 49: / Line 47: @@
 *[[Manuals/calci/STDEVP  | STDEVP ]]
 *[[Manuals/calci/STDEV | STDEV ]]
 ==References==