Difference between revisions of "Manuals/calci/STDEVPA"

 
(8 intermediate revisions by 2 users not shown)
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.
 +
**STDEVPA(),calculates standard deviation based on the entire population, including numbers, text, and logical values.
  
 
==Description==
 
==Description==
Line 7: Line 8:
 
*It is the  used as a measure of the dispersion or variation in a distribution.   
 
*It is the  used as a measure of the dispersion or variation in a distribution.   
 
*It is calculated as the square root of variance.
 
*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.  
 
*Instead of numbers we can use the single array or a reference of a array.  
 
*STDEVPA is defined by the formula:  
 
*STDEVPA is defined by the formula:  
 
<math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math>  
 
<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.   
 
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.  
 
*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.  
 
*Suppose it should consider the data as the sample of the population, we can use the [[Manuals/calci/STDEVA| STDEVA]] function.  
Line 38: Line 39:
 
| 2 || 2.4 || 3.7 ||14.9 || 28 || 198 || 154.1  
 
| 2 || 2.4 || 3.7 ||14.9 || 28 || 198 || 154.1  
 
|-
 
|-
| 5 || 9 || 17 || true || 6 || 0 || 41 || 14
+
!3
 +
| 5 || 9 || 17 || true || 6 || 0 || 41  
 
|}
 
|}
  
Line 44: Line 46:
 
#=STDEVPA(A2:G2) = 76.31463871127
 
#=STDEVPA(A2:G2) = 76.31463871127
 
#=STDEVPA(A3:D3) = 5.916079783
 
#=STDEVPA(A3:D3) = 5.916079783
#=STDEVPA(2,12,22,32,false) = 11.180339887498949
+
#=STDEVPA(2,12,22,32,false) = 12.09297316626478
  
 
==Related Videos==
 
==Related Videos==
Line 58: Line 60:
 
==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 ]]

Latest revision as of 17:21, 8 August 2018

STDEVPA()


  • Parameters are set of numbers.
    • STDEVPA(),calculates standard deviation based on the entire population, including numbers, text, and logical values.

Description

  • This function gives the standard deviation based on a entire population as the given data 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.
  • 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  , Parameters are set of numbers to find the standard deviation.
  • 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:

  where   is the sample mean of   and   is the total number in the given data.

  • It is calculated using   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 STDEVA function.
  • For huge sample sizes the functions   and   are approximately equal values.
  • The arguments can 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 reference.
  • 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 * STDEVP function.
  • This function will return the result as error when
   1. Any one of the argument is non-numeric. 
   2. The arguments containing the error values or text that cannot be translated in to numbers.

Examples

Spreadsheet
A B C D E F G
1 87 121 427 390 110 542 412
2 2 2.4 3.7 14.9 28 198 154.1
3 5 9 17 true 6 0 41
  1. =STDEVPA(A1:E1) = 149.0597195757
  2. =STDEVPA(A2:G2) = 76.31463871127
  3. =STDEVPA(A3:D3) = 5.916079783
  4. =STDEVPA(2,12,22,32,false) = 12.09297316626478

Related Videos

STDEVP

See Also

References