Generating random numbers


show more Generating random numbers provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Generating random numbers

For a lot of people the term random number might sound a bit obscure, but it is a mathematical capability that has at least two good uses for wide applicability in Excel. One might be in the following situation. You might have a database. Now it could be about people, it might be about inventory, it might be about sales. Here and there and certain kinds of lists, you want to randomize the order. Maybe you have a certain primitive way of spot checking some data, your own idea of quality control.

How do we take this list and randomize it? Either add an empty column on the right- hand side or left side, it doesn't make any difference, and even though that doesn't say random, I am just going to type in random here just a small indicator here. We are going to be putting in a random number here that will actually allow us to sort. So one function is called =rand(). It's one of those functions that has parenthesis, but nothing between them so we need to only type the left one. We can press...

Generating random numbers
Video duration: 3m 16s 3h 43m Intermediate

Viewers:

Generating random numbers provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...