Random number generator. Excel Random Number Generator in Functions and Data Analysis

We have a sequence of numbers, consisting of almost independent elements that obey a given distribution. Usually evenly distributed.

How to generate random numbers in excel different ways and ways. Let's take a look at the best of them.

Random Number Function in Excel

1. The RAND function returns a random uniformly distributed real number. It will be less than 1, greater than or equal to 0.
2. The RANDBETWEEN function returns a random integer.

Let's look at their use with examples.

Selecting random numbers with RAND

This function does not require any arguments (RAND()).

To generate a random real number between 1 and 5, for example, use the following formula: =RAND()*(5-1)+1.

The returned random number is evenly distributed over the interval .

Each time the worksheet is calculated, or the value in any cell in the worksheet changes, a new random number is returned. If you want to save the generated population, you can replace the formula with its value.

1. We click on a cell with a random number.
2. Highlight the formula in the formula bar.
3. Press F9. AND ENTER.

Let's check the uniformity of distribution random numbers from the first sample using a distribution histogram.

The range of vertical values ​​is frequency. Horizontal - "pockets".

RANDBETWEEN function

The syntax of the RANDBETWEEN function is (lower bound; upper bound). The first argument must be less than the second. Otherwise, the function will throw an error. The bounds are assumed to be integers. The formula discards the fractional part.

An example of using the function:

Random numbers with 0.1 and 0.01 precision:

How to make a random number generator in Excel

Let's make a random number generator with the generation of a value from a certain range. We use a formula like: =INDEX(A1:A10;INTEGER(RAND()*10)+1).

Let's make a random number generator in the range from 0 to 100 with a step of 10.

From the list of text values, you need to select 2 random ones. Using the RAND function, we compare text values ​​in the range A1:A7 with random numbers.

Let's use the INDEX function to select two random text values ​​from the original list.

To select one random value from the list, apply the following formula: =INDEX(A1:A7,RANDBETWEEN(1,COUNT(A1:A7))).

Normal Distribution Random Number Generator

The functions RAND and RANDBETWEEN produce random numbers with a single distribution. Any value with the same probability can fall into the lower limit of the requested range and into the upper one. It turns out a huge spread from the target value.

Normal distribution means that most of the generated numbers are close to the target. Let's correct the RANDBETWEEN formula and create a data array with a normal distribution.

The cost of goods X is 100 rubles. The entire batch produced is subject to a normal distribution. The random variable also follows a normal probability distribution.

Under such conditions, the average value of the range is 100 rubles. Let's generate an array and build a graph with a normal distribution for standard deviation 1.5 rubles.

We use the function: =NORMINV(RAND();100;1.5).

Excel calculated which values ​​are in the range of probabilities. Since the probability of producing a product with a cost of 100 rubles is maximum, the formula shows values ​​​​close to 100 more often than the rest.

Let's move on to plotting. First you need to create a table with categories. To do this, we divide the array into periods:

Based on the data obtained, we can form a diagram with a normal distribution. The value axis is the number of variables in the interval, the category axis is the periods.

Various lotteries, drawings, etc. are often held in many groups or publics on social networks, Instagram, etc., and are used by account owners to attract new audience to the community.

The result of such draws often depends on the luck of the user, since the recipient of the prize is determined randomly.

For such a determination, draw organizers almost always use an online random number generator or a pre-installed one that is distributed free of charge.

Choice

Quite often, it can be difficult to choose such a generator, since their functionality is quite different - for some it is significantly limited, for others it is quite wide.

Implemented enough a large number of such services, but the difficulty is that they differ in scope.

Many, for example, are tied by their functionality to a certain social network(for example, many generator applications on VKontakte only work with links from this social network).

Most simple generators simply determine a random number in a given range.

This is convenient because it does not associate the result with a specific post, which means that they can be used for draws outside the social network and in various other situations.

They don't really have any other use.

<Рис. 1 Генератор>

Advice! When choosing the most suitable generator It is important to consider the purpose for which it will be used.

Specifications

For the fastest process of choosing the optimal online random number generation service, the table below shows the main specifications and functionality of such applications.

All applications discussed in the table are described in more detail below.

<Рис. 2 Случайные числа>

randstuff

<Рис. 3 RandStuff>

You can use this application online using the link to its official website http://randstuff.ru/number/.

This is a simple random number generator, characterized by fast and stable operation.

It is successfully implemented both in the format of a separate independent application on the official website, and as an application in the VKontakte social network.

The peculiarity of this service is that it can choose a random number both from the specified range and from a specific list of numbers that can be specified on the site.

Pros:

• Stable and fast work;
• Lack of direct link to the social network;
• You can select one or more numbers;
• You can only choose from the given numbers.

Minuses:

• The impossibility of holding a draw on VKontakte (this requires a separate application);
• Applications for VKontakte do not run in all browsers;
• The result sometimes seems predictable, since only one calculation algorithm is used.

User reviews about this application are as follows: “We determine the winners in VKontakte groups through this service. Thank you”, “You are the best”, “I use only this service”.

Cast Lots

<Рис. 4 Cast Lots>

This application is a simple function generator, implemented on the official website, in the form of a VKontakte application.

There is also a generator widget to embed on your site.

The main difference from the previous described application is that this allows you to disable the repetition of the result.

That is, when conducting several generations in a row in one session, the number will not repeat.

• The presence of a widget to insert on a website or blog;
• Ability to disable the repetition of the result;
• The presence of the function "even more randomness", after the activation of which the selection algorithm changes.

Negative:

• The impossibility of determining several results at once;
• Inability to select from a specific list of numbers;
• To select a winner in public, you must use a separate VKontakte widget.

User reviews are as follows: “It works stably, it is quite convenient to use”, “Convenient functionality”, “I use only this service”.

Random number

<Рис. 5 Случайное число>

This service is located at http://random number.rf/.

A simple generator with minimum of functions and additional features.

Can randomly generate numbers within a given range (maximum from 1 to 99999).

The site does not have any graphic design, and therefore the page is easy to load.

The result can be copied or downloaded with the click of a button.

Negative:

• No widget for VKontakte;
• There is no possibility of holding draws;
• There is no way to insert the result into a blog or website.

Here is what users say about this service: “Good generator, but not enough functions”, “Very few features”, “Suitable for quickly generating a number without unnecessary settings.”

Randomus

<Рис. 6 Рандомус>

You can use this random number generator at http://randomus.ru/.

Another simple one, but functional random number generator.

The service has sufficient functionality for determining random numbers, however, it is not suitable for holding draws and other more complex processes.

Negative:

• The impossibility of holding draws based on post reposts, etc.
• There is no application for VKontakte or a widget for the site;
• It is not possible to disable repeating results.

Etc., and is used by account owners to attract new audiences to the community.

The result of such draws often depends on the luck of the user, since the recipient of the prize is determined randomly.

For such a determination, draw organizers almost always use an online random number generator or a pre-installed one that is distributed free of charge.

Choice

Quite often, it can be difficult to choose such a generator, since their functionality is quite different - for some it is significantly limited, for others it is quite wide.

A fairly large number of such services are being implemented, but the difficulty is that they differ in scope.

Many, for example, are tied with their functionality to a specific social network (for example, many generator applications only work with links of this one).

The simplest generators simply generate a random number within a given range.

This is convenient because it does not associate the result with a specific post, which means that they can be used for draws outside the social network and in various other situations.

They don't really have any other use.

Advice! When choosing the most suitable generator, it is important to consider the purpose for which it will be used.

Specifications

For the fastest process of choosing the optimal online random number generation service, the table below shows the main technical characteristics and functionality of such applications.

All applications discussed in the table are described in more detail below.

randstuff

You can use this application online using the link to its official website http://randstuff.ru/number/.

This is a simple random number generator, characterized by fast and stable operation.

It is successfully implemented both in the format of a separate independent application on the official website, and as an application in .

The peculiarity of this service is that it can choose a random number both from the specified range and from a specific list of numbers that can be specified on the site.

• Stable and fast work;
• Lack of direct link to the social network;
• You can select one or more numbers;
• You can only choose from the given numbers.

User reviews about this application are as follows: “We determine the winners in VKontakte groups through this service. Thank you”, “You are the best”, “I use only this service”.

Cast Lots

This application is a simple function generator, implemented on the official website, in the form of a VKontakte application.

There is also a generator widget to embed on your site.

The main difference from the previous described application is that this allows you to disable the repetition of the result.

With this generator you will be able to generate random numbers in any range. This generator will also allow you to randomly select or determine a number from a list. Or create an array of random numbers from 2 to 70 elements. This online tool will not only allow you to generate one (1), two (2) or three-digit (3) random numbers, but also five and seven. Easy to set up. Everyone can master it. You will also be able to choose random numbers for online or offline lotteries or contests. And it will be convenient. You can easily create entire tables or rows of random numbers. In a fraction of a second, you will receive a random number or their sequence (set) on your screen. If you take a sequence of your numbers, then the algorithm will choose a random one or random ones, any one can fall out. You yourself can use this tool to conduct draws. By choosing, for example, the same range and number of numbers as a result, you can generate a random sequence (combination). You can also choose random letter combinations and words. This tool, like everything on our site, is absolutely free to use (no exceptions).

Enter range numbers

Changing the Range to Generate a Random Number

1..10 1..100 1..1000 1..10000 for lottery 5 out of 36 for lottery 6 out of 45 for lottery 6 out of 49 for lottery 6 out of 59

Number of random numbers (1)

Eliminate repetitions

Select random values ​​from the list (separate by commas or spaces, if commas are found, the division will be made by them, otherwise by spaces)

It is an obvious fact that luck plays an important role in any undertaking. But when playing the lottery, you need to understand that fortune is the only factor on which the fulfillment of your dreams depends. In the majority of lotteries, to get the jackpot you just need to guess certain numbers in some range. In this case, the one presented on our website is able to help.

We offer to try a simple generator for free, which is able to completely eliminate the influence of the human factor and increase the chance of winning. We also provide the best and most functional, but simple generators, as well as services that can predict winning combinations of numbers based on special analysis algorithms.

If you want to try your luck in one of the popular lotteries (4 out of 20, 5 out of 36, 6 out of 45), but don't know which numbers can increase your chances of winning, then we can help. Next, we bring to your attention overview of TOP 5 most functional, but at the same time easy-to-use lottery number generators with many additional features and opportunities.

First, let's analyze the main criteria of the above list.:

TOP 1 - Number Generator GSgen.RU

Description: Built-in software implemented in the Javascript programming language and is a pseudo-random number generator. Evenly distributes random numbers, thereby eliminating the subjective perception of the players, which affects the manual selection.

Advantages: The RNG script allows you to pick up lucky numbers for Gosloto (and not only) various variations from preset modes. There is a possibility of individual settings for other types of lotteries. Available for free use.

Flaws: It is not possible to enter exclusion numbers that are not desirable to see, you cannot get several combinations at once and get a link to the finished result.

TOP 2 - Generator Soft-Arhiv

Description: Another service for generating midrange for Russian lotteries. It is enough to choose the necessary combination and get the finished result. No additional software is required for use, as it works great online.

Advantages: Has a simple, visual form for filling out and receiving results. The ability to select a ready-made lottery type, generation settings allows you to enable exceptions and the number of required combinations make the service very convenient to use. Also completely free functionality.

TOP 3 - RNG: Calculator888

Description: Calculator888 is in the honorable third place of the considered services. Like the previous options, it allows you to get the required number of numbers without special efforts. Even a novice network user can use the random number generator, since everything is intuitive.

Advantages: Wide settings will allow you to generate the required number of numbers, set their range, and also define input options. In addition, unlike previous services, it allows you to get a link to the result. Completely free.

Flaws: The disadvantages include the lack of a choice of ready-made types of lottery, which forces you to independently form the task. You cannot introduce exceptions and get several combinations at once. Accounting for past runs is also not made.

Number generators based on past draws

It is worth paying your attention to the fact that there are special services that can predict lucky numbers that you need to bet on. Their creators assure users that the analysis and issuance of results is carried out on the basis of the results of the runs, the use probability theory and other mathematical calculations.

However, you should not unconditionally believe in it. We definitely do not believe in this and believe that any of these services are those that randomly give a result similar to any other RNG.

However, you can check it yourself. Next, we present two more services that provide the ability to select results for state lotto, viking loto, keno, sports lotto, etc. taking into account their past circulations. The functionality of some of them is paid.

Let us draw your attention to the fact that it is not worth paying money for a paid forecast, as it is just money down the drain for combinations that any other can give out free service. So the continuation the best services for generation, taking into account the analysis of past runs:

TOP 4 - RNG with circulation: Fortunablog

Description: According to the developer, the script is able not only to give out digital combinations at random, but also analyzes previously dropped balls based on a number of algorithms and probability theory. It is also stated that the purpose of the generator is to select a combination for the jackpot.

Advantages A: There are two preset lottery types that you can try your luck in picking. However, the main advantage is positioned as taking into account the results of past runs and, importantly, free use.

TOP 5 - Lottery Generator Based on Circulations: Igraivloto

Description: The presented service allows you to get combinations of the most probable winning combinations. The principle of operation is similar to the previous options considered, with the exception of certain points of functionality.

Advantages: It is a ready-made script for issuing a forecast for the Gosloto 6 out of 45 lottery, which eliminates the need to select the required draw. It positions itself as a site that works on special algorithms and filters that create the most probable forecasts based on the runs. Allows you to get multiple results at once and share a link to the result.

Flaws: It is not possible to enter a range of numbers and necessary exceptions. However, the biggest disadvantage is the provision of paid forecasts, which clearly distinguishes it from the free previous analogues.

Conclusion

It is up to you, of course, to use the considered services or not. On the one hand, the use of such sites can help you choose certain combinations, freeing you from a difficult choice, since, for example, for drawing 5 out of 36, absolutely any combination generated or manually selected by the player himself has a probability of winning 1 to 376,992.

Table showing the probability of winning the lottery:

Compared to other lottery strategies, this option has good chances of winning. However, it is important to understand what to use paid predictions in this case is not appropriate and does not correspond to the probability of winning.