Mathematical Variables

Overview

A typical mathematical user defined variable is based on a continuous (numeric) uploaded variable, and allows you to perform basic mathematical operations such as addition, subtraction, multiplication and division. Missing values cannot be evaluated in mathematical statements and will prevent subtraction, multiplication and division operations from being run.

For example, we have a variable where respondents were asked to estimate the minutes they used each month. We want to multiply these numbers by 12 to get a picture of the yearly minutes used.

 

MarketSight Mathematical Variables

 

Create a Mathematical Variable

  1. On the Variables page, click New
  2. Select "Mathematical" from the list
  3. Type in a name for the new variable
  4. Specify the formula expression for the variable
    1. To add a variable value:
      1. Select the variable from the dropdowns
      2. Click Add to Definition
    2. To include a constant number such as 12:
      1. Choose "Constant"
      2. Type in the number
      3. Click Add to Definition
  5. Click OK

 

Complex Expressions

The logic within a mathematical variable can become more complex.  For example, let's try to build a formula for a similar variable called ”Monthly Revenue”:

(Price * Annual Volume) / 12

 

  1. Construct the first part of the expression:
    1. Click the open parenthesis [ ( ] button in the upper right
    2. Choose ”Variable” from the Type drop-down
    3. Select the Category ”Financial” from the Category list in the upper left
    4. Select the Variable ”Price”
    5. Click [Add to Definition] to move this Variable into the expression window
    6. Click on the multiplication operator [ * ] in the upper right
    7. Select the Variable ”Annual Volume” from the Variable list
    8. Click [Add to Definition] to move this Variable into the expression window
    9. Click the [ ) ] button to finish the first part of the expression
  2. Construct the second half of the expression:
    1. Click the division operator [ / ]
    2. Choose ”Constant” from the Type drop-down
    3. Type the number ”12” into the Value box
    4. Click [Add to Definition] again to move this constant Value into the expression window
    5. Click OK to save your changes

 

 

 

 

 

Last Updated: 7/11/2019