Ranges and Quantiles - SuperWEB2

Click the Range button next to one of the Summation Options to create a range or quantile based on that summation option:

The Range dialog displays:

You can choose either to create a series of custom ranges or create your ranges using one of the predefined quantiles:

Custom Ranges

To define a series of custom ranges you need to specify the lowest and highest values in the range and an increment. SuperWEB2 will automatically create a series of ranges between the two values, with each individual range the size of the increment.

When defining the range, you need to specify what to do with values that are equal to one of the range boundaries: use the drop-down lists to select either < or ≤ for the From or To value.

To create a series of custom ranges, fill in the form and click Next. SuperWEB2 then displays the ranges you are about to create, and you can either click Create to create them, or Back to make changes.

The following examples show this in more detail.

Example 1 - Include the Upper Boundary in the Range

If you set the values to: From: 100 < To: 1000 ≤ Increment: 100

SuperWEB2 creates ranges where each range includes values that are equal to the upper range boundary:

Example 2 - Include the Lower Boundary in the Range

If you set the values to: From: 100 ≤ To: 1000 < Increment: 100

SuperWEB2 creates ranges where each range includes values that are equal to the lower range boundary:

When you click Create, your range is added to the Ranges section in the Customise Table tree:

Now that you have created your range, you can add the ranges to a table.

You cannot edit the range once you have created it, but if you click Manage you can use the Clone option to create a new range based on the existing one. You can also use the Manage function to delete the range.

The system administrator may have set limitations on ranges. These limitations define the minimum From value, the maximum To value, and the minimum Increment. If you attempt to create a range that breaches the configured limits then you will see an error message. You will need to adjust your range accordingly.

Quantile

To create a series of ranges using quantiles:

1. Select the Quantile tab.
2. In the Name field, enter a name for your new series of ranges.
3. In the Number of ranges drop-down list, select the number of ranges you want to create. The available options will depend on how the administrator has configured the quantile settings for this database. For example:
   

   

4. In the Equal Distribution drop-down list, select whether you want to construct the quantile ranges using the summation option or a record count from the database.

5. (Optionally) apply a filter:

   1. Select some fields from the list on the left
   2. Click Move to add them to the list on the right.

   With a filter in place, the quantile will only be constructed from records that match the specified field values. For example the following quantile will only contain records for Male customers who do one of the three specified occupations:
   

   

6. Click Next to review the quantile ranges.

7. You can then click either Create to create the ranges, or Back to make changes.

   

   You can also click Download to save a copy of the quantile definition in CSV format.