Difference between revisions of "Manuals/calci/DSTDEVP"
Jump to navigation
Jump to search
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DSTDEVP( | + | <div style="font-size:30px">'''DSTDEVP (Array,Field,Criteria)'''</div><br/> |
| − | |||
where, | where, | ||
| − | *<math> | + | *<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> | + | *<math>Criteria</math> is the range of cells that contains the specified criteria. |
| − | + | **DSTDEVP() Calculates the standard deviation based on the entire population of selected database entries. | |
| − | *<math> | ||
| − | |||
| − | DSTDEVP() | ||
== Description == | == Description == | ||
| − | DSTDEVP( | + | DSTDEVP (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 27: | Line 23: | ||
{| 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 78: | Line 100: | ||
|} | |} | ||
| − | =DSTDEVP(A4:C10,"Age",B1:B3) : Calculates the true standard deviation for 'Age' column <br>in the range A4 to C10, for the cells with 40>Age>30. <br />'' | + | =DSTDEVP(A4:C10,"Age",B1:B3) : Calculates the true standard deviation for 'Age' column <br>in the range A4 to C10, for the cells with 40>Age>30. <br />Returns '''4.916588197741686''' as a result. |
| − | =DSTDEVP(A4:C10,3,D1:D2) : Calculates the true standard deviation for 'salary' <br>in the range A4 to C10, for the cells with Age>32. <br />'' | + | =DSTDEVP(A4:C10,3,D1:D2) : Calculates the true standard deviation for 'salary' <br>in the range A4 to C10, for the cells with Age>32. <br />Returns '''1772.004514666935''' as a result. |
==Related Videos== | ==Related Videos== | ||
| Line 92: | Line 114: | ||
*[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:49, 24 August 2018
DSTDEVP (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.
- DSTDEVP() Calculates the standard deviation based on the entire population 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
DSTDEVP (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 DSTDEVP 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 |
=DSTDEVP(A4:C10,"Age",B1:B3) : Calculates the true standard deviation for 'Age' column
in the range A4 to C10, for the cells with 40>Age>30.
Returns 4.916588197741686 as a result. =DSTDEVP(A4:C10,3,D1:D2) : Calculates the true standard deviation for 'salary'
in the range A4 to C10, for the cells with Age>32.
Returns 1772.004514666935 as a result.
Related Videos
See Also
References