Scale-up Suite Help
Functions
What is Numero?

Numero is an Office add-in that brings calculations and chemistry to Word, PowerPoint, Outlook and Excel.  This allows you to keep your train of thought going 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 and translate notes in a task pane using Plaintext.  Access materials information using the Numero Chem extension.

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

RADIANS

Converts the input from radians into degrees 

SYNTAX

   RADIANS(number)

  • Number             Any positive number is required

EXAMPLE

    Formula                    Description                                            Result

    =RADIANS(45)         Convert 45 degrees into radians           0.785398

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

 

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

 

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
QUADMEAN

This is the quadratic mean or root mean square.

SYNTAX

   QUADMEAN(array)

  • Number             Any positive number is required

Note

Formula     

                                

EXAMPLE

    Formula                      Description                                           Result                                  

     = QUADMEAN(a)      Quadratic mean of 1, 2, 3, 4                 2.738613

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

 

MAD

This calculates the median absolute deviation for a sample

SYNTAX

   MAD(a)

  • 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

 

 

 

 

 


Copyright © Scale-up Systems Ltd.