Difference between revisions of "Manuals/calci/DVARP"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DVARP( | + | <div style="font-size:30px">'''DVARP (Array,Field,Criteria) '''</div><br/> |
| − | + | *Where <math>Array</math> is the range of cells that makes up the list or database | |
| − | *Where <math> | + | *<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> | + | **DVARP(), calculates variance based on the entire population of selected database entries. |
| − | |||
| − | *<math> | ||
| − | |||
| − | DVARP() calculates | ||
== Description == | == Description == | ||
| − | DVARP( | + | DVARP (Array,Field,Criteria) |
| − | *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 112: | Line 108: | ||
*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | *[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 13:51, 24 August 2018
DVARP (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.
- DVARP(), calculates variance 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
DVARP (Array,Field,Criteria)
- 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
| 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 |
=DVARP(A4:C10,"Age",C1:C3) : Calculates the true variance for Age column in the range A4 to C10, for the cells with Salary>8000.
Returns 35.95918367346939 as a result. =DVARP(A4:C10,3,B1:B3) : Calculates the true variance for Salary column in the range A4 to C10, for the cells with 40>Age>30.
Returns 2506172.839506173 as a result.
Related Videos
See Also
References