Difference between revisions of "Manuals/calci/DSTDEV"
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 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 24: | Line 22: | ||
{| 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- 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=" | + | |
| + | |- class="even" | ||
| + | | class="sshl_f" | 10 | ||
| class="sshl_f" | Jill | | class="sshl_f" | Jill | ||
| class="sshl_f" | 45 | | class="sshl_f" | 45 | ||
| Line 75: | Line 99: | ||
|} | |} | ||
| − | =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> | + | =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' in the range A4 to C10, for the cells with Age> | + | =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== | ||
| + | |||
| + | {{#ev:youtube|d7HJqNbPBvg|280|center|DSTDEV}} | ||
| + | |||
== See Also == | == See Also == | ||
| − | |||
*[[Manuals/calci/DSTDEVP| DSTDEVP]] | *[[Manuals/calci/DSTDEVP| DSTDEVP]] | ||
| Line 85: | 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 13: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