How to use excel to randomly simulate the process of coin toss

Excel is one of the most commonly used tools in our life, but it is precisely because of this universality that some people may think that mastering excel is really nothing, but Bian Xiao really finds that Excel really plays too many roles in daily life, such as coin toss experiments. Let's use excel to realize this process.

Turn on step reading mode

Tool materials:

excel20 13

computer

operational approach

0 1

Open excel, first make a table, record the positive and negative situation of coins, just two columns, and fill in the first column serial number to 1000 with sequence, as shown in the figure.

Then switch to the Data tab and select Data Analysis, as shown.

If you don't have this item on your computer, you can check the sixth step.

Select "Random Number Generator" in the pop-up data analysis dialog box, and click OK.

Select Bernoulli in the distribution term, and set the number of random numbers as 1000, P(A)=0.5.

Select b2 in the output area and click OK.

It can be seen that the simulation results have been generated in column B, 0 and 1. We use 1 for the front and 0 for the back.

Set a simple statistical table next to it, such as "= countif (B2: b 1 001,1)" in the cell. Change 1 to 0 later to make statistics.

Some people may not find the option of data analysis on their computers. You can open the file, click Options, select the analysis tool library, click Go, and then select Load.