Difference between revisions of "Manuals/calci/DVAR"

Latest revision as of 14:50, 24 August 2018

DVAR (Array,Field,Criteria)

Where $Array$ is the range of cells that makes up the list or database
$Field$ 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.

Description

DVAR (Array,Field,Criteria)

A $Field$ argument can be expressed as "Salary" (a column name) or 3(position of the column).
$Criteria$ can be any range on the Calci with minimum of one column and at least one row indicating the condition.
The $Criteria$ 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.

References

List of Aggregate Functions

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left"><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''DVAR'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''db'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''fld'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''cri'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+<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
+*<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.
+**DVAR(), estimates variance based on a sample from selected database entries.
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where db'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is the range of cells that makes up the list or database,</font></font></font>
+== Description ==
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">fld shows which column is used in the function and </font></font></font>
+DVAR (Array,Field,Criteria)
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">cri   is the range of cells that contains the conditions that we specify. </font></font></font>
+*A <math>Field</math> argument can be expressed as "Salary" (a column name) or 3(position of the column).
+*<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>Criteria</math> columns should not overlap the list of data.
-</div>
+== Examples ==
-----
-<div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It calculates the estimates of the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions we specify.</font></font></font></div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-DVAR
-</div></div>
-----
-<div id="8SpaceContent" class="zcontent" align="left">
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#666666"><font face="Arial, sans-serif"><font size="2">Let's see an example</font></font></font>]
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">Let's see an example</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">C1 C2 C3 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R1 Name Age Salary </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R2 &lt;30 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R3 &gt;40 &gt;5000</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R4 Name Age Salary</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R5 John 34 5500 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R6 Bill 35 6500 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R7 Clark 29 7000 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R8 Bob 43 9000</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R9 Susan 37 4000</font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">R10 Jill 45 8000 </font>]
-<font color="#0000ff"><br /></font>
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#666666"><font face="Arial, sans-serif"><font size="2">I.e =DVAR(C1R4:C3R10,”Age”,C2R1:C3R3) is 76</font></font></font>]
-[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">///rly </font>][javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">=DVAR(C1R4:C3R10,”Salary”,C2R1:C3R3) is 1000000</font>]
-</div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class="   " |
+| class="sshl_f" |
-<div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
+| class="sshl_f" | A
-| class="    " | Column1
+| class="sshl_f" | B
-| class="    " | Column2
+| class="sshl_f" | C
-| class=" " | Column3
+| class="sshl_f" | D
-| class="  " | Column4
 |- class="odd"
-| class=" " | Row1
+| 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" | 76
+| class="sshl_f" | '''Age'''
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" | 2
 | class="sshl_f" |
-| class="sshl_f" | &lt;30
+| class="sshl_f" | &lt;40
+| class="sshl_f" | &gt;8000
+| class="sshl_f" | &gt;32
+|- class="odd"
+| class="sshl_f" | 3
 | class="sshl_f" |
-| class="sshl_f" | 1000000
+| class="sshl_f" | &gt;30
-|- class="odd"
+| class="sshl_f" |
-| Row3
 | class="sshl_f" |
-| class="sshl_f  " | &gt;40
-| class="sshl_f      " | &gt;5000
-| class="sshl_f SelectTD SelectTD" |
-<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 |- class="even"
-| Row4
+| 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="odd"
-| class=" " | Row5
+| class="sshl_f" | 5
 | class="sshl_f" | John
 | class="sshl_f" | 34
 | class="sshl_f" | 5500
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" | Row6
+| class="sshl_f" | 6
 | class="sshl_f" | Bill
 | class="sshl_f" | 35
 | class="sshl_f" | 6500
-| class="sshl_f  " |
+| class="sshl_f" |
 |- class="odd"
-| class="sshl_f" | Row7
+| class="sshl_f" | 7
 | class="sshl_f" | Clark
 | class="sshl_f" | 29
 | class="sshl_f" | 7000
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" | Row8
+| class="sshl_f" | 8
 | class="sshl_f" | Bob
-| class="sshl_f" | 43
+| class="sshl_f" | 45
 | class="sshl_f" | 9000
 | class="sshl_f" |
 |- class="odd"
-| class="sshl_f" | Row9
+| class="sshl_f" | 9
 | class="sshl_f" | Susan
-| class="sshl_f  " | 37
+| class="sshl_f" | 37
 | class="sshl_f" | 4000
 | class="sshl_f" |
 |- class="even"
-| class="sshl_f" | Row10
+| class="sshl_f" | 10
 | class="sshl_f" | Jill
 | class="sshl_f" | 45
-| class=" " | 8000
+| class="ssh1_f" | 8000
 | class="sshl_f" |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----
+ =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.
+==Related Videos==
+{{#ev:youtube|2Msme90PC58|280|center|DVAR}}
+== See Also ==
+*[[Manuals/calci/DVARP| DVARP]]
+==References==
+*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/DVAR"

Latest revision as of 14:50, 24 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search