## MathLib

##### Last updated January 8, 2013 / 146 Released UDF(s)

Calculates the average of a set of numbers omitting values less than 1 from that average. | **Requires:** CF5

Converts any numeric string (even ones with currancy symbols to a number). | **Requires:** CF5

Returns the coefficient of variation for a set of values (populaiton sample). | **Requires:** CF5

Converts a decimal Lat/Long coordinate into sexagesimal (degrees, minutes, seconds). | **Requires:** CF5

Rounds a number to a specific number of decimal places by using Java's math library. | **Requires:** CF6

Calculates the Grade of Service (failure rate) based on Busy Hour Traffic (Erlangs) and number of indepenedent lines | **Requires:** CF5

This script Calculates the Fibonacci sequence (each integer is the sum of the two previous integers). | **Requires:** CF5

Returns the Fibonacci sequence to n places given a starting point of x and y. | **Requires:** CF5

Calculates the GCD (greatest common factor [divisor]) of two positive integers using the Euclidean Algorithm. | **Requires:** CF5

Finds the GCD (greatest common factor [divisor]) of two numbers using the Extended Euclidean Algorithm. | **Requires:** CF5

Calculates distance between Latitude/Longitude points using haversine formula. | **Requires:** CF9

Creates an array of all the prime numbers from 1 to the specified integer. | **Requires:** CF5

Bins the elements of an array into equally spaced containers and returns the number of elements in each container. | **Requires:** CF7

Function which returns the value of a certain quantile from a list of numeric values. | **Requires:** CF5

Returns the hypotenuse of a right triangle by Pythagorean theorem, given the lengths of the other two sides. | **Requires:** CF5

Calculates the initial true course between two latitudes and longitudes. | **Requires:** CF5

IsFloat() determines if a number is a float or whole number. Returns true for float. | **Requires:** CF5

Takes any three numbers, checks to see whether they create a right triangle. | **Requires:** CF5

Returns true if passed value is formatted in "baseEexp" scientific notation. | **Requires:** CF5

Calculates the latitude and longitude for a given latitude, longitude, true course and distance in nautical miles. | **Requires:** CF5

Converts logic bit constants (TRUE, "Yes", 1,FALSE,"No",0) or logical expressions to bit values (1,0). A non-boolean value returns a -1 value. | **Requires:** CF5

Calculates the normal distribution for a given mean and standard deviation with cumulative=true | **Requires:** CF5

Function for calculating the percentile of a given number from a population of numbers. | **Requires:** CF5

Evaluates the Polynomial in the form y = an * x^n + a(n-1) * x^(n-1) + ... + a1 * x + a0 for a given value of x. | **Requires:** CF5

Returns the first, second, or third quartile value for a set of numeric values. | **Requires:** CF5

Symmetrically rounds any number to a specific decimal point, preventing a common "rounding bias" from skewing results. | **Requires:** CF5

Restores significant trailing zeroes which may have been omitted during calculations. | **Requires:** CF5

Decodes a 2's complement base 10 (decimal) value into an unencoded base 10 value. | **Requires:** CF5

Returns Weight Watchers Winning Points from calories, fat, and dietary fiber. | **Requires:** CF5

### Search CFLib.org

### Latest Additions

Kevin Cotton added

date2ExcelDate

May 5, 2016

Raymond Camden added

CapFirst

April 25, 2016

Chris Wigginton added

loremIpsum

January 18, 2016

Gary Stanton added

calculateArrival...

November 19, 2015

Sebastiaan Naafs - van Dijk added

getDaysInQuarter

November 13, 2015