Excel Guides

Generating Random Testing Data in Excel

There are a few different ways that you can generate random testing data in Excel. One way is to use the RAND function. This function will return a random number between 0 and 1. You can use this function to generate a list of random numbers by using the following formula:


You can also use the RANDBETWEEN function to generate a list of random numbers within a specified range. For example, if you wanted to generate a list of 10 random numbers between 1 and 100, you would use the following formula:


Another way to generate random testing data is to use the Data Analysis Toolpak. This toolpak contains a number of different statistical functions that can be used to generate random data. To access the Data Analysis Toolpak, go to the Data tab and click on the Data Analysis button. Select the desired function and follow the prompts to generate your data.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.