## MathLib

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

Returns the coefficient of variation for a set of values (populaiton sample). | **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 hypotenuse of a right triangle by Pythagorean theorem, given the lengths of the other two sides. | **Requires:** CF5

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

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

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

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

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

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

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

Decodes a 2's complement base 10 (decimal) value into an unencoded base 10 value. | **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

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

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

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

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

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

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

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

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

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

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

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

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

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

Returns the first, second, or third quartile value for a set of numeric values. | **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

### Search CFLib.org

### Latest Additions

Raymond Camden added

QueryDeleteRows

November 04, 2017

Leigh added

nullPad

May 11, 2016

Raymond Camden added

stripHTML

May 10, 2016

Kevin Cotton added

date2ExcelDate

May 05, 2016

Raymond Camden added

CapFirst

April 25, 2016