Method
Mathematical Functions (by Case) automatically creates a new variable that is a result of the function of the selected input variables. It can also be used to find specific values in the input variables. It consists of commonly used mathematical functions: Sum, Minimum, Maximum, Average, Standard Deviation, Variance, and Count; as well as two logical functions: Any of and None of. New variables can be created by going to Variables and Questions tab, selecting the variables to be included in the function, right-clicking, and selecting Insert Ready-Made Formula(s) > Mathematical Functions (by Case) > function.
Depending on values, Q might ask the user to confirm if the variable should be computed using incomplete data; if Yes, Q will compute the data using whatever data is available for each respondent. If No, Q returns missing data (NaN) for respondents with a missing value for any of the variables included in the calculation. The functions can be used with Numerical, Categorical, and Money variable types. The resulting variable will contain the result of the mathematical function on respondent level. The resulting variable will be of the Numerical type for all mathematical functions and of the Categorical type for logical functions Any of and None of. The resulting variable type can be changed from Numerical to Categorical.
The user can pick from any of the below functions.
Sum
The Sum function returns a numeric variable equal to the sum value of selected variables. The function can be used to calculate the sum of selected variables. It can also be used to count the number of selected codes in Pick Any question type, assuming that selected values are coded as 1, and non-selected values are coded as 0.
Minimum
The Minimum function returns the smallest value from the set of selected variables.
Maximum
The Maximum function returns the largest value from the set of selected variables.
Average
The Average function returns the average value from the set of selected variables.
Standard deviation
The Standard deviation function returns the standard deviation value from the set of selected variables. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).
Variance
The Variance function returns the variance value from the set of selected variables. Variance is a measure of how far a set of numbers is spread out from their average value.
Count
The Count function returns the number of occasions that a specific value(s) appears within the input variables. When used with Pick Any variables the function will return the count of the number of selected variables (e.g. value equal to 1). When used with Categorical variables (e.g. 5-point scale) or Money variables, you will have to define which values(s) are to be counted. In the below example, we are using the function with a Pick One - Multi variable to count how many of the presented audio formats a respondent is listening to at least daily.
To do that, we can add values 7 and 8 into the single value field and add them individually, or alternatively, we can set up a range. Note, that when setting up a range the function will count all the instances where at least one of the values within the range is found.
The result will be a Numeric variable that can be used to calculate the average number of music formats listened to daily. To analyze the frequency, change the question type from Numeric to Categorical > Pick One.
Any of…
The Any of... function looks for a specific value(s), returning a categorical variable with values of 0 ‘Not selected’ when none of the values were found, or 1 ‘Selected’ when at least one of the values is found. Similar to the Count function it checks for the presence of the value but instead of the number of instances the value was found, it only returns the information if the value was found or not.
None of...
The None of… works in the opposite way to the Any of… function. It looks for a specific value(s) returning a categorical variable with values of 0 ‘Not selected’ when at least one of the values is found, and 1 ‘Selected’ when none of the values is found.
Editing of a variable constructed using Mathematical Functions (by Case)
Variables created can be copied and edited. To edit the variable right-click on the variable in the Variables and Questions tab > Edit Variable. A new Edit Java-Script Variable window will appear allowing the user to edit the variable. See our blog post to learn more about Java-Script Variables in Q.
Technical details
For details of each mathematical calculation and options see Mathematical Calculations on Tables and Variables.