Math & statistics

Inputs

• expression string · required — For example (price * qty) * (1 + tax_rate) - discount. Variable names may be dotted paths into Variables (order.total). ^ is power, % is remainder; log(x) is base 10, log(x, b) base b, ln(x) natural.
• variables object — The values the formula uses, as an object: { "price": 19.99, "qty": 3 }. Numeric text is accepted.
• decimals integer — Optional: round the result to this many decimal places (half up). Leave empty for the full result.

Outputs

• result number — The value of the formula.

Inputs

• value number · required — The number to round.
• decimals integer — Decimal places (0 for whole numbers; negative rounds to tens, hundreds…).
• mode choice · half_up / half_even / up / down / floor / ceil — How to round a value that sits between two results.

Outputs

• result number — The rounded number.

Inputs

• values list · required — The numbers: a list of numbers (or numeric text), or a list of objects with Field naming the number. Blank entries are skipped.
• field string — When Values is a list of objects: the property holding the number (dotted paths such as amount.total work).
• variance_type choice · sample / population — Sample (n - 1, for a sample of a larger population) or population (n, for the whole set).

Outputs

• count integer — How many numbers there are (blank entries are skipped).
• sum number
• mean number — The average (empty when there are no numbers).
• min number
• max number
• median number — The middle value (the average of the two middle values for an even count).
• mode number — The most frequent value (the smallest if several tie); empty when no value repeats.
• variance number — Sample variance needs at least 2 numbers.
• stddev number
• range number — Maximum minus minimum.

Inputs

• values list · required — The numbers: a list of numbers (or numeric text), or a list of objects with Field naming the number. Blank entries are skipped.
• field string — When Values is a list of objects: the property holding the number (dotted paths such as amount.total work).
• p number · required — From 0 to 100: 50 is the median, 90 the 90th percentile.

Outputs

• value number — The percentile.
• count integer — How many numbers were used.

Inputs

• principal number · required — The amount invested at the start.
• annual_rate number · required — Nominal annual interest rate in percent, e.g. 5 for 5%.
• years integer · required — How many years (1 to 100).
• compounds_per_year integer — 1 yearly, 4 quarterly, 12 monthly, 52 weekly, 365 daily.
• contribution number — Optional amount added every compounding period (e.g. monthly when compounding monthly).
• contribution_timing choice · end / start — Whether contributions are added at the start or the end of each period.

Outputs

• future_value number — The balance at the end, rounded to 2 decimals.
• total_contributions number — The starting amount plus every contribution.
• interest_earned number — Future value minus total contributions.
• schedule list of objects — One row per year.each: year (integer), contributions (number), interest (number), balance (number)

Inputs

• principal number · required — The amount borrowed.
• annual_rate number · required — Nominal annual interest rate in percent (0 for an interest-free loan).
• term_months integer · required — Number of monthly payments (1 to 600), e.g. 360 for 30 years.
• start_date date — Optional: the date of the first payment; later payments fall on the same day of each month (the last day in shorter months).
• extra_payment number — Optional extra principal paid with every payment.

Outputs

• payment number — The regular payment (the last one may be smaller).
• total_interest number
• total_paid number — Principal plus interest.
• number_of_payments integer — Fewer than the term when extra payments are made.
• payoff_date date — The date of the last payment (empty without a first payment date).
• schedule list of objects — One row per payment.each: period (integer), date (date), payment (number), principal (number), interest (number), balance (number)

Inputs

• value number · required — The amount to convert.
• from string · required — Symbol or name: mm cm m km in ft yd mi nmi · mg g kg t oz lb st · ml l m3 tsp tbsp floz cup pt qt gal gal_uk · C F K · m2 km2 ha ac ft2 · m/s km/h mph kn · bit B kB MB GB TB KiB MiB GiB Mb Gb · ms s min h d wk mo yr.
• to string · required — A unit of the same kind as From unit.

Outputs

• result number — The converted value (12 significant digits).
• category string — length, mass, volume, temperature, area, speed, data or time.
• from_unit string
• to_unit string