How To Create a Random Set of Data

Here is an easy way to create a random set of data using the RANDBETWEEN() Funciton.

RANDBETWEEN(Bottom;Top) - This function returns a random integer between the bottom and top numbers inclusive that you specify. Inclusive means the two numbers you specify are included.

The example I am using lists the heights (in inches) of females and males.

Cell B2 contains the formula =RANDBETWEEN(54;75)

Cell C2 contains the formula =RANDBETWEEN(66,77)

Here is a screen shot. Click on the image for a larger view.




If you would like to remove the formula and just keep the data, highlight all of the cell that contain the formulas.

Right click on the data and click copy.

Right click on the data and hit Paste Special. When the Paste Special box comes up, make sure Numbers is the only item selected in the Selection group.

See the screen shot below. You can click the image for a larger view.