writer
6,694
edits
Changes
no edit summary
=DSTDEV(database, field, criteria)=
<div style="font-size:30px">'''DSTDEV (Array,Field,Criteria)'''</div><br/>
where,
where,
*<math>database</math> is the range of cells that makes up the list or database
*<math>Array</math> is the range of cells that makes up the list or database
*<math>field</math> shows which column is used in the function and
*<math>Field</math> shows which column is used in the function and
*<math>criteria</math> is the range of cells that contains the specified criteria.
*<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() calculates the standard deviation of a population, based on a sample by using data in a database column that matches the specified condition.
== Description ==
== Description ==
DSTDEV(database, field, criteria)
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>field</math> argument can be expressed as "Salary" (a column name) or 3(position of the column).
*A <math>Field</math> argument can be expressed as "Salary" (a column name) or 3(position of the column).
*<math>criteria</math> can be any range on the Calci with minimum of one column and at least one row indicating the condition.
*<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>criteria</math> columns should not overlap the list of data.
*The <math>Criteria</math> columns should not overlap the list of data.
== Examples ==
== Examples ==
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" |
| class="sshl_f" | A
| class="sshl_f" | B
| class="sshl_f" | C
| class="sshl_f" | D
|- class="odd"
| class="sshl_f" | 1
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
|- class="odd"
|- class="even"
| class="sshl_f" | 2
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" | <40
| class="sshl_f" | <40
| class="sshl_f" | >8000
| class="sshl_f" | >8000
| class="sshl_f" | >32
| class="sshl_f" | >32
|- class="even"
|- class="odd"
| class="sshl_f" | 3
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" | >30
| class="sshl_f" | >30
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 4
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Name'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Age'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" | '''Salary'''
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 5
| class="sshl_f" | John
| class="sshl_f" | John
| class="sshl_f" | 34
| class="sshl_f" | 34
| class="sshl_f" | 5500
| class="sshl_f" | 5500
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 6
| class="sshl_f" | Bill
| class="sshl_f" | Bill
| class="sshl_f" | 35
| class="sshl_f" | 35
| class="sshl_f" | 6500
| class="sshl_f" | 6500
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 7
| class="sshl_f" | Clark
| class="sshl_f" | Clark
| class="sshl_f" | 29
| class="sshl_f" | 29
| class="sshl_f" | 7000
| class="sshl_f" | 7000
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 8
| class="sshl_f" | Bob
| class="sshl_f" | Bob
| class="sshl_f" | 45
| class="sshl_f" | 45
| class="sshl_f" | 9000
| class="sshl_f" | 9000
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="odd"
| class="sshl_f" | 9
| class="sshl_f" | Susan
| class="sshl_f" | Susan
| class="sshl_f" | 37
| class="sshl_f" | 37
| class="sshl_f" | 4000
| class="sshl_f" | 4000
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="even"
| class="sshl_f" | 10
| class="sshl_f" | Jill
| class="sshl_f" | Jill
| class="sshl_f" | 45
| class="sshl_f" | 45
|}
|}
=DSTDEV(A4:C10,"Age",B1:B3) : Calculates the standard deviation for 'Age' column <br>in the range A4 to C10, for the cells with 40>Age>30. <br /> ''Returns 5.214829282387338'' as a result.
=DSTDEV(A4:C10,"Age",B1:B3) : Calculates the standard deviation for 'Age' column <br>in the range A4 to C10, for the cells with 40>Age>30. <br />Returns '''5.214829282387338''' as a result.
=DSTDEV(A4:C10,3,D1:D2) : Calculates the standard deviation for 'salary' <br>in the range A4 to C10, for the cells with Age>32. <br />''Returns 1981.161275615895'' as a result.
=DSTDEV(A4:C10,3,D1:D2) : Calculates the standard deviation for 'salary' <br>in the range A4 to C10, for the cells with Age>32. <br />Returns '''1981.161275615895''' as a result.
==Related Videos==
==Related Videos==
*[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 ]]