Scale-up Suite Help
Functions
 Numero > Functions
What is Numero?

Numero is an Office add-in that brings calculations and chemistry to Word, PowerPoint and Outlook.  This allows you to keep your train of thought and improve productivity when writing technical reports, emails and presentations.  You no longer need to switch from Word, Outlook or PowerPoint to Excel for a simple calculation, or open a browser to access currency conversion rates.  Use the Ctrl+3 shortcut to evaluate formulas quickly and the Formula Bar or Numero ribbon for powerful calculations, including statistics.  Capture notes in a task pane using Plaintext.  Access materials and other information using the Data Services feature.

Constants

The following mathematical constants are available:

 Constant Description Value Unit Pi() The ratio of circle's circumference to it diameter 3.14159265358979 e() Base of natural logarithms 2.71828182845905 RGAS() Ideal gas constant 8.3144598 J/mol.K mu0() Permeability of vacuum 1.2566370614E-06 N/A2 c() Speed of light in vacuum 2.99792458E+08 m/s NA() Avogadro constant 6.0221410000E+23 1/mol e0() Elementary charge 1.6021765650E-19 Coulomb kB() Boltzmann constant 1.3806488589E-23 J/k eps0() Permittivity of vacuum 8.8541878170E-12 A2.s4/kg.m3

Functions
ROUND

DESCRIPTION

Round the number by the specified number of digits

SYNTAX

ROUND(number;digit)

• Number        Any number is required
• Digit              Definition of the number of digits

EXAMPLE

Formula                           Description                                   Result

=ROUND(3.141528;3)      Round 3.141528  to 3 digits         3.142

ROUNDUP

DESCRIPTION

Round the number up by the specified number of digits

SYNTAX

ROUNDUP(number;digit)

• Number        Any number is required
• Digit              Definition of the number of digits

EXAMPLE

Formula                              Description                                       Result

=ROUNDUP(3.23412;3)      Round up 3.23412 to 3 digits           3.235

ROUNDDOWN

DESCRIPTION

Round the number down by the specified number of digits

SYNTAX

ROUNDDOWN(number;digit)

• Number        Any number is required
• Digit              Definition of the number of digits

EXAMPLE

Formula                                     Description                                           Result

=ROUNDDOWN(3.23412;3)      Round down 3.23412 to 3 digits           3.234

INT

DESCRIPTION

Rounds a number down to the nearest integer

SYNTAX

INT(number)

• Number        Any number is required

EXAMPLE

Formula             Description                                                    Result

=INT(3.8)           Rounds 3.8 down to the nearest integer       3

NEG

DESCRIPTION

Rounds the number with its sign swapped

SYNTAX

NEG(number)

• Number        Any number is required

EXAMPLE

Formula                Description                                   Result

=NEG(-3.8)           Changes the sign of -3.8               3.8

ABS

DESCRIPTION

Returns the absolute value from the input

SYNTAX

ABS(number)

• Number        Any number is required

EXAMPLE

Formula                Description                                   Result

=ABS(-3.8)            Absolute value of -3.8                  3.8

TRUNC

DESCRIPTION

Truncates the input by the specified number of digits

SYNTAX

TRUNC(number;digits)

• Number        Any number is required
• Digit              The number of digits you want the number truncated by

EXAMPLE

Formula                          Description                                   Result

=TRUNC(3.84367;3)       Truncate 3.84367 to 3 digits        3.843

EXP

DESCRIPTION

Calculates the exponent of a number

SYNTAX

EXP(number)

• Number        Any number is required

EXAMPLE

Formula                  Description                          Result

=EXP(2.5)               Exponent of 2.5                    12.182494

LOG

Calculates the logarithm with base 10 for a number

SYNTAX

LOG(number)

• Number        Any number is required

EXAMPLE

Formula                  Description                                        Result

=LOG(100)             Logarithm to the base 10 of 100        2

LN

Calculates the natural logarithm of a number

SYNTAX

LN(number)

• Number        Any number is required

EXAMPLE

Formula                       Description                                       Result

=LN(7.389056)            Natural logarithm of 7.389056         2

LOG2

Calculates the logarithm with base 2 for a number

SYNTAX

LOG2(number)

• Number        Any number is required

EXAMPLE

Formula               Description                             Result

=LOG2(16)           Natural logarithm of 16         4

LOGB

Calculates the logarithm of a specified base for a number

SYNTAX

LOGB(number;base)

• Number        Any number is required
• Base              Any base number is required

EXAMPLE

Formula               Description                                            Result

=LOGB(81;3)        Logarithm to the base of 3 for 81         4

SQRT

Calculates the square root of a number

SYNTAX

SQRT(number)

• Number        Any number is required

EXAMPLE

Formula                 Description                          Result

=SQRT(81)             Square root of 81                9

CBRT

Calculates the cube root of a number

SYNTAX

CBRT(number)

• Number        Any number is required

EXAMPLE

Formula               Description                         Result

=CBRT(125)         Cube root of 125                5

SQRTPI

Calculates the square root of a number×Pi

SYNTAX

SQRTPI(number)

• Number        Any number is required

EXAMPLE

Formula               Description                         Result

=SQRTPI(2)          Square root of 2×Pi            2.506628

ROOT

Calculates the nth root of a number

SYNTAX

ROOT(number;root)

• Number        Any number is required
• Root             Any number is required

EXAMPLE

Formula                      Description                         Result

=ROOT(7776;5)          5th root of 7776                  6

PRODUCT

Calculates the product of all numbers in the selected data set

SYNTAX

PRODUCT(array)

• Array             An array of numbers is required

EXAMPLE

Formula                    Description                                       Result

=PRODUCT(a)          Product of the array of numbers      30

 Array (a) 3 5 2
FACT

Returns the factorial of the number

SYNTAX

FACT(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description                        Result

=FACT(5)          Factorial of 5 (5!)               30

RAND

Returns randomized number between 0 and 1

SYNTAX

RAND()

• Number             Any positive number is required

EXAMPLE

Formula            Description                                                         Result

=RAND()           Returns a random number between 0 and 1     0.71804

RANDB

Returns randomized number between two defined numbers

SYNTAX

RANDB(low;high)

• Low             Any number is required
• High            Any number is required

EXAMPLE

Formula                   Description                                                             Result

=RANDB(1;100)       Returns a random number between 1 and 100     56

SIN

Returns the sine of a number in radians

SYNTAX

SIN(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description            Result

=SIN(10)          Sine of 10               -0.544021

SIND

Returns the sine of a number in degrees

SYNTAX

SIND(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description            Result

=SIND(10)          Sine of 10              0.173648

COS

Returns the cosine of a number in radians

SYNTAX

COS(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description            Result

=COS(20)          Cosine of 20          0.408082

COSD

Returns the cosine of a number in radians

SYNTAX

COSD(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description            Result

=COSD(20)        Cosine of 20         0.939693

TAN

Returns the tangent of a number in radians

SYNTAX

TAN(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description            Result

=TAN(15)          Tangent of 15        -0.855993

TAND

Returns the tangent of a number in degrees

SYNTAX

TAND(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description            Result

=TAND(15)        Tangent of 15       0.267949

COSEC

Returns the cosecant of a number in radians

SYNTAX

COSEC(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description              Result

=COSEC(10)      Cosecant of 10        -1.838164

COSECD

Returns the cosecant of a number in degrees

SYNTAX

COSEC(number)

• Number             Any positive number is required

EXAMPLE

Formula               Description              Result

=COSECD(10)      Cosecant of 10        5.75877

SEC

Returns the secant of a number in radians

SYNTAX

SEC(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description              Result

=SEC(15)          Secant of 15             -1.31633

SECD

Returns the secant of a number in degrees

SYNTAX

SEC(number)

• Number             Any positive number is required

EXAMPLE

Formula            Description              Result

=SEC(15)          Secant of 15             1.035276

COTAN

Returns the cotangent of a number in radians

SYNTAX

COTAN(number)

• Number             Any positive number is required

EXAMPLE

Formula                 Description                    Result

=COTAN(10)         Cotangent of 10             1.542351

COTAND

Returns the cotangent of a number in degrees

SYNTAX

COTAND(number)

• Number             Any positive number is required

EXAMPLE

Formula                   Description                    Result

=COTAND(10)         Cotangent of 10             5.671282

ARCSIN

Returns the inverse sine of a number where the number is between -1 and+1

SYNTAX

ARCSIN(number)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                    Result

=ARCSIN(0.98)         Arcsin of 0.98                 1.370461

ARCSIND

Returns the inverse sine of a number where the number is between -1 and+1

SYNTAX

ARCSIND(number)

• Number             Any positive number is required

EXAMPLE

Formula                      Description                    Result

=ARCSIND(0.98)         Arcsin of 0.98                 78.521659

ARCCOS

Returns the inverse cosine of a number where the number is between -1 and+1

SYNTAX

ARCCOS(number)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                    Result

=ARCCOS(0.98)        Arccos of 0.98                0.200335

ARCCOSD

Returns the inverse cosine of a number where the number is between -1 and+1

SYNTAX

ARCCOSD(number)

• Number             Any positive number is required

EXAMPLE

Formula                       Description                    Result

=ARCCOSD(0.98)        Arccosd of 0.98              11.478341

ARCTAN

Returns the inverse tangent of a number

SYNTAX

ARCTAN(number)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                    Result

=ARCTAN(1.3)          Arctan of 1.3                 0.915101

ARCTAND

Returns the inverse tangent of a number

SYNTAX

ARCTAND(number)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                    Result

=ARCTAND(1.3)          Arctand of 1.3              52.431408

DEGREES

Converts the input from radians into degrees

SYNTAX

DEGREES(number)

• Number             Any positive number is required

EXAMPLE

Formula                          Description                                            Result

=DEGREES(1.5708)         Convert 1.5708 radians into degrees     90

Converts the input from radians into degrees

SYNTAX

• Number             Any positive number is required

EXAMPLE

Formula                    Description                                            Result

IF

If the condition is met, then return the value specified in the true, if it is false, it returns the value specified in the false section.

SYNTAX

IF(condition;true;false)

• Condition             Any positive number is required
• True result            This is the value you want inputted if the condition is met
• False result           This is the value you want inputted if the condition is not met

EXAMPLE

Formula                Description                                                     Result

=IF(4>0;Y;N)        If 4>0 is true, then give Y, otherwise give N   Y

COUNTIF

If the condition is met, count the number of cells that it is met.

SYNTAX

COUNTIF(a;condition)

• a                           Any array of numbers is required
• condition             Sets a condition such as a>1 so that each cell that has a value more than one is counted.

EXAMPLE

Formula                            Description                                                                                              Result

=COUNTIF(a;a>2)            Count the number of cells in the array that has a value more than 2     4

 1 3 5 2 4 6

SUMIF

If the condition is met, sum the numbers inside the cell where the condition is met.

SYNTAX

SUMIF(a;condition)

• a                           Any array of numbers is required
• condition             Sets a condition such as a>1 so that each number that has a value more than 1 is summed.

EXAMPLE

Formula                            Description                                                           Result

=SUMIF(a;a>2)           Sum the numbers that have values more than 2       18

 1 3 5 2 4 6

SUM

Returns the sum of all the numbers in the dataset

SYNTAX

SUM(array)

• Number              Any positive number is required

EXAMPLE

Formula         Description                             Result

=SUM(a)        Sum of all the numbers          15

 3 5 7
COUNT

Counts all the numbers in the dataset

SYNTAX

COUNT(array)

• Number              Any positive number is required

EXAMPLE

Formula            Description                                 Result

=COUNT(a)      Count all numbers in the array   3

 2 4 6
AVERAGE

Counts all the numbers in the dataset

SYNTAX

AVERAGE(array)

• Number              Any positive number is required

EXAMPLE

Formula            Description                                 Result

=COUNT(a)      Count all numbers in the array   3

 2 4 6
MIN

Returns the minimum of the dataset

SYNTAX

MINIMUM(array)

• Number              Any positive number is required

EXAMPLE

Formula         Description                                                    Result

=MIN(a)         Returns the minimum value in the array       3

 4 3 7
MAX

Returns the minimum of the dataset

SYNTAX

MAX(array)

• Number              Any positive number is required

EXAMPLE

Formula         Description                                                    Result

=MAX(a)        Returns the minimum value in the array       7

 4 3 7
SUML

Calculates each value as a cumulative sum to date

SYNTAX

SUML(array)

• Number              Any positive number is required

EXAMPLE

Formula          Description

=SUML(a)       Returns the cumulative sum to date

 Values Result 4 4 3 7 7 14
COUNTL

Calculates each value as a cumulative count to date

SYNTAX

COUNTL(array)

• Number              Any positive number is required

EXAMPLE

Formula          Description

=COUNTL(a)       Returns the cumulative sum to date

 Values Result 4 1 3 2 7 3

AVGL

Calculates each value as a cumulative average value to date

SYNTAX

AVGL(array)

• Number              Any positive number is required

EXAMPLE

Formula          Description

=AVGL(a)       Returns the cumulative average to date

 Values Result 4 4 3 3.5 7 4.667
MINL

Calculates each value as a cumulative minimum value to date

SYNTAX

MINL(array)

• Number              Any positive number is required

EXAMPLE

Formula          Description

=MINL(a)       Returns the cumulative minimum value to date

 Values Result 4 4 3 3 7 3
MAXL

Calculates each value as a cumulative maximum value to date

SYNTAX

MAXL(array)

• Number              Any positive number is required

EXAMPLE

Formula          Description

=MAXL(a)       Returns the cumulative minimum value to date

 Values Result 4 4 3 4 7 7
DIFF

Calculates each values as the difference to the previous value in the series

SYNTAX

DIFF(array)

• Number              Any positive number is required

EXAMPLE

Formula          Description

=DIFF(a)         Returns the difference to the previous value in the series

 Values Result 4 4 3 -1 7 4

DIFFN

Calculates each values as the difference to the next value in the series

SYNTAX

DIFFN(array)

• Number              Any number is required

EXAMPLE

Formula            Description

=DIFFN(a)         Returns the difference to the next value in the series

 Values Result 4 1 3 -4 7 -2 9 -2 11 11

DIFFF

Calculates each values as the difference to the first value in the series

SYNTAX

DIFFF(array)

• Number              Any number is required

EXAMPLE

Formula            Description

=DIFFF(a)         Returns the difference to the first value in the series

 Values Result 4 0 3 -1 7 3 9 5 11 7
DIFFL

Calculates each values as the difference to the last value in the series

SYNTAX

DIFFL(array)

• Number              Any number is required

EXAMPLE

Formula            Description

=DIFFL(a)         Returns the difference to the last value in the series

 Values Result 4 -7 3 -8 7 -4 9 -2 11 0
SUMD

Calculates each value as the difference to the total

SYNTAX

SUMD(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMD = Value-Sum of all values

EXAMPLE

Formula          Description

=SUMD(a)         Returns each value as a difference of the total

 Values Result 4 10 3 11 7 7

AVGD

Calculates each value as the difference to the average

SYNTAX

AVGD(array)

• Number              Any positive number is required

NOTE:

• Formula: AVGD = Value-Average of all values

EXAMPLE

Formula          Description

=AVGD(a)         Returns each value as a difference of the average

 Values Result 4 -0.6667 3 -1.6667 7 2.3333

MIND

Calculates each value as the difference to the minimum value

SYNTAX

MIND(array)

• Number              Any positive number is required

NOTE:

• Formula: MIND = Value-Minimum value

EXAMPLE

Formula          Description

=MIND(a)         Returns each value as a difference of the minimum value

 Values Result 4 1 3 0 7 4
MAXD

Calculates each value as the difference to the maximum value

SYNTAX

MAXD(array)

• Number              Any positive number is required

NOTE:

• Formula: MAXD = Value-Maximum value

EXAMPLE

Formula          Description

=MAXD(a)         Returns each value as a difference of the maximum value

 Values Result 4 -3 3 -4 7 0

SUMX

Calculates each value as a fraction of the Total

SYNTAX

SUMX(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMX = Value/Sum of all values

EXAMPLE

Formula          Description

=SUMX(a)       Calculates each value as a fraction of the Total

 Values Result 10 0.2 25 0.5 15 0.3
SUMP

Calculates each value as a percentage of the Total

SYNTAX

SUMP(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMP = (Value/Sum of all values×100)

EXAMPLE

Formula          Description

=SUMP(a)       Calculates each value as a percentage of the Total

 Values Result 10 20 25 50 15 30
SUMLX

Calculates each value as the cumulative total to date as a fraction of the Total

SYNTAX

SUMLX(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMLX = SUML(a)/SUM(a)

EXAMPLE

Formula          Description

=SUMLX(a)     Calculates each value as the cumulative total to date as a fraction of the Total

 Values Result 10 0.2 25 0.7 15 1
SUMLP

Calculates each value as the cumulative total to date as a percentage of the Total

SYNTAX

SUMLP(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMLP = (SUML(a)/SUM(a))×100

EXAMPLE

Formula          Description

=SUMLP(a)     Calculates each value as the cumulative total to date as a percentage of the Total

 Values Result 10 20 25 70 15 100

SUMDX

Calculates each value as the difference to the Total as a fraction of the Total

SYNTAX

SUMDX(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMDX = (a-SUM(a))/SUM(a)

EXAMPLE

Formula          Description

=SUMDX(a)     Calculates each value as the difference to the Total as a fraction of the Total

 Values Result 10 0.8 25 0.5 15 0.7
SUMDP

Calculates each value as the difference to the Total as a percentage of the Total

SYNTAX

SUMDP(array)

• Number              Any positive number is required

NOTE:

• Formula: SUMDP = ((a-SUM(a))/SUM(a))×100

EXAMPLE

Formula          Description

=SUMDP(a)     Calculates each value as the difference to the Total as a percentage of the Total

 Values Result 10 80 25 50 15 70

DIFFSUMX

Calculates each value as a the difference to previous value as a fraction of the Total

SYNTAX

DIFFSUMX(array)

• Number              Any positive number is required

NOTE:

• Formula: DIFFSUMX = DIFF(a)/SUM(a)

EXAMPLE

Formula          Description

=SUMDP(a)     Subtracts each value from the previous value and divides it by the Total. The first value provided is subtracted from 0.

 Values Result 10 0.222 15 0.111 20 0.111
DIFFSUMP

Calculates each value as the difference to previous value as a percentage of the Total

SYNTAX

DIFFSUMP(array)

• Number              Any positive number is required

NOTE:

• Formula: DIFFSUMP = (DIFF(a)/SUM(a)) ×100

EXAMPLE

Formula          Description

=DIFFSUMP(a)     Subtracts each value from the previous value and divides it by the Total. This result is then converted into a percentage. The first value provided is subtracted from 0.

 Values Result 10 22.222 15 11.111 20 11.111
MEAN

Returns the average (arithmetic mean) of an array of numbers

SYNTAX

MEAN(array)

• Number              Any positive number is required

NOTE:

• Formula: MEAN =

EXAMPLE

Formula               Description                                                                                          Result

= MEAN(a)         Returns the average (arithmetic mean) of an array of numbers         15

 Values 10 15 20
MEDIAN

Returns the number in the middle of an ordered data set

SYNTAX

MEDIAN(array)

• Number           Any positive number is required

EXAMPLE

Formula                  Description                                                                           Result

= MEDIAN(a)         Returns the number in the middle of an ordered array       20

 Values 10 28 29 15 20
MODESNGL

Returns the lowest most frequently occurring number in an array

SYNTAX

MODESNGL(array)

• Number              Any positive number is required

EXAMPLE

Formula                    Description                                                                                          Result

= MODESNGL(a)     Returns the lowest most frequently occurring number in an array    2

 Values 2 1 2 3 2

MODE

Returns an array of the most frequently occurring numbers in a set of numbers

SYNTAX

MODEMULT(array)

• Number              Any positive number is required

EXAMPLE

Formula           Description                                                                                                 Result

= MODE(a)     Returns an array of the most frequently occurring numbers in an array    2, 3

 Values 2 1 2 3 3

MODMEAN

Returns the Modified mean, the mean without MIN and MAX values

SYNTAX

MODMEAN(array)

• Number              Any positive number is required

EXAMPLE

Formula                  Description                                                            Result

= MODMEAN(a)     Returns the modified mean of 2, 3 and 4             3

 Values 1 2 3 4 10

TRIMNMEAN

Returns a trimmed mean, a mean without the largest and smallest n values

SYNTAX

TRIMNMEAN(array;n-values)

• Number              Any positive number is required
• n-values              Any positive number is required

EXAMPLE

Formula                       Description                                            Result

= TRIMNMEAN(a;1)   Returns the mean of 2, 3 and 4             3

 Values 1 2 3 4 10
TRIMPMEAN

Returns a trimmed mean, a mean without the largest and smallest k% of values

SYNTAX

TRIMPMEAN(array;k-percent)

• Number             Any positive number is required
• k-percent           Any positive number is required

EXAMPLE

Formula                        Description                                            Result

= TRIMPMEAN(a;20)   Returns the mean of 2, 3 and 4             3

 Values 1 2 3 4 10

WINSMEAN

Returns a Winsorized mean, a mean with the smallest and largest k% of values replaced with new-min, new-max

SYNTAX

WINSMEAN(array;k-percent)

• Number             Any positive number is required
• k-percent           Any positive number is required

EXAMPLE

Formula                        Description                                                  Result

= WINSMEAN(a;20)    Returns the mean of 2, 2, 3, 4 and 4             3

 Values 1 2 3 4 10
IQM

Interquartile mean (or midmean), a mean based on the truncated mean of the interquartile range

SYNTAX

IQM(array)

• Number             Any positive number is required

EXAMPLE

Formula                 Description                                                  Result

= IQM(array)         Returns the mean of 2, 2, 3, 4 and 4            4.5

 Values 15 2 3 4 5 6 7 100

GENMEAN

This is the generalized mean or power mean.

SYNTAX

GENMEAN(array;order)

• Number             Any positive number is required

Note

If k is a positive or negative number, and a is an array of positive real numbers, then the generalized mean will take the form of

EXAMPLE

Formula                    Description                                               Result

= GENMEAN(a;2)     Generalized mean of 1, 2, 3, 4                 2.738613

 Values 1 2 3 4

This is the quadratic mean or root mean square.

SYNTAX

• Number             Any positive number is required

Note

Formula

EXAMPLE

Formula                      Description                                           Result

 Values 1 2 3 4
CUBMEAN

This is the cubic mean.

SYNTAX

CUBMEAN(array)

• Number             Any positive number is required

Note

Formula

EXAMPLE

Formula                     Description                                    Result

= CUBMEAN(a)        Cubic mean of 1, 2, 3, 4                 2.924018

 Values 1 2 3 4
GEOMEAN

This is the geometric mean.

SYNTAX

GEOMEAN(array)

• Number             Any positive number is required

Note

Formula

EXAMPLE

Formula                     Description                                    Result

= GEOMEAN(a)        Geometric mean of 1, 2, 3, 4          2.213364

 Values 1 2 3 4
HARMEAN

This is the harmonic mean.

SYNTAX

HARMEAN(array)

• Number             Any positive number is required

Note

Formula

EXAMPLE

Formula                     Description                                    Result

= HARMEAN(a)        Harmonic mean of 1, 2, 3, 4          1.920

 Values 1 2 3 4
RAND

This returns a random number between 0 and 1.

SYNTAX

RAND()

EXAMPLE

Formula                    Description                                                           Result

= RAND()                Return a random number between 0 and 1         0.294385

RANDB

This returns a random number between two specified numbers.

SYNTAX

RANDB(low; high)

• Low             Any number is required
• High            Any number is required

EXAMPLE

Formula                            Description                                                                                       Result

= RANDB(1; 20)        Return a random whole number between the values specified             7

REMDUP

This returns an array with the duplicates removed

SYNTAX

REMDUP(a)

• a                  Any array of numbers is required

EXAMPLE

Formula                     Description                                                                Result

= REMDUP(a)           Return the array with the duplicates removed          {1;2;3}

 Values 1 2 2 3
REMX

This returns an array with a specific number removed from all the values

SYNTAX

REMX(a)

• a                          Any array of numbers is required
• to be removed    The number to be removed from the array

EXAMPLE

Formula                     Description                                                 Result

= REMX(a;2)             Return the array with 2 removed                {1;3}

 Values 1 2 2 3
SORT

This sorts the numbers in the array from smallest to largest

SYNTAX

SORT(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                 Description                                                        Result

= SORT(a)             Sorts the numbers from smallest to largest      {1;2;3;4}

 Values 4 2 1 3

SORTD

This sorts the numbers in the array from largest to smallest

SYNTAX

SORTD(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                   Description                                                         Result

= SORTD(a)             Sorts the numbers from largest to smallest      {4;3;2;1}

 Values 4 2 1 3
REVERSE

This reverses the order of an array of numbers

SYNTAX

REVERSE(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                       Description                                                         Result

= REVERSE(a)             Reverses the order of an array of numbers      {3;1;2;4}

 Values 4 2 1 3
RANDOMIZE

This randomizes the order of an array of numbers

SYNTAX

RANDOMIZE(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                          Description                                             Result

= RANDOMIZE(a)          Randomizes an array of numbers          {2;4;3;1}

 Values 4 2 1 3
SWITCH

This switches the order of values in a series from being 'read in columns' to 'read in rows'

SYNTAX

SWITCH(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                 Description                                      Result

= SWITCH(a)         Switch the following array              {1:4:7;2:5:8;3:6:9}

 1 4 7 2 5 8 3 6 9
FIND

This finds the k-th value in an array

SYNTAX

FIND(a;k)

• a                          Any array of numbers is required

EXAMPLE

Formula                 Description                                                        Result

= FIND(a;3)          Find the 3rd number in the following array       18

 10 14 18 22
SMALL

This finds the k-th smallest value in an array

SYNTAX

SMALL(a;k)

• a                          Any array of numbers is required
• k                          Any positive number is required

EXAMPLE

Formula                    Description                                                                       Result

= SMALL (a;2)          Find the 2nd smallest number in the following array       14

 10 14 18 22
LARGE

This finds the k-th largest value in an array

SYNTAX

LARGE(a;k)

• a                          Any array of numbers is required
• k                          Any positive number is required

EXAMPLE

Formula                    Description                                                                       Result

= LARGE (a;2)          Find the 2nd largest number in the following array       18

 10 14 18 22
RANK

This returns the rank of each number in an array. If more than one numbers has the same rank, the top one is taken.

SYNTAX

RANK(a;order)

• a                          Any array of numbers is required
• order                   Value=1 (ascending); value=0 (descending)

EXAMPLE

Formula                    Description                                             Result

= RANK (a;1)           Ranks each number in an array              {2;3;1;3}

 0 3 -5 3
RANKAVG

This returns the rank of each number in an array. If more than one numbers has the same rank, the average is taken.

SYNTAX

RANKAVG(a;order)

• a                          Any array of numbers is required
• order                   Value=1 (ascending); value=0 (descending)

EXAMPLE

Formula                           Description                                             Result

= RANKAVG (a;1)           Ranks each number in an array              {2;3.5;1;3.5}

 0 3 -5 3
RANKN

This returns the rank of a number in an array. If more than one number has the same rank, the top one is taken.

SYNTAX

RANKN(a;x;order)

• a                          Any array of numbers is required
• x                          Any number in the array
• order                   Value=1 (ascending); value=0 (descending)

EXAMPLE

Formula                       Description                                              Result

= RANKN (a;3;0)          Ranks each number in an array              1

 0 3 -5 3
RANKNAVG

This returns the rank of a number in an array. If more than one number has the same rank, the average is taken.

SYNTAX

RANKNAVG(a;x;order)

• a                          Any array of numbers is required
• x                          Any number in the array
• order                   Value=1 (ascending); value=0 (descending)

EXAMPLE

Formula                           Description                                              Result

= RANKNAVG (a;3;0)      Ranks each number in an array               1.5

 0 3 -5 3
FILTER

This removes every n-th point from a data series.

SYNTAX

FILTER(a;n-values)

• a                          Any array of numbers is required
• n-values              Any positive number is required

EXAMPLE

Formula                           Description                                                       Result

= FILTER (a; 2)                Remove every second point from an array         {0;-5;6}

 0 3 -5 3 6 2
TRIMDATN

This returns a data set trimmed top and bottom by n values.

SYNTAX

TRIMDATN(a;n-values)

• a                          Any array of numbers is required
• n-values              Any positive number is required

EXAMPLE

Formula                          Description                                                                                        Result

= TRIMDATN (a; 2)        Remove the top and bottom two number from the data set           {3;2}

 0 3 -5 3 6 2

TRIMDATP

This returns a data set trimmed top and bottom by k percent.

SYNTAX

TRIMDATP(a;k-percent)

• a                          Any array of numbers is required
• k-percent            Any positive number is required

EXAMPLE

Formula                       Description                                                                                                            Result

= TRIMDATP (a; 20)    Remove the top and bottom twenty percent of numbers from the data set       {0;3;3}

 0 3 -5 3 6
IQDAT

This returns a truncated data set using the values in the inter quartile range.

SYNTAX

IQDAT(a)

• a                          Any array of numbers is required

EXAMPLE

Formula              Description                                                                                        Result

= IQDAT (a)       Truncate the data set using values in the inter quartile range           {3;3;1;4}

 0 3 -5 3 6 1 4 10
WINSOR

This returns a data set with the top and bottom k% of values replaced with a new-min and a new-max

SYNTAX

WINSOR(a; k-percent)

• a                          Any array of numbers is required
• k-percent             Any positive number is required

EXAMPLE

Formula                                Description                                                                                        Result

= WINSOR (a;k-percent)     Returns a data set with the top and bottom k% of values                {1;3;1;3;4;1;4;4}

replaced with a new-max and a new min

 0 3 -5 3 6 1 4 10
NORMR

This normalizes the series by dividing each data point by the range

SYNTAX

NORMR(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                     Description                                                         Result

= NORMR(a)             Divides each data point by the range               {0 ; 0.214286 ; -0.357143 ; 0.642857 ; 0.428571}

 0 3 -5 9 6
NORM

This normalizes the series to lie between 0 and 1

SYNTAX

NORM(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                    Description                                                               Result

= NORM(a)             Divides each data point to lie between 0 and 1       {0 ; 0.214286 ; -0.357143 ; 0.642857 ; 0.428571}

 0 3 -5 9 6
NORML

This normalizes the series to lie between 0 and 1

SYNTAX

NORML(a;actual_min;actual_max)

• a                          Any array of numbers is required
• actual_min           The minimum number in the array
• actual_max           The maximum number in the array

EXAMPLE

Formula                              Description                                                                     Result

= NORML(a;0;0.775)         Divides each data point to lie between 0 and 1       {0 : 0.129032 : 0.387097 : 0.645161 1}

 0 0.1 0.3 0.5 0.775

NORMA

This normalizes data to user-defined new min and max when data contains desired min and max values

SYNTAX

NORMA(a;new_min;new_max)

• a                          Any array of numbers is required
• new_min              The new user defined minimum number
• new_max             The new user defined maximum number

EXAMPLE

Formula                              Description                                                                                                          Result

= NORMA(a;-1;2)         Normalizes the data to user-defined new minimum (-1) and new maximum (2)      {-1 : -0.612903 : 0.16129 : 0.935484 : 2}

 0 0.1 0.3 0.5 0.775

NORMB

This normalizes data from original scale (old_min to old_max) to a new scale (new_min to new-max)

SYNTAX

NORMB(a; old_min; old_max; new_min; new_max)

• a                          Any array of numbers is required
• old_min               The old minimum number
• old_max               The old maximum number
• new_min              The new user defined minimum number
• new_max             The new user defined maximum number

EXAMPLE

Formula                         Description                                                                                                                Result

= NORMB(a;1;10)         Normalizes the data from the old scale to a new user-defined scale of 1 to 10      {1 2.16129 4.483871 6.806452 10}

 0 0.1 0.3 0.5 0.775

RANGE

This returns the range of the series

SYNTAX

RANGE(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                    Description                                                Result

= RANGE(a)             Returns the range of the array below       14

 0 3 -5 9 6

MIDRANGE

This returns the midrange of the series

SYNTAX

MIDRANGE(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                           Description                                                      Result

= MIDRANGE(a)             Returns the midrange of the array below       7

 0 3 -5 9 6

QUARTILE

This returns the nth quartile of an array

QUARTILE(a;quartile)

• a                          Any array of numbers is required
• Quartile               Any number between 1 an 3

EXAMPLE

Formula                          Description                                                                Result

= QUARTILE(a;1)            Return the first quartile for the array below              -2.5

 0 3 -5 9 6

Q1

This returns the first quartile (25th percentile) of the series

SYNTAX

Q1(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                    Description                                                           Result

= Q1(a)                   Returns the first quartile for the array below        -2.5

 0 3 -5 9 6

Q2

This returns the second quartile (50th percentile) of the series

SYNTAX

Q2(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                    Description                                                                Result

= Q2(a)                   Returns the second quartile for the array below        3

 0 3 -5 9 6

Q3

This returns the third quartile (75th percentile) of the series

SYNTAX

Q3(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                    Description                                                                Result

= Q3(a)                   Returns the third quartile for the array below           7.5

 0 3 -5 9 6

IQR

This returns the inter-quartile range (Q3-Q1)

SYNTAX

IQR(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                    Description                                                                Result

= IQR(a)                   Returns the inter-quartile for the array below           10

 0 3 -5 9 6

FENCEL

This returns the lower fence value for an array

SYNTAX

FENCEL(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                          Description                                                              Result

= FENCEL(a)                   Returns the lower fence value for an array            -17.5

 0 3 -5 9 6

FENCEU

This returns the upper fence value for an array

SYNTAX

FENCEU(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                            Description                                                              Result

= FENCEU(a)                   Returns the upper fence value for an array             22.5

 0 3 -5 9 6

OUTLIERS

This returns the outlier(s) in an array

SYNTAX

OUTLIERS(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                            Description                                                Result

= OUTLIERS(a)                   Returns the outliers for an array             Empty set

 0 3 -5 9 6

BOXMIN

This returns the smallest value in the series that is not an outlier

SYNTAX

BOXMIN(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                            Description                                                                                                 Result

= BOXMIN(a)                   Return the smallest value in the following array that is not an outlier      -5

 0 3 -5 9 6

BOXMAX

This returns the largest value in the series that is not an outlier

BOXMAX(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                            Description                                                                                               Result

= BOXMAX(a)                  Return the smallest value in the following array that is not an outlier    9

 0 3 -5 9 6

MIDHINGE

This returns the average of the first and third quartiles

MIDHINGE(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                               Description                                                                   Result

= MIDHINGE(a)                  Return the average of the first and third quartiles       2.5

 0 3 -5 9 6

TRIMEAN

This returns the average of the first and third quartile and median

TRIMEAN(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                              Description                                                                                      Result

= TRIMEAN(a)                  Return the average of the first and third quartiles and median       2.75

 0 3 -5 9 6

DECILE

This returns the nth decile of an array

DECILE(a;decile)

• a                          Any array of numbers is required
• Decile                  Any number between 1 an 9

EXAMPLE

Formula                          Description                                                              Result

= DECILE(a;1)                 Return the first decile for the array below              0.3

 0 3 6 9 12 15 18 21 24 27

D1

This returns the first decile of an array

D1(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                 Description                                                              Result

= D1(a)                 Return the first decile for the array below              0.3

 0 3 6 9 12 15 18 21 24 27

D9

This returns the ninth decile of an array

D9(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                 Description                                                              Result

= D9(a)                 Return the ninth decile for the array below            26.7

 0 3 6 9 12 15 18 21 24 27

IDR

This returns the inter-decile range of an array (D9-D1)

IDR(a)

• a                          Any array of numbers is required

EXAMPLE

Formula                 Description                                                                       Result

= IDR(a)                Return the inter-decile range for the array below            26.4

 0 3 6 9 12 15 18 21 24 27

PERCENTILE

This returns the nth percentile of an array

PERCENTILE(a;percentile)

• a                                Any array of numbers is required
• Percentile                  Any number between 1 an 99

EXAMPLE

Formula                                       Description                                                                                                                          Result

= PERCENTILE(a;1)                 Return the first percentile for the array containing every number between 1-150             1.51

= PERCENTILE(a;89)               Return the 89th percentile for the array containing every number between 1-150            134.39

VARP

This calculates the variance based on an entire population

SYNTAX

VARP(a)

• a                          Any array of numbers is required

Note

Formula

EXAMPLE

Formula                     Description                                                            Result

= VARP (a)               Calculate the variance of the dataset below          16.9375

 0 3 -5 3 6 1 4 10

VARS

This calculates the variance based on a sample

SYNTAX

VARS(a)

• a                          Any array of numbers is required

Note

Formula

EXAMPLE

Formula                     Description                                                            Result

= VARS (a)               Calculate the variance of the dataset below          19.357143

 0 3 -5 3 6 1 4 10
SDEVP

This calculates the standard deviation based on the population

SYNTAX

SDEVP(a)

• a                          Any array of numbers is required

Note

Formula

EXAMPLE

Formula                     Description                                                            Result

= SDEVP (a)               Calculate the standard deviation of the dataset below          4.115519

 0 3 -5 3 6 1 4 10

SDEVS

This calculates the standard deviation based on a sample

SYNTAX

SDEVS(a)

• a                          Any array of numbers is required

Note

Formula

EXAMPLE

Formula                     Description                                                                             Result

= SDEVS  (a)             Calculate the standard deviation of the dataset below          4.399675

 0 3 -5 3 6 1 4 10

SUMABS

This calculates the sum of absolute values for a sample

SYNTAX

SUMABS(a)

• a                          Any array of numbers is required
EXAMPLE

Formula                     Description                                                                             Result

= SUMABS  (a)          Calculate the sum of absolute values standard deviation of the dataset below          4.399675

 0 3 -5 3 6 1 4 10

SUMSQ

This calculates the sum of squares for a sample

SYNTAX

SUMSQ(a)

• a                          Any array of numbers is required
EXAMPLE

Formula                    Description                                                         Result

= SUMSQ(a)            Calculate the sum of squared values                 196

 0 3 -5 3 6 1 4 10

DEVSQ

This calculates the sum of squares for a sample

SYNTAX

SUMSQ(a)

• a                          Any array of numbers is required
EXAMPLE

Formula                    Description                                                                                                                 Result

= SUMSQ(a)            Calculate the sum of absolute values standard deviation of the dataset below          5.25

 0 3 -5 3 6 1 4 10
AVEDEV

This calculates the average absolute deviation for a sample

SYNTAX

AVEDEV(a)

• a                          Any array of numbers is required
EXAMPLE

Formula                    Description                                                                              Result

= AVEDEV(a)            Calculate the average absolute deviation for a sample          3.0625

 0 3 -5 3 6 1 4 10

ABSDEV

This calculates the absolute deviation for a sample

SYNTAX

ABSDEV(a)

• a                          Any array of numbers is required
EXAMPLE

Formula                    Description                                                                 Result

= ABSDEV(a)            Calculate the absolute deviation for a sample          24.5

 0 3 -5 3 6 1 4 10

This calculates the median absolute deviation for a sample

SYNTAX

• a                          Any array of numbers is required
EXAMPLE

Formula                Description                                                                            Result

= MAD(a)            Calculate the median absolute deviation for a sample          2.5

 0 3 -5 3 6 1 4 10
RANGE

This returns the range of the series.

SYNTAX

RANGE(array)

• Number             Any positive number is required

Note

Formula: RANGE = Max(a)-Min(a)

EXAMPLE

Formula                 Description                                Result

= RANGE(a)          Range between 1 and 7            6

 Values 1 2 4 7

MIDRANGE

This returns the midrange of the series.

SYNTAX

MIDRANGE(array)

• Number             Any positive number is required

Note

Formula: MIDRANGE = (Max(a)-Min(a))/2

EXAMPLE

Formula                 Description                                Result

= MIDRANGE(a)   Midrange between 1 and 7       3

 Values 1 2 4 7

IQR

This returns the Inter-Quartile Range of the series.

SYNTAX

IQR(array)

• Number             Any positive number is required

Note

Formula: IQR = Q3-Q1

EXAMPLE

Formula          Description                         Result

= IQR(a)          IQR between 1 and 7         5

 Values 1 2 4 7

SEMP

This is the standard error of the mean (SEM) for the whole population

SYNTAX

SEMP(array)

• Number             Any positive number is required

EXAMPLE

Formula             Description                                   Result

= SEMP(a)        Standard error of the mean          1.145644

 Values 1 2 4 7

SEMS

This is the standard error of the mean (SEM) for the sample

SYNTAX

SEMS(array)

• Number             Any positive number is required

EXAMPLE

Formula             Description                                   Result

= SEMS(a)        Standard error of the mean          1.322876

 Values 1 2 4 7

RSEP

This is the relative standard error of the mean for the whole population

SYNTAX

RSEP(array)

• Number             Any positive number is required

EXAMPLE

Formula             Description                                            Result

= RSEP(a)          Relative standard error of the mean     32.732684

 Values 1 2 4 7

RSES

This is the relative standard error of the mean for the sample

SYNTAX

RSEP(array)

• Number             Any positive number is required

EXAMPLE

Formula            Description                                          Result

= RSES(a)        Relative standard error of the mean    37.796447

 Values 1 2 4 7

DISPINP

This is the index of dispersion for the whole population

SYNTAX

DISPINP(array)

• Number             Any positive number is required

EXAMPLE

Formula             Description                      Result

= DISPINP(a)          Index of dispersion         1.5

 Values 1 2 4 7

DISPINS

This is the index of dispersion for the sample

SYNTAX

DISPINS(array)

• Number             Any positive number is required

EXAMPLE

Formula                Description                      Result

= DISPINS(a)        Index of dispersion         2.0

 Values 1 2 4 7

CVP

This is the coefficient of variation for the population

SYNTAX

CVP(array)

• Number             Any positive number is required

EXAMPLE

Formula          Description                                                      Result

= CVP(a)        Coefficient of variation of the population       0.654654

 Values 1 2 4 7

CVS

This is the coefficient of variation for the sample

SYNTAX

CVS(array)

• Number             Any positive number is required

EXAMPLE

Formula      Description                                             Result

= CVS(a)    Coefficient of variation of the sample    0.755929

 Values 1 2 4 7

SNRP

This is the signal-to-noise ratio for the population

SYNTAX

SNRP(array)

• Number             Any positive number is required

EXAMPLE

Formula            Description                                                     Result

= SNRP(a)        Signal-to-noise ratio for the population       1.527525

 Values 1 2 4 7

SNRS

This is the signal-to-noise ratio for the sample

SYNTAX

SNRS(array)

• Number             Any positive number is required

EXAMPLE

Formula        Description                                             Result

= SNRS(a)    Signal-to-noise ratio for the sample      1.322876

 Values 1 2 4 7

ZSCOREP

This is the Z-score for the population

SYNTAX

ZSCORP(array)

• Number             Any positive number is required

Description

= ZSCORP(a)        Return the z-score for the values 1, 2, 4, 7

 Values Result 1 -1.0910894 2 0.6546536 4 0.2182178 7 1.527552

TSCORES

T-score scaling

SYNTAX

TSCORES(array)

• Number             Any positive number is required

EXAMPLE

Formula                Description

= TSCORES(a)      Return the t-score for the values 1, 2, 4, 7

 Values Result 1 -1.889822 2 -1.133893 4 0.377964 7 2.645751

Moment

Returns the k-th moment of an array {a} about m

SYNTAX

MOMENT(array;k;m)

• Number             Any array of numbers is required
• k                        Any number is required
• m                       Any number is required

EXAMPLE

Formula                      Description                                                            Result

= Moment(a;2;2)       Return the k-th moment of a array about m         7.5

 Values 1 2 4 7

CENMOM

Returns the k-th moment of an array {a} about the mean

SYNTAX

CENMOM(array)

• Number             Any positive number is required

EXAMPLE

Formula                     Description                                                                                  Result

= CENMOM(a;2)       Return the 2nd moment of an array {a} about the mean            5.25

 Values 1 2 4 7

CENMOM2

Returns the 2nd central moment of an array {a}

SYNTAX

CENMOM2(array)

• Number             Any positive number is required

EXAMPLE

Formula                     Description                                                    Result

= CENMOM2(a)       Return the 2nd moment of an array {a}        5.25

 Values 1 2 4 7

CENMOM3

Returns the 3rd central moment of an array {a}

SYNTAX

CENMOM3(array)

• Number             Any positive number is required

EXAMPLE

Formula                     Description                                                     Result

= CENMOM3(a)       Return the 3rd moment of an array {a}           6

 Values 1 2 4 7

CENMOM4

Returns the 4th central moment of an array {a}

SYNTAX

CENMOM4(array)

• Number             Any positive number is required

EXAMPLE

Formula                     Description                                                   Result

= CENMOM4(a)       Return the 4th moment of an array {a}        48.5625

 Values 1 2 4 7

STMOMP

Standardized moment. The normalized k-th central moment based on a population

SYNTAX

STMOMP(array;k)

• Number             Any positive number is required
• k                        Any number is required

EXAMPLE

Formula                         Description                                                                             Result

= STMOMP(a;3)           Standardized moment for a population                                 0.498784

 Values 1 2 4 7

STMOMS

Standardized moment. The normalized k-th central moment based on a sample

SYNTAX

STMOMS(array;k)

• Number             An array of numbers is required
• k                        Any number is required

EXAMPLE

Formula                         Description                                                     Result

= STMOMS(a;3)            Standardized moment for a sample              0.32397

 Values 1 2 4 7

SKEWP

Returns the skewness of a distribution based on a population

SYNTAX

SKEWP(array)

• Number             Any positive number is required

EXAMPLE

Formula                   Description                                                                                          Result

= SKEWP(a)            Return the skewness of a distribution based on a population           0.498784

 Values 1 2 4 7

SKEWS

Returns the skewness of a distribution based on a sample

SYNTAX

SKEWS(array)

• Number             Any positive number is required

EXAMPLE

Formula                   Description                                                                                 Result

= SKEWS(a)            Return the skewness of a distribution based on a sample         0.863919

 Values 1 2 4 7

KURTP

Returns the population kurtosis

SYNTAX

KURTP(array)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                                                                          Result

= KURTP (a)             Return the population kurtosis for the array {1,2,4,7}         1.761905

 Values 1 2 4 7

KURTS

Returns the sample kurtosis

SYNTAX

KURTS(array)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                                                                     Result

= KURTS (a)             Return the sample kurtosis for the array {1,2,4,7}          13.214286

 Values 1 2 4 7

EXKURTP

Returns the excess population kurtosis

SYNTAX

EXKURTP(array)

• Number             Any positive number is required

EXAMPLE

Formula                     Description                                                       Result

= EXKURTP (a)          Returns the excess population kurtosis           -1.238095

 Values 1 2 4 7

EXKURTS

Returns the excess sample kurtosis

SYNTAX

EXKURTS(array)

• Number             Any positive number is required

EXAMPLE

Formula                    Description                                                                                   Result

= EXKURTS (a)        Returns the excess sample kurtosis for the array {1,2,4,7}            -0.285714

 Values 1 2 4 7

Frequency

Returns a frequency table. The first set of data is the frequency the number occurs in the data set. The second column is the cumulative frequency.

SYNTAX

FREQUENCY(array)

• Array             Any array of numbers is required

EXAMPLE

Formula                        Description                                                                                                                 Result

= FREQUENCY (a)        Returns the frequency and cumulative frequency for the array {1,2,3,1,1,3,3,4}        See table below

 FREQUENCY(a) 1 3 3 2 1 4 3 3 7 4 1 8

REP

Returns a report containing the SUM, AVERAGE, COUNT, MIN and MAX of an array

SYNTAX

REP(array)

• Array             Any array of numbers

EXAMPLE

Formula                   Description

= REP(a)                  Returns the SUM(a), AVERAGE(a), COUNT(a), MIN(a), MAX(a)

 Array Result 1 SUM(a)               = 24 2 AVERAGE(a)       = 4.8 4 COUNT(a)          = 5 7 MIN(a)               = 1 10 MAX(a)              = 10

REPFIVE

Returns a report containing the MIN, Q1, MEDIAN, Q3 and MAX of an array

SYNTAX

REPFIVE(array)

• Array             Any array of numbers

EXAMPLE

Formula                   Description

= REPFIVE(a)           Returns the MIN(a), Q1(a), MEDIAN(a), Q3(a), MAX(a)

 Array Result 1 MIN(a)               = 1 2 Q1(a)                 = 1.5 4 MEDIAN(a)        = 4 7 Q3(a)                 = 8.5 10 MAX(a)              = 10

REPSEVEN

Returns a report containing the P2, P9, Q1, MEDIAN, P91 and P98 of an array

SYNTAX

REPSEVEN(array)

• Array             Any array of numbers

EXAMPLE

Formula                       Description

= REPSEVEN(a)           Returns the P2(a), P9(a), Q1,(a), MEDIAN(a), P91(a), P98 (a)

 Array Result 1 P2(a)               = Too few datapoints to calculate 2 P9(a)               = Too few datapoints to calculate 4 Q1(a)               = 2 6 MEDIAN(a)      = 6 7 Q3(a)               = 10 10 P91                  = Too few datapoints to calculate 12 P98                  = Too few datapoints to calculate

REPBOWLEY

Returns a report containing the MIN, D1, Q1, MEDIAN, Q3, D9 and MAX of an array

SYNTAX

REPBOWLEY(array)

• Array             Any array of numbers

EXAMPLE

Formula                          Description

= REPBOWLEY(a)           Returns the MIN(a), D1(a), Q1(a), MEDIAN(a), Q3(a), D9(a) and  MAX(a)

 Array Result 1 MIN(a)               = -4 2 D1(a)                 = -3.25 4 Q1(a)                 = 1.25 7 MEDIAN(a)        = 6.5 10 Q3(a)                 = 12.75 12 D9                     = 12.3 6 MAX                  = 24 13 15 24 -4 -7

REPBOX

Returns a report containing the FENCEL, BOXMIN, Q1, MEDIAN, Q3, IQR, BOXMAX and FENCEU of an array

SYNTAX

REPBOX(array)

• Array             Any array of numbers

EXAMPLE

Formula                          Description

= REPBOX(a)           Returns the FENCEL(a), BOXMIN(a), Q1(a), MEDIAN(a), Q3(a), IQR(a), BOXMAX(a), and FENCEU(a)

 Array Result 1 FENCEL(a)            = -0.80625 2 BOXMIN(a)          = -4 4 Q1(a)                   = -1.125 7 MEDIAN(a)          = 0.56 -4 Q3(a)                   = 3.5 -1.5 IQR                      = 4.625 0.12 BOXMAX             = 7 0 FENCEU               = 10.4375

REPSTATP

Returns a report containing the VARP, SDEVP, SEMP, RSEP, DISPINP, CVP, SNRP, ZSCROREP, SKEWP, KURTP and EXKURTP of an array

SYNTAX

REPSTATP(array)

• Array             Any array of numbers

EXAMPLE

Formula                    Description

= REPSTATP(a)        Returns the VARP(a), SDEVP(a), SEMP(a), RSEP(a), DISPINP(a), CVP(a), SNRP(a), ZSCOREP(a), SKEWP(a), KURTP(a) and EXKURTP(a)

 Array Result 1 VARP(a)            = 273.276033 2 SDEVP(a)          = 16.531063 4 SEMP(a)            = 4.984303 7 RSEP(a)             = 65.436411 10 DISPINP(a)        = 35.871556 21 CVP                   = 2.179949 54 SNRP                 =0.46084 0 ZSCOREP           = -0.400348 : -0.339856 : -0.218872 : -0.037395 : 0.144081 : 0.809495 : 2.805737 : -0.46084 : -0.533431 : -0.702809 : -1.065762 -1.2 SKEWP               = 1.881759 -4 KURT                  = 5.83748 -10 EXKURTP            = 2.83748

REPSTATS

Returns a report containing the VARS, SDEVS, SEMS, RSES, DISPINS, CVS, SNRS, TSCRORES, SKEWS, KURTS and EXKURTS of an array

SYNTAX

REPSTATS(array)

• Array             Any array of numbers

EXAMPLE

Formula                    Description

= REPSTATS(a)        Returns the VARS(a), SDEVS(a), SEMS(a), RSES(a), DISPINS(a), CVS(a), SNRS(a), TSCORES(a), SKEWS(a), KURTS(a) and EXKURTS(a)

 Array Result 1 VARS(a)            = 300.603636 2 SDEVS(a)          = 17.337925 4 SEMS(a)            = 5.227581 7 RSES(a)             = 68.619799 10 DISPINS(a)        = 39.458711 21 CVS                   = 2.275861 54 SNRS                 =0.439394 0 TSCORES           = -1.266012 : -1.074719 : -0.692133 : -0.118254 : 0.455625 : 2.559849 : 8.87252 : -1.457305 : -1.686857 : -2.222478 : -3.370236 -1.2 SKEWS               = 2.192895 -4 KURTS                  =9.712467 -10 EXKURTS            = 5.5458