Difference between revisions of "Manuals/calci/DSTDEV"
Jump to navigation
Jump to search
| Line 24: | Line 24: | ||
{| 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 77: | Line 103: | ||
=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== | ||
Revision as of 13:43, 10 October 2015
DSTDEV(database, 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.
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() calculates the standard deviation of a population, based on a sample by using data in a database column that matches the specified condition.
Description
DSTDEV(database, 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.