Section author: Laiton Hedley

List of Functions

Use these functions in the formula editor to create computed variables, transformed variables, and filters.

Understanding Formulas

Build your formulas using numbers, variable names, text values, operators, and functions.

Numbers: Enter whole numbers or decimals as-is (e.g., 1, 2.5).
Variable names: Type the name of an existing column (e.g., variable_name).
Text values: Wrap text in single quotes (e.g., 'Yes', 'Group A').
Operators: Use arithmetic operators (+, -, *, /) or logical operators (and, or).

Tip

If a variable name contains spaces, wrap it in backticks so jamovi can parse it correctly (e.g., use `reaction time`).

Row vs. Variable Functions

Many functions come in two versions:

Row functions (e.g., MEAN): Use these to calculate a result for each row individually.
Variable functions (e.g., VMEAN): Use these to perform a calculation using every value in a column.

For more detail on this distinction, see Row and V Functions.

Math Functions

Function	Description
`ABS(var)`	Calculate the absolute value of each number in the column.	Info
`EXP(var)`	Raise e to the power of each value in the column.	Info
`LN(var)`	Calculate the natural logarithm (base e) of each value.	Info
`LOG10(var)`	Calculate the base-10 logarithm of each value.	Info
`SQRT(var)`	Calculate the square root of each value.	Info

Statistical Functions

Function	Description
`ABSIQR(var)`	Calculate the average absolute deviation of values from the median.	Info
`ABSZ(var)`	Calculate the absolute z-score for each value.	Info
`BOXCOX(var)`	Apply a Box-Cox transformation to the variable.	Info
`CEILING(var)`	Round up each value to the nearest whole number.	Info
`FLOOR(var)`	Round down each value to the nearest whole number.	Info
`IQR(var)`	Identify if a value is within the “box” (0) or outside the “whiskers” (> 1.5).	Info
`MAX(...)` `VMAX(...)`	Find the highest value in a row (`MAX`) or column (`VMAX`).	Info
`MAXABSIQR(var)`	Find the maximum absolute interquartile range across multiple variables.	Info
`MAXABSZ(var)`	Find the maximum absolute z-score across multiple variables.	Info
`MEAN(...)` `VMEAN(...)`	Calculate the average of a row (`MEAN`) or an entire column (`VMEAN`).	Info
`MIN(...)` `VMIN(...)`	Find the lowest value in a row (`MIN`) or column (`VMIN`).	Info
`RANK(var)`	Assign an ordinal rank to each value in the column.	Info
`ROUND(var, n)`	Round each value to n decimal places.	Info
`SCALE(var)`	Normalize a set of numbers (shorthand for `Z(var)`).	Info
`STDEV(...)` `VSTDEV(...)`	Calculate the standard deviation of a row (`STDEV`) or column (`VSTDEV`).	Info
`SUM(...)` `VSUM(...)`	Add up all values in a row (`SUM`) or column (`VSUM`).	Info
`VMAD(var)`	Calculate the median absolute deviation of a variable.	Info
`VMADR(var)`	Calculate the robust median absolute deviation of a variable.	Info
`VMED(var)`	Find the median of a variable.	Info
`VMODE(var)`	Find the most common value (mode) in a variable.	Info
`VN(var)`	Return the number of non-missing cases in a variable (sample size).	Info
`VSE(var)`	Calculate the standard error of a variable.	Info
`VAR(...)` `VVAR(...)`	Calculate the variance of a row (`VAR`) or column (`VVAR`).	Info
`Z(var)`	Standardize values into z-scores.	Info

Logical Functions

Function	Description
`IF(cond, val, else)`	If the condition is true, use val; otherwise, use else.	Info
`IFMISSING(v, val, else)`	Use val if the cell is empty; otherwise, use else.	Info
`NOT(var)`	Invert a boolean value (True becomes False, and vice versa).	Info

Text Functions

Function	Description
`CONTAINS(needle, hay)`	Check if a specific string (the needle) exists in a variable (the haystack).	Info
`SPLIT(v, 'by', pos)`	Split a text string by a specific character and return the text at a given position.	Info
`TEXT(var)`	Convert numeric values into text format.	Info
`VALUE(var)`	Convert text strings into numeric values, if possible.	Info

Date and Time Functions

Function	Description
`DATEVALUE(var)`	Convert a text date (e.g., 2000-12-20) into the number of days since 1 Jan 1970.	Info
`DATE(var)`	Convert a Unix day count back into a formatted date string.	Info

Reference Functions

Function	Description
`HLOOKUP(idx, v1, v2, ...)`	Retrieve values from specific rows using a provided index.	Info
`MATCH(var, val1, ...)`	Find the row index of the first value that matches your criteria.	Info

Miscellaneous Functions

Function	Description
`COUNT(var)`	Count the number of non-missing values in a set of columns.	Info
`FILTER(var, expression)`	Return only the values in a column that meet a specific condition.	Info
`INT(var)`	Strip the fractional component from a number to make it an integer.	Info
`OFFSET(var, n)`	Shift the data in a column up or down by n rows.	Info
`ROW()`	Fill a column with the current row number.
`SAMPLE(var, n)`	Draw a random sample of n values from a variable.	Info
`VROWS(var)`	Return the total number of rows in a variable.

Simulation Functions

Function	Description
`BETA(alpha, beta)`	Draw random samples from a Beta distribution.	Info
`GAMMA(shape, scale)`	Draw random samples from a Gamma distribution.	Info
`NORM(mean, stdev)`	Draw random samples from a Normal (Gaussian) distribution.	Info
`UNIF(min, max)`	Draw random samples from a Uniform distribution.	Info