Random number generator
Generate random numbers to analyze potential scenarios with the Random number generator tool.
Important
The Random number generator tool is not widely available yet. If you want this feature, contact Varicent Support.
Generate random numbers to analyze potential scenarios with the Random number generator tool. The tool helps you understand the distribution of historical data, modify that distribution and explore scenarios and impact of changes.
When to use this tool
Use the Random number generator tool when you want to run simulations, so you will be able to make better business decisions and understand the range and probabilities of outcomes of each scenario.
Input
The Random number generator tool requires one data input.
Configuration
Use the following configuration options to help randomize your data.
In the pipe builder, add your data source.
Click
+Add Tool.
Click See all tools.
In the search bar, search for Random number generator. Click Add tool.
Tip
You can also find the Random number generator tool in the Learn section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 54. Random number generator tool configurationField
Description
Exclude duplicate rows (Optional)
Select a column containing unique IDs to to remove duplicate rows from simulation.
Note
This field could be filled out when the Random number generator tool is added to the pipe after the Repeat tool.
Randomization1
Enter a name for your randomization, or leave the default, Randomize1, Randomize2, and so on.
Randomization method
Select the randomization method, either Learned or Defined.
Learned method: The tool automatically selects the distribution type and learns the data.
Find this distribution in the Tool tab after you build.
Defined method: You manually select the distribution type and learn the data from your configurations.
Learned distribution column
Select a numerical column to use when using the Learned method.
Distribution type (Defined)
Select the distribution type from the drop-down menu to specify the mathematical model defining how input variables uncertainties are represented:
Normal
Triangular
Uniform
Weibull
Poisson
Binomial
Enter the constraints for your selected distribution type.
Advanced section
Min
Enter the constraints for the minimum value of the random number generated.
Max
Enter the constraints for the maximum value of the random number generated.
Group by
(Optional) Select Group by to group your data by selected columns.
Note
You cannot select the column that you selected in Exclude duplicate rows or Learned distribution column.
Build your pipe, then review the simulation results in the Row viewer Tool tab.
Usage example
Use the Random number generator tool to make data-driven decisions based on scenario planning. For example, if you are a sales organization with hundreds sales people, you would like to get an idea of what the company will be potentially spending during the compensation process. All of the sales people have different attainment levels. Using the Random number generator tool, you can see what the potential outcome will be for individual employees. This would indicate how much you could potentially spend during the compensation cycle.