Math Calculations

• Absolute Value : Returns the distance of a number from zero, without considering its sign.
• Average : Finds the mean of a set of numbers. It is the sum of all the numbers divided by the total count of the numbers.
• Ceiling : Rounds up a number to the nearest whole number.
• Difference : The result of subtracting one number from another.
• Division : The result of dividing one number by another.
• Floor : Rounds down a number to the nearest whole number.
• Ln : A specific type of Logarithmic function that uses the mathematical constant e (approximately 2.71828) as its base. The natural logarithm is the inverse of the power (exponential) function with base e. This is solving for x in the equation y = b^x when y is your input and b is the mathematical constant e.
• Log : The inverse of the power (exponential) function where the base is 10. This is solving for x in the equation y = b^x when y is your input and b is 10.
• Margin : Difference between the cost price and the selling price of a product. Usually expressed as a percentage of the cost price.
• Maximum : Highest value in a set of numbers.
• Median : Middle value in a set of numbers. If there is an even number of values, it is the average of the two middle values.
• Minimum : Lowest value in a set of numbers.
• Multiplication : The result of multiplying one number by another.
• Power : Raising a number to a specific power resulting in the base number being multiplied by itself as many times as the power number states. Also known as the "exponential" function.
• Random Number : A number that is generated between a specified range by a random process.
• Remainder : The result of dividing one number by another and taking the remainder (leftover values that don't total the divisor).
• Round : Rounds a number to the nearest integer.
• Running Total : Sum of a set of numbers up to a certain point.
• Sign : Returns the sign of a number, either positive, negative or zero.
• Square : The result of multiplying a number by itself.
• Square Root : Calculates the square root of a number, which is the number that, when multiplied by itself, gives the original number. This is the opposite of squaring a number.
• Standard Deviation : Measure of the spread of a set of numbers. Square root of the variance, which is the average of the squared differences from the mean. High standard deviation indicates that the data points are spread out, while a low standard deviation indicates that the data points are close together. This helps outline the variability of a set of data.
• Sum : The result of adding a set of number together to get a total value.
• Truncate : Removes the decimal part of a number and returns the integer part.
• Uniform Buckets : Method of diving a range of values into a specific number of equally sized buckets. Each bucket contains a range of values that is the same size as the other buckets.