[gnumeric] Docs: propagate recent changes
- From: Morten Welinder <mortenw src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] Docs: propagate recent changes
- Date: Tue, 23 Jun 2015 01:14:03 +0000 (UTC)
commit 86c7e3b37fe338780174df5b0cb6c49d396c48f2
Author: Morten Welinder <terra gnome org>
Date: Mon Jun 22 21:13:44 2015 -0400
Docs: propagate recent changes
doc/C/func.defs | 154 ++++++++++++++++++++++++--
doc/C/functions.xml | 302 +++++++++++++++++++++++++++++++++++++++++++++++++--
2 files changed, 439 insertions(+), 17 deletions(-)
---
diff --git a/doc/C/func.defs b/doc/C/func.defs
index aaf93ca..5371856 100644
--- a/doc/C/func.defs
+++ b/doc/C/func.defs
@@ -1073,21 +1073,38 @@ The natural logarithm is not uniquely defined on complex numbers. You may need t
@{from} and @{to} can be any of the following:
Weight and mass:
+ 'brton' Imperial ton
+ 'cwt' U.S. (short) hundredweight
'g' Gram
+ 'grain' Grain
+ 'hweight' Imperial (long) hundredweight
+ 'LTON' Imperial ton
'sg' Slug
+ 'shweight' U.S. (short) hundredweight
'lbm' Pound
+ 'lcwt' Imperial (long) hundredweight
'u' U (atomic mass)
+ 'uk_cwt' Imperial (long) hundredweight
+ 'uk_ton' Imperial ton
'ozm' Ounce
+ 'stone' Stone
+ 'ton' Ton
Distance:
'm' Meter
'mi' Statute mile
+ 'survey_mi' U.S. survey mile
'Nmi' Nautical mile
'in' Inch
'ft' Foot
'yd' Yard
+ 'ell' English Ell
'ang' Angstrom
+ 'ly' Light-Year
+ 'pc' Parsec
+ 'parsec' Parsec
'Pica' Pica Points
+ 'Picapt' Pica Points
'picapt' Pica Points
'pica' Pica
@@ -1099,13 +1116,19 @@ Time:
'sec' Second
Pressure:
- 'Pa' Pascal
+ 'Pa' Pascal
+ 'psi' PSI
'atm' Atmosphere
+ 'Pa' Pascal
'mmHg' mm of Mercury
+ 'Torr' Torr
+
Force:
'N' Newton
'dyn' Dyne
+ 'pond' Pond
+
'lbf' Pound force
Energy:
@@ -1121,6 +1144,7 @@ Energy:
Power:
'HP' Horsepower
+ 'PS' Pferdestärke
'W' Watt
Magnetism:
@@ -1130,18 +1154,78 @@ Magnetism:
Temperature:
'C' Degree Celsius
'F' Degree Fahrenheit
- 'K' Degree Kelvin
+ 'K' Kelvin
+
+ 'Rank' Degree Rankine
+
+ 'Reau' Degree Réaumur
-Liquid measure:
+Volume (liquid measure):
'tsp' Teaspoon
+ 'tspm' Teaspoon (modern, metric)
'tbs' Tablespoon
'oz' Fluid ounce
'cup' Cup
'pt' Pint
+ 'us_pt' U.S. pint
+ 'uk_pt' Imperial pint (U.K.)
'qt' Quart
+ 'uk_qt' Imperial quart
'gal' Gallon
+ 'uk_gal' Imperial gallon
+ 'GRT' Registered ton
+ 'regton' Registered ton
+ 'MTON' Measurement ton (freight ton)
'l' Liter
+ 'L' Liter
+
+ 'lt' Liter
+
+ 'ang3' Cubic Angstrom
+
+ 'ang^3' Cubic Angstrom
+
+ 'barrel' U.S. oil barrel (bbl)
+
+ 'bushel' U.S. bushel
+
+ 'ft3' Cubic feet
+
+ 'ft^3' Cubic feet
+
+ 'in3' Cubic inch
+
+ 'in^3' Cubic inch
+
+ 'ly3' Cubic light-year
+
+ 'ly^3' Cubic light-year
+
+ 'm3' Cubic meter
+
+ 'm^3' Cubic meter
+
+ 'mi3' Cubic mile
+
+ 'mi^3' Cubic mile
+
+ 'yd3' Cubic yard
+
+ 'yd^3' Cubic yard
+
+ 'Nmi3' Cubic nautical mile
+
+ 'Nmi^3' Cubic nautical mile
+
+ 'Picapt3' Cubic Pica
+
+ 'Picapt^3' Cubic Pica
+
+ 'Pica3' Cubic Pica
+
+ 'Pica^3' Cubic Pica
+
For metric units any of the following prefixes can be used:
'Y' yotta 1E+24
'Z' zetta 1E+21
@@ -4440,7 +4524,18 @@ The successive use of the simulation tool also requires that you give to the too
@{size}: sample size
@NOTE=This function requires the usually unknown population standard deviation. If @{size} is non-integer it
is truncated. If @{size} < 0 this function returns a #NUM! error. If @{size} is 0 this function returns a
#DIV/0! error.
@EXCEL=This function is Excel compatible.
- SEEALSO=AVERAGE
+ SEEALSO=AVERAGE,CONFIDENCE.T
+
+ CATEGORY=Statistics
+ FUNCTION=CONFIDENCE T
+ SHORTDESC=margin of error of a confidence interval for the population mean using the Student's
t-distribution
+ SYNTAX=CONFIDENCE T(alpha,stddev,size)
+ ARGUMENTDESCRIPTION=@{alpha}: significance level
+ {stddev}: sample standard deviation
+ {size}: sample size
+ NOTE=If @{stddev} < 0 or = 0 this function returns a #NUM! error. If @{size} is non-integer it is
truncated. If @{size} < 1 this function returns a #NUM! error. If @{size} is 1 this function returns a
#DIV/0! error.
+ EXCEL=This function is Excel compatible.
+ SEEALSO=AVERAGE,CONFIDENCE
@CATEGORY=Statistics
@FUNCTION=CORREL
@@ -4916,7 +5011,18 @@ Any extra statistical information is written below m and b in the result array.
@DESCRIPTION=Strings and empty cells are simply ignored.
If the data set does not contain any duplicates this function returns a #N/A error.
@EXCEL=This function is Excel compatible.
- SEEALSO=AVERAGE,MEDIAN
+ SEEALSO=AVERAGE,MEDIAN,MODE.MULT
+
+ CATEGORY=Statistics
+ FUNCTION=MODE MULT
+ SHORTDESC=most common numbers in the dataset
+ SYNTAX=MODE MULT(number1,number2,…)
+ ARGUMENTDESCRIPTION=@{number1}: first value
+ {number2}: second value
+ DESCRIPTION=Strings and empty cells are simply ignored.
+If the data set does not contain any duplicates this function returns a #N/A error.
+ EXCEL=This function is Excel compatible.
+ SEEALSO=AVERAGE,MEDIAN,MODE
@CATEGORY=Statistics
@FUNCTION=NEGBINOMDIST
@@ -5000,7 +5106,7 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=PERCENTILE
- SHORTDESC=determines the 100* {k}-th percentile of the given data points
+ SHORTDESC=determines the 100* {k}-th percentile of the given data points (Hyndman-Fan method 7: N-1 basis)
@SYNTAX=PERCENTILE(array,k)
@ARGUMENTDESCRIPTION= {array}: data points
@{k}: which percentile to calculate
@@ -5009,8 +5115,18 @@ If the data set does not contain any duplicates this function returns a #N/A err
@SEEALSO=QUARTILE
@CATEGORY=Statistics
+ FUNCTION=PERCENTILE EXC
+ SHORTDESC=determines the 100* {k}-th percentile of the given data points (Hyndman-Fan method 6: N+1 basis)
+ SYNTAX=PERCENTILE EXC(array,k)
+ ARGUMENTDESCRIPTION=@{array}: data points
+ {k}: which percentile to calculate
+ NOTE=If @{array} is empty, this function returns a #NUM! error. If @{k} < 0 or @{k} > 1, this function
returns a #NUM! error.
+ EXCEL=This function is Excel compatible.
+ SEEALSO=PERCENTILE,QUARTILE,QUARTILE.EXC
+
+ CATEGORY=Statistics
@FUNCTION=PERCENTRANK
- SHORTDESC=rank of a data point in a data set
+ SHORTDESC=rank of a data point in a data set (Hyndman-Fan method 7: N-1 basis)
@SYNTAX=PERCENTRANK(array,x,significance)
@ARGUMENTDESCRIPTION= {array}: range of numeric values
@{x}: data point to be ranked
@@ -5019,6 +5135,16 @@ If the data set does not contain any duplicates this function returns a #N/A err
@SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,QUARTILE,SMALL
@CATEGORY=Statistics
+ FUNCTION=PERCENTRANK EXC
+ SHORTDESC=rank of a data point in a data set (Hyndman-Fan method 6: N+1 basis)
+ SYNTAX=PERCENTRANK EXC(array,x,significance)
+ ARGUMENTDESCRIPTION=@{array}: range of numeric values
+ {x}: data point to be ranked
+ {significance}: number of significant digits, defaults to 3
+ NOTE=If @{array} contains no data points, this function returns a #NUM! error. If @{significance} is less
than one, this function returns a #NUM! error. If @{x} exceeds the largest value or is less than the smallest
value in @{array}, this function returns a #NUM! error. If @{x} does not match any of the values in @{array}
or @{x} matches more than once, this function interpolates the returned value.
+ SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,PERCENTILE.EXC,QUARTILE,QUARTILE.EXC,SMALL
+
+ CATEGORY=Statistics
@FUNCTION=PERMUT
@SHORTDESC=number of @{k}-permutations of a @{n}-set
@SYNTAX=PERMUT(n,k)
@@ -5063,13 +5189,23 @@ If the data set does not contain any duplicates this function returns a #N/A err
@CATEGORY=Statistics
@FUNCTION=QUARTILE
- SHORTDESC=the @{k}-th quartile of the data points
+ SHORTDESC=the @{k}-th quartile of the data points (Hyndman-Fan method 7: N-1 basis)
@SYNTAX=QUARTILE(array,quart)
@ARGUMENTDESCRIPTION= {array}: data points
@{quart}: a number from 0 to 4, indicating which quartile to calculate
@NOTE=If @{array} is empty, this function returns a #NUM! error. If @{quart} < 0 or @{quart} > 4, this
function returns a #NUM! error. If @{quart} = 0, the smallest value of @{array} to be returned. If @{quart}
is not an integer, it is truncated.
@EXCEL=This function is Excel compatible.
- SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,SMALL
+ SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,QUARTILE.EXC,SMALL
+
+ CATEGORY=Statistics
+ FUNCTION=QUARTILE EXC
+ SHORTDESC=the @{k}-th quartile of the data points (Hyndman-Fan method 6: N+1 basis)
+ SYNTAX=QUARTILE EXC(array,quart)
+ ARGUMENTDESCRIPTION=@{array}: data points
+ {quart}: a number from 1 to 3, indicating which quartile to calculate
+ NOTE=If @{array} is empty, this function returns a #NUM! error. If @{quart} < 0 or @{quart} > 4, this
function returns a #NUM! error. If @{quart} = 0, the smallest value of @{array} to be returned. If @{quart}
is not an integer, it is truncated.
+ EXCEL=This function is Excel compatible.
+ SEEALSO=LARGE,MAX,MEDIAN,MIN,PERCENTILE,PERCENTILE.EXC,QUARTILE,SMALL
@CATEGORY=Statistics
@FUNCTION=R.DBETA
diff --git a/doc/C/functions.xml b/doc/C/functions.xml
index 4f9d87c..5e68d18 100644
--- a/doc/C/functions.xml
+++ b/doc/C/functions.xml
@@ -3946,21 +3946,38 @@
<para><parameter>from</parameter> and <parameter>to</parameter> can be any of the following:</para>
<para/>
<para>Weight and mass:</para>
+ <para> 'brton' Imperial ton</para>
+ <para> 'cwt' U.S. (short) hundredweight</para>
<para> 'g' Gram</para>
+ <para> 'grain' Grain</para>
+ <para> 'hweight' Imperial (long) hundredweight</para>
+ <para> 'LTON' Imperial ton</para>
<para> 'sg' Slug</para>
+ <para> 'shweight' U.S. (short) hundredweight</para>
<para> 'lbm' Pound</para>
+ <para> 'lcwt' Imperial (long) hundredweight</para>
<para> 'u' U (atomic mass)</para>
+ <para> 'uk_cwt' Imperial (long) hundredweight</para>
+ <para> 'uk_ton' Imperial ton</para>
<para> 'ozm' Ounce</para>
+ <para> 'stone' Stone</para>
+ <para> 'ton' Ton</para>
<para/>
<para>Distance:</para>
<para> 'm' Meter</para>
<para> 'mi' Statute mile</para>
+ <para> 'survey_mi' U.S. survey mile</para>
<para> 'Nmi' Nautical mile</para>
<para> 'in' Inch</para>
<para> 'ft' Foot</para>
<para> 'yd' Yard</para>
+ <para> 'ell' English Ell</para>
<para> 'ang' Angstrom</para>
+ <para> 'ly' Light-Year</para>
+ <para> 'pc' Parsec</para>
+ <para> 'parsec' Parsec</para>
<para> 'Pica' Pica Points</para>
+ <para> 'Picapt' Pica Points</para>
<para> 'picapt' Pica Points</para>
<para> 'pica' Pica</para>
<para/>
@@ -3972,13 +3989,19 @@
<para> 'sec' Second</para>
<para/>
<para>Pressure:</para>
- <para> 'Pa' Pascal</para>
+ <para> 'Pa' Pascal</para>
+ <para> 'psi' PSI</para>
<para> 'atm' Atmosphere</para>
+ <para> 'Pa' Pascal</para>
<para> 'mmHg' mm of Mercury</para>
<para/>
+ <para> 'Torr' Torr</para>
+ <para/>
<para>Force:</para>
<para> 'N' Newton</para>
<para> 'dyn' Dyne</para>
+ <para> 'pond' Pond</para>
+ <para/>
<para> 'lbf' Pound force</para>
<para/>
<para>Energy:</para>
@@ -3994,6 +4017,7 @@
<para/>
<para>Power:</para>
<para> 'HP' Horsepower</para>
+ <para> 'PS' Pferdestärke</para>
<para> 'W' Watt</para>
<para/>
<para>Magnetism:</para>
@@ -4003,18 +4027,78 @@
<para>Temperature:</para>
<para> 'C' Degree Celsius</para>
<para> 'F' Degree Fahrenheit</para>
- <para> 'K' Degree Kelvin</para>
+ <para> 'K' Kelvin</para>
+ <para/>
+ <para> 'Rank' Degree Rankine</para>
+ <para/>
+ <para> 'Reau' Degree Réaumur</para>
<para/>
- <para>Liquid measure:</para>
+ <para>Volume (liquid measure):</para>
<para> 'tsp' Teaspoon</para>
+ <para> 'tspm' Teaspoon (modern, metric)</para>
<para> 'tbs' Tablespoon</para>
<para> 'oz' Fluid ounce</para>
<para> 'cup' Cup</para>
<para> 'pt' Pint</para>
+ <para> 'us_pt' U.S. pint</para>
+ <para> 'uk_pt' Imperial pint (U.K.)</para>
<para> 'qt' Quart</para>
+ <para> 'uk_qt' Imperial quart</para>
<para> 'gal' Gallon</para>
+ <para> 'uk_gal' Imperial gallon</para>
+ <para> 'GRT' Registered ton</para>
+ <para> 'regton' Registered ton</para>
+ <para> 'MTON' Measurement ton (freight ton)</para>
<para> 'l' Liter</para>
<para/>
+ <para> 'L' Liter</para>
+ <para/>
+ <para> 'lt' Liter</para>
+ <para/>
+ <para> 'ang3' Cubic Angstrom</para>
+ <para/>
+ <para> 'ang^3' Cubic Angstrom</para>
+ <para/>
+ <para> 'barrel' U.S. oil barrel (bbl)</para>
+ <para/>
+ <para> 'bushel' U.S. bushel</para>
+ <para/>
+ <para> 'ft3' Cubic feet</para>
+ <para/>
+ <para> 'ft^3' Cubic feet</para>
+ <para/>
+ <para> 'in3' Cubic inch</para>
+ <para/>
+ <para> 'in^3' Cubic inch</para>
+ <para/>
+ <para> 'ly3' Cubic light-year</para>
+ <para/>
+ <para> 'ly^3' Cubic light-year</para>
+ <para/>
+ <para> 'm3' Cubic meter</para>
+ <para/>
+ <para> 'm^3' Cubic meter</para>
+ <para/>
+ <para> 'mi3' Cubic mile</para>
+ <para/>
+ <para> 'mi^3' Cubic mile</para>
+ <para/>
+ <para> 'yd3' Cubic yard</para>
+ <para/>
+ <para> 'yd^3' Cubic yard</para>
+ <para/>
+ <para> 'Nmi3' Cubic nautical mile</para>
+ <para/>
+ <para> 'Nmi^3' Cubic nautical mile</para>
+ <para/>
+ <para> 'Picapt3' Cubic Pica</para>
+ <para/>
+ <para> 'Picapt^3' Cubic Pica</para>
+ <para/>
+ <para> 'Pica3' Cubic Pica</para>
+ <para/>
+ <para> 'Pica^3' Cubic Pica</para>
+ <para/>
<para>For metric units any of the following prefixes can be used:</para>
<para> 'Y' yotta 1E+24</para>
<para> 'Z' zetta 1E+21</para>
@@ -15315,7 +15399,46 @@
</refsect1>
<refsect1>
<title>See also</title>
- <para><link linkend="gnumeric-function-AVERAGE"><function>AVERAGE</function></link>.
+ <para><link linkend="gnumeric-function-AVERAGE"><function>AVERAGE</function></link>,
+ <link linkend="gnumeric-function-CONFIDENCE.T"><function>CONFIDENCE.T</function></link>.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="gnumeric-function-CONFIDENCE.T">
+ <refmeta>
+ <refentrytitle>
+ <function>CONFIDENCE.T</function>
+ </refentrytitle>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <function>CONFIDENCE.T</function>
+ </refname>
+ <refpurpose>
+ margin of error of a confidence interval for the population mean using the Student's t-distribution
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+
<synopsis><function>CONFIDENCE.T</function>(<parameter>alpha</parameter>,<parameter>stddev</parameter>,<parameter>size</parameter>)</synopsis>
+ </refsynopsisdiv>
+ <refsect1>
+ <title>Arguments</title>
+ <para><parameter>alpha</parameter>: significance level</para>
+ <para><parameter>stddev</parameter>: sample standard deviation</para>
+ <para><parameter>size</parameter>: sample size</para>
+ </refsect1>
+ <refsect1>
+ <title>Note</title>
+ <para>If <parameter>stddev</parameter> < 0 or = 0 this function returns a #NUM! error. If
<parameter>size</parameter> is non-integer it is truncated. If <parameter>size</parameter> < 1 this
function returns a #NUM! error. If <parameter>size</parameter> is 1 this function returns a #DIV/0!
error.</para>
+ </refsect1>
+ <refsect1>
+ <title>Microsoft Excel Compatibility</title>
+ <para>This function is Excel compatible.</para>
+ </refsect1>
+ <refsect1>
+ <title>See also</title>
+ <para><link linkend="gnumeric-function-AVERAGE"><function>AVERAGE</function></link>,
+ <link linkend="gnumeric-function-CONFIDENCE"><function>CONFIDENCE</function></link>.
</para>
</refsect1>
</refentry>
@@ -17019,7 +17142,47 @@
<refsect1>
<title>See also</title>
<para><link linkend="gnumeric-function-AVERAGE"><function>AVERAGE</function></link>,
- <link linkend="gnumeric-function-MEDIAN"><function>MEDIAN</function></link>.
+ <link linkend="gnumeric-function-MEDIAN"><function>MEDIAN</function></link>,
+ <link linkend="gnumeric-function-MODE.MULT"><function>MODE.MULT</function></link>.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="gnumeric-function-MODE.MULT">
+ <refmeta>
+ <refentrytitle>
+ <function>MODE.MULT</function>
+ </refentrytitle>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <function>MODE.MULT</function>
+ </refname>
+ <refpurpose>
+ most common numbers in the dataset
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+
<synopsis><function>MODE.MULT</function>(<parameter>number1</parameter>,<parameter>number2</parameter>,<parameter/>…)</synopsis>
+ </refsynopsisdiv>
+ <refsect1>
+ <title>Arguments</title>
+ <para><parameter>number1</parameter>: first value</para>
+ <para><parameter>number2</parameter>: second value</para>
+ </refsect1>
+ <refsect1>
+ <title>Description</title>
+ <para>Strings and empty cells are simply ignored.</para>
+ <para>If the data set does not contain any duplicates this function returns a #N/A error.</para>
+ </refsect1>
+ <refsect1>
+ <title>Microsoft Excel Compatibility</title>
+ <para>This function is Excel compatible.</para>
+ </refsect1>
+ <refsect1>
+ <title>See also</title>
+ <para><link linkend="gnumeric-function-AVERAGE"><function>AVERAGE</function></link>,
+ <link linkend="gnumeric-function-MEDIAN"><function>MEDIAN</function></link>,
+ <link linkend="gnumeric-function-MODE"><function>MODE</function></link>.
</para>
</refsect1>
</refentry>
@@ -17330,7 +17493,7 @@
<function>PERCENTILE</function>
</refname>
<refpurpose>
- determines the 100*<parameter>k</parameter>-th percentile of the given data points
+ determines the 100*<parameter>k</parameter>-th percentile of the given data points (Hyndman-Fan
method 7: N-1 basis)
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -17355,6 +17518,44 @@
</para>
</refsect1>
</refentry>
+ <refentry id="gnumeric-function-PERCENTILE.EXC">
+ <refmeta>
+ <refentrytitle>
+ <function>PERCENTILE.EXC</function>
+ </refentrytitle>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <function>PERCENTILE.EXC</function>
+ </refname>
+ <refpurpose>
+ determines the 100*<parameter>k</parameter>-th percentile of the given data points (Hyndman-Fan
method 6: N+1 basis)
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+
<synopsis><function>PERCENTILE.EXC</function>(<parameter>array</parameter>,<parameter>k</parameter>)</synopsis>
+ </refsynopsisdiv>
+ <refsect1>
+ <title>Arguments</title>
+ <para><parameter>array</parameter>: data points</para>
+ <para><parameter>k</parameter>: which percentile to calculate</para>
+ </refsect1>
+ <refsect1>
+ <title>Note</title>
+ <para>If <parameter>array</parameter> is empty, this function returns a #NUM! error. If
<parameter>k</parameter> < 0 or <parameter>k</parameter> > 1, this function returns a #NUM!
error.</para>
+ </refsect1>
+ <refsect1>
+ <title>Microsoft Excel Compatibility</title>
+ <para>This function is Excel compatible.</para>
+ </refsect1>
+ <refsect1>
+ <title>See also</title>
+ <para><link linkend="gnumeric-function-PERCENTILE"><function>PERCENTILE</function></link>,
+ <link linkend="gnumeric-function-QUARTILE"><function>QUARTILE</function></link>,
+ <link linkend="gnumeric-function-QUARTILE.EXC"><function>QUARTILE.EXC</function></link>.
+ </para>
+ </refsect1>
+ </refentry>
<refentry id="gnumeric-function-PERCENTRANK">
<refmeta>
<refentrytitle>
@@ -17366,7 +17567,7 @@
<function>PERCENTRANK</function>
</refname>
<refpurpose>
- rank of a data point in a data set
+ rank of a data point in a data set (Hyndman-Fan method 7: N-1 basis)
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -17394,6 +17595,47 @@
</para>
</refsect1>
</refentry>
+ <refentry id="gnumeric-function-PERCENTRANK.EXC">
+ <refmeta>
+ <refentrytitle>
+ <function>PERCENTRANK.EXC</function>
+ </refentrytitle>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <function>PERCENTRANK.EXC</function>
+ </refname>
+ <refpurpose>
+ rank of a data point in a data set (Hyndman-Fan method 6: N+1 basis)
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+
<synopsis><function>PERCENTRANK.EXC</function>(<parameter>array</parameter>,<parameter>x</parameter>,<parameter>significance</parameter>)</synopsis>
+ </refsynopsisdiv>
+ <refsect1>
+ <title>Arguments</title>
+ <para><parameter>array</parameter>: range of numeric values</para>
+ <para><parameter>x</parameter>: data point to be ranked</para>
+ <para><parameter>significance</parameter>: number of significant digits, defaults to 3</para>
+ </refsect1>
+ <refsect1>
+ <title>Note</title>
+ <para>If <parameter>array</parameter> contains no data points, this function returns a #NUM! error.
If <parameter>significance</parameter> is less than one, this function returns a #NUM! error. If
<parameter>x</parameter> exceeds the largest value or is less than the smallest value in
<parameter>array</parameter>, this function returns a #NUM! error. If <parameter>x</parameter> does not match
any of the values in <parameter>array</parameter> or <parameter>x</parameter> matches more than once, this
function interpolates the returned value.</para>
+ </refsect1>
+ <refsect1>
+ <title>See also</title>
+ <para><link linkend="gnumeric-function-LARGE"><function>LARGE</function></link>,
+ <link linkend="gnumeric-function-MAX"><function>MAX</function></link>,
+ <link linkend="gnumeric-function-MEDIAN"><function>MEDIAN</function></link>,
+ <link linkend="gnumeric-function-MIN"><function>MIN</function></link>,
+ <link linkend="gnumeric-function-PERCENTILE"><function>PERCENTILE</function></link>,
+ <link linkend="gnumeric-function-PERCENTILE.EXC"><function>PERCENTILE.EXC</function></link>,
+ <link linkend="gnumeric-function-QUARTILE"><function>QUARTILE</function></link>,
+ <link linkend="gnumeric-function-QUARTILE.EXC"><function>QUARTILE.EXC</function></link>,
+ <link linkend="gnumeric-function-SMALL"><function>SMALL</function></link>.
+ </para>
+ </refsect1>
+ </refentry>
<refentry id="gnumeric-function-PERMUT">
<refmeta>
<refentrytitle>
@@ -17554,7 +17796,7 @@
<function>QUARTILE</function>
</refname>
<refpurpose>
- the <parameter>k</parameter>-th quartile of the data points
+ the <parameter>k</parameter>-th quartile of the data points (Hyndman-Fan method 7: N-1 basis)
</refpurpose>
</refnamediv>
<refsynopsisdiv>
@@ -17580,6 +17822,50 @@
<link linkend="gnumeric-function-MEDIAN"><function>MEDIAN</function></link>,
<link linkend="gnumeric-function-MIN"><function>MIN</function></link>,
<link linkend="gnumeric-function-PERCENTILE"><function>PERCENTILE</function></link>,
+ <link linkend="gnumeric-function-QUARTILE.EXC"><function>QUARTILE.EXC</function></link>,
+ <link linkend="gnumeric-function-SMALL"><function>SMALL</function></link>.
+ </para>
+ </refsect1>
+ </refentry>
+ <refentry id="gnumeric-function-QUARTILE.EXC">
+ <refmeta>
+ <refentrytitle>
+ <function>QUARTILE.EXC</function>
+ </refentrytitle>
+ </refmeta>
+ <refnamediv>
+ <refname>
+ <function>QUARTILE.EXC</function>
+ </refname>
+ <refpurpose>
+ the <parameter>k</parameter>-th quartile of the data points (Hyndman-Fan method 6: N+1 basis)
+ </refpurpose>
+ </refnamediv>
+ <refsynopsisdiv>
+
<synopsis><function>QUARTILE.EXC</function>(<parameter>array</parameter>,<parameter>quart</parameter>)</synopsis>
+ </refsynopsisdiv>
+ <refsect1>
+ <title>Arguments</title>
+ <para><parameter>array</parameter>: data points</para>
+ <para><parameter>quart</parameter>: a number from 1 to 3, indicating which quartile to
calculate</para>
+ </refsect1>
+ <refsect1>
+ <title>Note</title>
+ <para>If <parameter>array</parameter> is empty, this function returns a #NUM! error. If
<parameter>quart</parameter> < 0 or <parameter>quart</parameter> > 4, this function returns a #NUM!
error. If <parameter>quart</parameter> = 0, the smallest value of <parameter>array</parameter> to be
returned. If <parameter>quart</parameter> is not an integer, it is truncated.</para>
+ </refsect1>
+ <refsect1>
+ <title>Microsoft Excel Compatibility</title>
+ <para>This function is Excel compatible.</para>
+ </refsect1>
+ <refsect1>
+ <title>See also</title>
+ <para><link linkend="gnumeric-function-LARGE"><function>LARGE</function></link>,
+ <link linkend="gnumeric-function-MAX"><function>MAX</function></link>,
+ <link linkend="gnumeric-function-MEDIAN"><function>MEDIAN</function></link>,
+ <link linkend="gnumeric-function-MIN"><function>MIN</function></link>,
+ <link linkend="gnumeric-function-PERCENTILE"><function>PERCENTILE</function></link>,
+ <link linkend="gnumeric-function-PERCENTILE.EXC"><function>PERCENTILE.EXC</function></link>,
+ <link linkend="gnumeric-function-QUARTILE"><function>QUARTILE</function></link>,
<link linkend="gnumeric-function-SMALL"><function>SMALL</function></link>.
</para>
</refsect1>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
