Difference between revisions of "Manuals/calci/DVAR"
Jump to navigation
Jump to search
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DVAR( | + | <div style="font-size:30px">'''DVAR (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> | + | **DVAR(), estimates variance based on a sample from selected database entries. |
| − | |||
| − | *<math> | ||
| − | |||
| − | DVAR() | ||
== Description == | == Description == | ||
| − | DVAR( | + | DVAR (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 100: | Line 96: | ||
| − | =DVAR(A4:C10,"Age",C1: | + | =DVAR(A4:C10,"Age",C1:C3) : Calculates the estimated variance for 'Age' column in the range A4 to C10, for the cells with Salary>8000. <br/>Returns '''41.9524''' as a result. |
=DVAR(A4:C10,3,B1:B3) : Calculates the estimated variance for 'salary' in the range A4 to C10, for the cells with 40>Age>30. <br/>Returns '''2819444.4444444445''' as a result. | =DVAR(A4:C10,3,B1:B3) : Calculates the estimated variance for 'salary' in the range A4 to C10, for the cells with 40>Age>30. <br/>Returns '''2819444.4444444445''' as a result. | ||
| Line 113: | Line 109: | ||
*[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:50, 24 August 2018
DVAR (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.
- DVAR(), estimates variance based on a sample from 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
DVAR (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 |
=DVAR(A4:C10,"Age",C1:C3) : Calculates the estimated variance for 'Age' column in the range A4 to C10, for the cells with Salary>8000.
Returns 41.9524 as a result. =DVAR(A4:C10,3,B1:B3) : Calculates the estimated variance for 'salary' in the range A4 to C10, for the cells with 40>Age>30.
Returns 2819444.4444444445 as a result.
Related Videos
See Also
References