Difference between revisions of "Manuals/calci/DSTDEV"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DSTDEV( | + | <div style="font-size:30px">'''DSTDEV (Array,Field,Criteria)'''</div><br/> |
| − | |||
where, | where, | ||
| − | *<math> | + | *<math>Array</math> is the range of cells that makes up the list or database |
| − | *<math> | + | *<math>Field</math> shows which column is used in the function and |
| − | *<math> | + | *<math>Criteria</math> is the range of cells that contains the specified criteria. |
| − | + | **DSTDEV(), estimates the standard deviation based on a sample of selected database entries. | |
| − | DSTDEV() | ||
== Description == | == Description == | ||
| − | DSTDEV( | + | DSTDEV (Array,Field,Criteria) |
*Standard deviation shows the variation of data points from the average value. | *Standard deviation shows the variation of data points from the average value. | ||
*If data points are close to mean value, a low standard deviation is observed. If data points are spread out from the mean value, a high standard deviation is observed. | *If data points are close to mean value, a low standard deviation is observed. If data points are spread out from the mean value, a high standard deviation is observed. | ||
| − | *A <math> | + | *A <math>Field</math> argument can be expressed as "Salary" (a column name) or 3(position of the column). |
| − | *<math> | + | *<math>Criteria</math> can be any range on the Calci with minimum of one column and at least one row indicating the condition. |
| − | *The <math> | + | *The <math>Criteria</math> columns should not overlap the list of data. |
== Examples == | == Examples == | ||
| Line 114: | Line 112: | ||
*[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 14:48, 24 August 2018
DSTDEV (Array,Field,Criteria)
where,
- is the range of cells that makes up the list or database
- shows which column is used in the function and
- is the range of cells that contains the specified criteria.
- DSTDEV(), estimates the standard deviation based on a sample of selected database entries.
is the range of cells that makes up the list or database
shows which column is used in the function and
is the range of cells that contains the specified criteria.
Description
DSTDEV (Array,Field,Criteria)
- Standard deviation shows the variation of data points from the average value.
- If data points are close to mean value, a low standard deviation is observed. If data points are spread out from the mean value, a high standard deviation is observed.
- A argument can be expressed as "Salary" (a column name) or 3(position of the column).
- can be any range on the Calci with minimum of one column and at least one row indicating the condition.
- The columns should not overlap the list of data.
Examples
Consider the following table with Employee details as input to DSTDEV function.
| A | B | C | D | |
| 1 | Name | Age | Salary | Age |
| 2 | <40 | >8000 | >32 | |
| 3 | >30 | |||
| 4 | Name | Age | Salary | |
| 5 | John | 34 | 5500 | |
| 6 | Bill | 35 | 6500 | |
| 7 | Clark | 29 | 7000 | |
| 8 | Bob | 45 | 9000 | |
| 9 | Susan | 37 | 4000 | |
| 10 | Jill | 45 | 8000 |
=DSTDEV(A4:C10,"Age",B1:B3) : Calculates the standard deviation for 'Age' column
in the range A4 to C10, for the cells with 40>Age>30.
Returns 5.214829282387338 as a result. =DSTDEV(A4:C10,3,D1:D2) : Calculates the standard deviation for 'salary'
in the range A4 to C10, for the cells with Age>32.
Returns 1981.161275615895 as a result.
Related Videos
See Also
References