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.