The Spreadsheet Question and Table Question panels can be used to display and perform calculations on tabular data. Functions can be copied or entered directly into cells. Double-click on cells that contain functions to edit them.
The following functions can be used in the Spreadsheet Question and Table Question panels:
Tip: Calculations should always begin with the equals symbol (=).
| Function | Description |
|---|---|
| ABS(x) | Returns the absolute value of a number. |
| AVERAGE(number_list) | Returns the average of the supplied numbers. |
| COUNT(value_list) | Returns the number of values in the supplied list. |
| IF(condition, true_value, false_value) | Tests the condition and returns the specified value. |
| INT(x) | Rounds the supplied number down to the nearest integer. |
| LN(x) | Returns the natural logarithm of a number. |
| LOG(x, base) | Returns the logarithm of a number to the specified base. |
| LOG10(x) | Returns the base-10 logarithm of a number. |
| LOWER(text) | Changes the textual characters in the specified string to lowercase characters. |
| MAX(number_list) | Returns the largest value in the specified list of numbers. |
| MIN(number_list) | Returns the smallest value in the specified list of numbers. |
| MOD(x, divisor) | Returns the remainder after dividing a number by a specified divisor. |
| PI() | Returns the value of the constant pi. |
| PRODUCT(number_list) | Multiplies a list of numbers and returns the result. |
| RAND() | Returns a number selected randomly from a uniform distribution greater than or equal to 0 and less than 1. |
| ROUND(x, precision) | Rounds the given number to the supplied number of decimal places. |
| SIGN(x) | Determines the sign of the specified number. |
| SIN(x) | Returns the sine of the supplied angle. |
| SQRT(x) | Returns the square root of the specified number. |
| STDEV(number_list) | Returns the standard deviation of a population based on a sample of supplied values. |
| SUM(number_list) | Returns the sum of the supplied numbers. |
| SUMIF(range, criteria, sum_range) | Returns the sum of the specified cells based on the given criteria. |
| TAN(x) | Returns the tangent of the specified angle. |
| UPPER(text) | Changes the characters in the specified string to uppercase characters. |
| VALUE(text) | Returns the specified text as a number. |
| VAR(number_list) | Returns the variance of a population based on a sample of values. |