Variable Display in MarketSight: Calculations, Nets and Value Selection

Overview

MarketSight offers many options that make it easy for you to create a custom crosstab that suits your needs.

Change Value Selection

1. After adding row variables to your crosstab, view a variable's values by clicking on the + icon to the left of its name
2. Select or deselect checkboxes as necessary

Apply Value Selection to Other Row Variables

1. Make changes to the value selection of one variable
2. Click on the Options link to the right of its name
3. Select Apply Value Selection to Others
4. In the dialog that appears, select the variables you would like to apply the changes to
5. Click Include
6. Click OK

Change Calculations

1. Find the variable you would like to change within the Row Variables window
2. Click on the Options link to the right of its name
3. Select Calculations
4. Change the displayed calculations as desired
5. Apply to any other variables in the bottom half of the dialog if needed
6. Click OK to save your changes

Add Variable-Specific Weighting

1. Find the variable you would like to change within the Row Variables window
2. Click on the Options link to the right of its name
3. Choose Weighting
4. Check the box to Set Weighting for this Row Variable (A)
5. Search for the weight variable from your dataset (B)
6. Select the weight variable (C)
7. Apply to any other variables in the bottom half of the dialog if needed (D)
8. Click OK to save your changes

Apply Calculations to Other Row Variables

1. After selecting your calculations, go to the bottom half of the Calculations dialog (C)
2. Select the variables you'd like to apply your changes to
3. Click include
4. Click OK to save your changes

Netting

Netting allows you to quickly create Top, Middle and Bottom boxes for your Crosstabs without creating Regrouping User Defined Variables. Nets are oriented by Variable's numeric values, not labels. On an example scale of 1 to 10, 1 is the "bottom" limit and 10 is the "top" limit, regardless of the label used to describe it.

Add Netting

1. While editing or designing your Crosstab, click on the Rows tab
2. Click on the options link next to the desired row variable
3. Select Nets
4. Check the boxes next to Top/Middle/Bottom Nets
5. Determine the number of variable values used for each Net by clicking on their respective drop down menu
6. If necessary, change the text to be displayed
7. Choose the position of the Net display relative to the variable values in the Crosstab

Apply Netting to Other Row Variables

1. After selecting your netting settings, go to the bottom half of the dialog
2. Select the variables you'd like to apply your nets to
3. Click include
4. Click OK

Net Promoter Score

Net Promoter Score (NPS) is a simple metric typically used on an eleven point scale. In most situations, responses which land anywhere from one (0) to six (6) are considered "Detractors." Responses which are seven (7) or eight (8) are "Passives." The highest responses, nine (9) through ten (10), are considered "Promoters." Net Promoter Score is the result obtained when you subtract the Detractors from the Promoters.

Because no two datasets are alike and different users may have different requirements, Net Promoter Score in MarketSight is the result obtained when you subtract your Bottom Box (Detractors) from your Top Box (Promoters). The user Net settings indicate how many values are included within each box. Net Promoter Score will work even if you are not displaying Top and Bottom boxes. It will use the Variable values indicated in the Top and Bottom box setup, whether they are checked or not.

Enable Net Promoter Score

1. While editing your Crosstab, click on the Rows tab
2. Click on the Options link next to the desired row variable
3. Select Nets
4. Check box next to NPS
5. Set your top and bottom boxes to represent your promoters and detractors
6. Choose the position of the NPS display relative to the variable values in the Crosstab