<HTML
><HEAD
><TITLE
>DSTDEVP</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="UP"
TITLE="Reference"
HREF="function-reference.html#AEN1187"><LINK
REL="PREVIOUS"
TITLE="ROWS"
HREF="r5329.html"><LINK
REL="NEXT"
TITLE="CHITEST"
HREF="r5393.html"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="r5329.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="r5393.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="AEN5353"
><A
NAME="GNUMERIC-DSTDEVP"
></A
>DSTDEVP</A
></H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN5358"
></A
><H2
>Name</H2
>DSTDEVP&nbsp;--&nbsp;</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN5361"
></A
><H2
>Synopsis</H2
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="SYNOPSIS"
>DSTDEVP(database,field,criteria)</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN5363"
></A
><H2
>Description</H2
><P
>DSTDEVP function returns the standard deviation of a population based on the entire populations. The populations consists of numbers that match conditions specified. </P
><P
>@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column. </P
><P
>@field specifies which column is used in the function.  If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column.  For example, ``Age'' refers to the column with the label ``Age'' in @database range. </P
><P
>@criteria is the range of cells which contains the specified conditions.  The first row of a @criteria should contain the labels of the fields for which the criterias are for.  Cells below the labels specify conditions, for example, ``&#62;3'' or ``&#60;9''.  Equality condition can be given simply by specifing a value, e.g. ``3'' or ``John''.  Each row in @criteria specifies a separate condition, i.e. if a row in @database matches with one of the rows in @criteria then that row is counted in (technically speaking boolean OR between the rows in @criteria).  If @criteria specifies more than one columns then each of the conditions in these columns should be true that the row in @database matches (again technically speaking boolean AND between the columns in each row in @criteria). </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN5369"
></A
><H2
>Examples</H2
><P
></P
><P
>Let us assume that the range A1:C7 contain the following values:</P
><P
>Name    Age     Salary</P
><P
>John    34      54342</P
><P
>Bill    35      22343</P
><P
>Clark   29      34323</P
><P
>Bob     43      47242</P
><P
>Susan   37      42932</P
><P
>Jill    45      45324</P
><P
></P
><P
>In addition, the cells A9:B11 contain the following values:</P
><P
>Age     Salary</P
><P
>&#60;30</P
><P
>&#62;40     &#62;46000</P
><P
></P
><P
>DSTDEVP(A1:C7, "Age", A9:B11) equals 7.</P
><P
>DSTDEVP(A1:C7, "Salary", A9:B11) equals 6459.5.</P
><P
></P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN5389"
></A
><H2
>See also</H2
><P
>        <A
HREF="r9648.html#GNUMERIC-DSTDEV"
>DSTDEV</A
>
      </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="r5329.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="r5393.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
NAME="GNUMERIC-ROWS"
></A
>ROWS</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="function-reference.html#AEN1187"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
NAME="GNUMERIC-CHITEST"
></A
>CHITEST</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>