Background<\/h3>\n
Quantity data provides a continuous set of values. Because of this it is difficult to find out how values are distributed, as every response could be different. If you want to see what ranges responses fall into, you have to group the responses together. You can choose how to group your responses, though it is best to group them into equal size bands to see how the responses are distributed. You need to choose how wide the bands are to make sure that you don’t miss any important spikes or dips (which might average out over a wide band).<\/p>\n
To do this, you need to find out what the minimum and maximum value responses are, and use this information to divide the range into equal bands. Snap allows you to display the minimum and maximum value in a table of descriptive statistics.<\/p>\n
Once you have decided on your bands, you must sort the responses into those ranges, so you can use them in charts and tables. This is done by creating a variable derived from the original response.<\/p>\n
There are several types of derived variables in Snap. These are known as derived, numeric, pre-coded and alphanumeric variables.<\/p>\n
- \n
- Derived is a general type that can be used on any type or number of variables.<\/li>\n
- Numeric, pre-coded and alphanumeric variables are generated from a single variable. You set this variable as the data source, and then describe how it is converted into the new variable.<\/li>\n<\/ul>\n
Derived variables have much more flexibility, but if you are converting a single variable into a set of ranges or values, it can be quicker to use one of the other types.<\/p>\n
<\/a>Summary of steps<\/h3>\n
Step 1: Decide on your bands<\/a>
\nStep 2: Create the variable<\/a>
\nStep 3: Analyse the bands<\/a>
\nStep 4: Do further analysis of a specific subsection<\/a><\/p>\n\n<\/a>Step 1: Decide on your bands<\/h3>\n
When you are splitting a quantity into bands, it is good practice to choose bands of equal size. Start by finding what the maximum and minimum values are.<\/p>\n
- \n
- Click
![\"Table](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/06\/table.png\")
\u00a0to create a table.<\/li>\n - Set the Analysis <\/strong>value to Q5 <\/strong>(the “Amount spent” question).<\/li>\n
- Select Statistics table<\/strong> from the drop down list for the Break<\/strong>.\n
\n![\"Results](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/def_anq5_stats_crp.png\")
<\/p>\n<\/div>\n<\/li>\n- Click the Descriptive Statistics\u00a0<\/strong>tab to select what information will appear in your table.\n
![\"Results](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/ds_minmax_crp.png\")
<\/div>\n<\/li>\n- Use the [<]<\/strong> button to remove all entries from the Used <\/strong>column apart from the Minimum<\/strong>, Maximum <\/strong>and Range <\/strong>statistics.<\/li>\n
- Click [OK]\u00a0<\/strong>to create your table.\n
\n![\"Table:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/tab_minmaxstpng.png\")
<\/p>\n<\/div>\n<\/li>\n<\/ol>\nThis tells you how the top of bottom limits of your bands. For a coarse grain banding, you could split the data into bands of 1 – 7.99 8 – 14.99 and 15 – 22.<\/p>\n<\/div>\n
\n<\/a>Step 2: Create the variable<\/h3>\n
- \n
- Open the snCrocodile survey.<\/li>\n
- Click
![\"Variables](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/codes.png\")
\u00a0on the toolbar to open the variables window (or select View | Variables<\/strong>).<\/li>\n- Find Q5\u00a0<\/strong>in the list of variables to check that it is the one you want. This is the variable where people’s total spend is recorded.\n
\n![\"VW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/vw_q5_sel.png\")
<\/p>\n<\/div>\n<\/li>\n- Click
![\"New](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/add.png\")
\u00a0on the variables window toolbar to create a new variable.<\/li>\n- Set the Type <\/strong>to Numeric<\/strong>.<\/li>\n
- Add a label (e.g. Banded spends) to describe the variable in any analyses.<\/li>\n
- Set the Response <\/strong>to Single<\/strong>.\n
\n![\"Variable](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/vd_numeric_sel.png\")
<\/p>\n<\/div>\n<\/li>\n- Click the
![\"Variable](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/03\/desmode.png\")
\u00a0button to display the variable definition.<\/li>\n- Type Q5<\/strong> in the Source <\/strong>field. This means that the data will be derived from the response in Q5<\/strong>.<\/li>\n
- Click in the empty Code Label<\/strong> field.\n
\n![\"Variable](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/vd_numeric_det.png\")
<\/p>\n<\/div>\n<\/li>\n- Enter your first range. Type Low spend (\u00a31 – 7.99)<\/strong> as the label. Press [Tab] to move to the Values field and enter 1 to 7.99<\/strong>.<\/li>\n
- Press the [Tab] key to enter a new code and give it a label of Medium spend (\u00a38 – 14.99) <\/strong>and give a value of 8 to 14.99<\/strong>.<\/li>\n
- Repeat to create a code with label High spend (\u00a315 – 22) <\/strong>and a value of 15 to 22<\/strong>.\n
\n![\"VD:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/band_defs.png\")
<\/p>\n<\/div>\n<\/li>\n- Click
![\"Save](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/save.png\")
\u00a0to save your new variable.<\/li>\n<\/ol>\n<\/div>\n\n<\/a>Step 3: Analyse the bands<\/h3>\n
- \n
- Click
![\"Chart](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/charts.png\")
\u00a0on the toolbar to create a chart.<\/li>\n - Set the style to Bar 2D Labelled percents<\/strong>. Set the analysis value to the name of your new variable (V2C) and check the Transpose <\/strong>box.\n\n
![\"RD:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/def_v3_bed_lab_per_crp1.png\")
<\/p>\n<\/div>\n<\/li>\n- Click [OK] <\/strong>to display your chart.\n
\n![\"RW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/2bar-bandspend.png\")
<\/p>\n<\/div>\nYou can see that nearly all the responses are in the lowest band. For further detail, you will need to redefine your variable or create a new variable with narrower bands.<\/li>\n
- Open the new variable and select the first code (Low spend).<\/li>\n
- Change the values from 1 to 7.99<\/strong> to 1 to 3.99<\/strong>, and change the label to match.<\/li>\n
- Click
![\"Clone](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2014\/05\/clone.png\")
\u00a0to duplicate the code.<\/li>\n- Change the new code values to 4 to 6.99 <\/strong>and edit the label.<\/li>\n
- Duplicate the code again and give it values of 7 to 9.99<\/strong>.<\/li>\n
- Change the Medium spend code values to 10 to 12.99<\/strong>.<\/li>\n
- Duplicate the code and give the new code values of 13 to 15.99<\/strong>.<\/li>\n
- Change the High spend code values to 16 to 18.99<\/strong>.<\/li>\n
- Duplicate the code and give it values of 19 to 22<\/strong>.\n
\n![\"RW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/band_defs_fine.png\")
<\/p>\n<\/div>\n<\/li>\n- Click
\u00a0to save your changes.<\/li>\n- If your chart is still open it will now have Out of Date\u00a0<\/strong>on the title bar.\n
\n![\"AW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/out-of_date_tb.png\")
<\/p>\n<\/div>\n<\/li>\n- Press
![\"1](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2013\/09\/count.png\")
\u00a0to update the chart.\n\n![\"RW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/2bar_finebandspend.png\")
<\/p>\n<\/div>\n<\/li>\n<\/ol>\n<\/div>\n\n<\/a>Step 4: further analysis of the low end values<\/h3>\n
The previous graph showed that the most people spent less than seven pounds in the shop, which the other bands being roughly equal.<\/p>\n
You could further analyse the low end spending in a separate graph.<\/p>\n
- \n
- Select your new variable in the variables window and press \u00a0to duplicate the variable.<\/li>\n
- Change the label to something like Low end banded spends – to make it clear that this is only a subset of the data.<\/li>\n
- Change the first code label to 1 – 1.99<\/strong>.<\/li>\n
- Change its value to <2<\/strong>. All values that are less than 2 will now be stored in this variable.<\/li>\n
- Change the second code label to 2 – 2.99<\/strong> and change its value to <3<\/strong>. Since the values lower than two have already been placed in the first code, values from 2 to 2.99<\/strong> will now be in this variable.<\/li>\n
- Continue setting up the codes until you get to 6 – 6.99<\/strong> and <7<\/strong>.<\/li>\n
- Click
\u00a0to save your changes.<\/li>\n- Create a bar chart displaying your new variable.\n
\n![\"RW:](\"https:\/\/www.snapsurveys.com\/support-snap11\/wp-content\/uploads\/2012\/10\/2bar_lowbandspend.png\")
<\/p>\n<\/div>\n<\/li>\n<\/ol>\nYou can see from this that the most popular lower end spend is between three and four pounds.<\/p>\n<\/div>\n
<\/a><\/p>\n
Conclusion<\/h3>\n
This worksheet has shown you how to split the responses in a quantity variable into bands for analysis. It has explained how to see what the maximum and minimum values for the variable are, and how to create a numeric variable to store the banded information.<\/p>\n
It also shows you another way of setting up values for banded variables using the < symbol rather than a range.<\/p>\n
For more information about analysing quantity variables, see the section Quantity responses<\/a><\/strong>.<\/p>\n
There is a worksheet available on analysing literal variables<\/a> using a derived variable.<\/p>\n
If there is a topic you would like a worksheet on, email to snapideas@snapsurveys.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
- Change its value to <2<\/strong>. All values that are less than 2 will now be stored in this variable.<\/li>\n
- Click [OK] <\/strong>to display your chart.\n
- Find Q5\u00a0<\/strong>in the list of variables to check that it is the one you want. This is the variable where people’s total spend is recorded.\n
- Select Statistics table<\/strong> from the drop down list for the Break<\/strong>.\n
- Click