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.
What is Numero?
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 |
| 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 |
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
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
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
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
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
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
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 |