Difference between revisions of "Manuals/calci/DVARP"

Latest revision as of 13:51, 24 August 2018

DVARP (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.
- DVARP(), calculates variance based on the entire population of selected database entries.

Description

DVARP (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

=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.

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">'''DVARP'''</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">'''DVARP (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.
+**DVARP(), calculates variance based on the entire population of 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>
+DVARP (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 gives the variance of a population based on the entire population 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">
-DVARP
-</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 =DVARP(C1R4:C3R10,”Age”,C2R1:C3R3) is 50.667</font></font></font>]
-<font face="Arial, sans-serif"><font size="2">[javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">///rly </font>][javascript:ToggleDiv('divExpCollAsst_4') <font color="#0000ff">=DVAR(C1R4:C3R10,”Salary”,C2R1:C3R3) is 666666.667</font>]</font></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" | 50.6667
+| class="sshl_f" | '''Age'''
 |- class="even"
-| class="  " | Row2
+| class="sshl_f" | 2
 | class="sshl_f" |
-| class=" " | &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" | 666666.6667
+| 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>
+ =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. <br/>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. <br/>Returns '''2506172.839506173''' as a result.
+==Related Videos==
+{{#ev:youtube|2Msme90PC58|280|center|DVAR}}
+== See Also ==
+*[[Manuals/calci/DVAR| DVAR]]
+==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/DVARP"

Latest revision as of 13:51, 24 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search