How to simulate coin toss experiment with excel

Switch to the Data tab and select Data Analysis. Select "Random Number Generator" in the pop-up data analysis dialog box, and click OK to simulate.

Select Bernoulli in the distribution item, set the number of random numbers as 1000, and select b2 in the output area with P(A)=0.5. Click OK, and you can see that the simulation results have been generated in column B, 0 and 1. We use 1 for the front and 0 for the back, and build a simple statistical table beside it.

For example, enter "= countif (B2: b 1 00 1,1)" in the cell on the front, and change1to 0 on the back to make statistics. Some people may not find the option of data analysis on their computers, so you can open the file, click Options, select the analysis tool library, click Go, and then select Load.

Absolute quotation

Absolute cell references in cells (for example, $A$ 1) always refer to the cell at the specified location. If the position of the cell where the formula is located changes, the absolute reference remains the same. If you copy a formula in multiple rows or columns, the absolute reference will not be adjusted. By default, new formulas use relative references, and they need to be converted to absolute references. For example, if you copy the absolute reference in cell B2 to cell B3, the absolute reference in both cells is the same, which is $A$ 1.