Randomly populate normally distributed numbers in an excel sheet

Use a random number generator:

1.Tools - Load Macros - Analysis Tools Library (skip if installed);

2.Tools - Data Analysis - Random Number Generator;

Pictured: <>

normdist(x,mean,standard dev,cumulative)cumulative is a logical value, if it is 0, it is a density function, if it is 1, it is a cumulative distribution function. If you plot a normal distribution, it is 0. For example, for a normal distribution with a mean value of 10% and a standard value of 20%, first knock in a variable in a1, assume 50, select column a, point fill sequence, select column, equal difference series, step value 10, stop value 70.

Then type normdist (a1,10,20,0) in b1, the return value is, select b1, when the mouse turns into a black cross in the lower right corner, pull down to b13, select the a1b13 area, click the chart wizard on the toolbar scatter plot, select the second figure in the first row, click next, default settings, next, write the title by yourself, remove the tick in the grid line, remove the tick in the legend, click next, and finish. The diagram is preliminarily completed. The following is to fine-tune the mouse to right-click on the coordinate axis of the graph, select the coordinate axis format, fill in the scale you want the minimum value, the maximum value, the main scale unit (the numerical interval on the x-axis), the y-axis crossover (when y is 0, how much x) and so on.

Material Tools: Excel2010

1. Create a new workbook, and prepare to insert random values in the cell area (red box in the figure) of A1-F20, taking the value between "8-88" as an example.

2. Click cell A1 (indicated by the red arrow in the figure), enter "=ran" in the cell, and click "randbetween" (pointed by the blue arrow in the figure) function in the pop-up function menu.

3. The format of the randbetween function is shown in the red box in the following figure.

4. Fill in the values at both ends of the value range, and fill in the comma separately as "=randbetween(8,88)" (blue box in the figure).

5. After entering, a random value (red box in the figure) is obtained, and the formula is filled to the "f" column (pointed by the blue arrow in the figure) by using the filling handle (indicated by the red arrow in the figure).

6. Then use the filling handle (indicated by the red arrow in the figure) to fill the formula to the "20" line (pointed by the blue arrow in the figure).

7. Get the final effect as shown in the figure below to complete the setting.

If you are using Excel2007 or later:

A1 Write the formula:

choose(randbetween(1,4),, drag down to copy.

If you use Excel2003, please ask!

=rand() is a random number between 0 and --1.

round(rand(),2) keeps two digits of random numbers, and it can only tell you so much, because I don't see what you mean by random and specific numbers.

You can use rand random functions, integer functions, etc.

The return value of the rand function is a random number of 0-1, no argument is required, if you want a random integer of 0-10, you can use =rand()*10, if you want to take an integer, you can use the int() function, as shown in the following example:

If you want to take an integer from 3 to 13, you can express it in the following example:

1. Open the ** you want to set, add here we need to enter 7 numbers, if a single type into it is very inconvenient and a waste of time.

2. Select the cell, put the mouse in the lower right corner of the cell, and the mouse will be displayed in the style of a cross.

After the mouse is placed, drag and drop, the number is sorted vertically, then drag down, if it is horizontal, then drag horizontally, and the vertical sorting is set.