The LN Function
Returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
1904, 2019
Monthly Archives: April 2019
1904, 2019
The SUMSQ Function
Returns the sum of the squares of the arguments.
1904, 2019
The SQRT Function
Returns a positive square root.
1904, 2019
The ABS Function
Returns the absolute value of a number. The absolute value of a number is the number without its sign.
1904, 2019
The PERCENTILE.EXC function
It returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
1904, 2019
The PERCENTILE.INC function
It returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
1904, 2019
The PERCENTILE function
It returns the k-th percentile of values in a range. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are PERCENTILE.INC and PERCENTILE.EXC.
1904, 2019
The QUARTILE.EXC function
It returns the quartile of a data set based on percentile values from 0..1, exclusive.
1904, 2019
The QUARTILE.INC function
It returns the quartile of a data set based on percentile values from 0..1, inclusive.
1904, 2019
The QUARTILE function
It returns the quartile of a data set. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are QUARTILE.INC and QUARTILE.EXC.