Current location - Education and Training Encyclopedia - University ranking - Experimental results and analysis of basic knowledge of excel
Experimental results and analysis of basic knowledge of excel
1. First, open excel in the computer, as shown in the figure below, and enter the operation main page.

2. At this point, enter the number of experiments, success rate and success times in the table, and set the probability of experimental results, as shown in the figure below.

3. Then put the mouse on D2 and enter =BINOM. DIST. Range (A2, B2, C2), as shown in the figure below.

4. After the input is completed, finally press and hold the Enter key, as shown in the figure below, and the probability of returning the experimental results is set.