Manuals/calci/STDEVPA - Revision history

Devika at 22:21, 8 August 2018

2018-08-08T22:21:05Z

2018-08-08T22:20:39Z

2018-06-12T21:23:47Z

2018-02-28T19:45:09Z

Examples

2018-02-28T19:44:52Z

Examples

2018-01-18T20:48:50Z

2017-03-13T07:21:09Z

2017-03-09T11:34:30Z

2015-10-07T05:39:24Z

2015-06-25T21:01:02Z

@@ Line 2: / Line 2: @@
 *Parameters are set of numbers.
 **STDEVPA(),calculates standard deviation based on the entire population, including numbers, text, and logical values.
 ==Description==

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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''STDEVPA(n1,n2,n3…)'''</div><br/>
+<div style="font-size:30px">'''STDEVPA()'''</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> STDEVPA(n1,n2,n3...)</math>, <math>n1,n2,n3...</math>, are numbers to find the standard deviation.
+*In <math> STDEVPA()</math>, Parameters are set of numbers to find the standard deviation.
-*Here <math> n1</math> is required. <math> n2,n3,...</math> are optional.
+*Here First Parameter is required. From the second Parameter are optional.
 *Instead of numbers we can use the single array or a reference of a array.
 *STDEVPA is defined by the formula:

@@ Line 39: / Line 39: @@
 |-
 !3
-| 5 || 9 || 17 || true || 6 || 0 || 41 || 14
+| 5 || 9 || 17 || true || 6 || 0 || 41
 |}

@@ Line 38: / Line 38: @@
 | 2 || 2.4 || 3.7 ||14.9 || 28 || 198 || 154.1
 |-
 | 5 || 9 || 17 || true || 6 || 0 || 41 || 14
 |}

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

← Older revision		Revision as of 07:21, 13 March 2017
Line 61:		Line 61:


−	[[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:34, 9 March 2017
Line 58:		Line 58:
	==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 44: / Line 44: @@
 #=STDEVPA(A2:G2) = 76.31463871127
 #=STDEVPA(A3:D3) = 5.916079783
-#=STDEVPA(2,12,22,32,false) = 11.180339887498949
+#=STDEVPA(2,12,22,32,false) = 12.09297316626478
 ==Related Videos==