HOW TO CALCULATE NUMERICAL PROBABILITIES IN EXCEL

fact function to find the combination].

The fact function is a function that finds combinations.

For example, there are several ways to combine 9 digits without repeats, and the following formula can be used.

fact(9)。

permut calculates the probability of choosing 5 out of 11].

Example 2, how many permutations are there for 5 out of 11, and you can find permut(11,5) with a formula

You can also use the fact function to get this result by =fact(11) fact(11-5).

The combin function calculates the probability of winning the jackpot in the Fucai two-color ball] There are 33 red balls and 16 blue balls in the Fucai two-color ball, so you should choose 6 in the red ball and 1 in the blue ball, so the probability of winning the jackpot is expressed by the formula =1 combin(33,6) combin(16,1).

You want to set the number of decimal points displayed in the cell. Result].

This requires the use of functions in the excel sheet.

Used to count the number of cells in the region that meet the given criteria.

Grammar. countif(range,criteria)range is the range of cells that you need to calculate the number of cells that meet the criteria.

criteria

To determine which cells will be counted as a condition, they can be in the form of numbers, expressions, or text. For example, a condition can be expressed as:

If you want to know the probability of the number 1 appearing in cells A1 to A7, you can select cell A8 and enter =countif(A1:A7,1) in the formula bar

In fact, you can know this with the help in excel, I hope it will help you.

1. The following figure is an example of statistical data. For the number of times you log in to the product per day, enter the corresponding number and start processing.

2. Sort the data first, sort from descending, and then select Custom Sort in the "Sort Shout" on the "Start" tab to operate.

3. The number of main keyword selections, sorting by selection value, and the sorting method we can choose to sort in descending order.

4. Start calculating the cumulative probability. The first cell is the value divided by the total.

5. From the second row of the cumulative percentage, we can see that the difference in the calculation formula is equal to the number of the previous row plus the number of rows divided by the total, and the absolute reference total is used.

6. Finally, you can use the padding function to calculate the cumulative percentage directly, and use the flag to check if the correct percentage of reincarnation is 100 on the last line.

Excel often needs to use functions to calculate probabilities, how to calculate probabilities? The following is a tutorial on calculating probabilities in excel that I shared for you to read and learn.

Excel** Tutorial for Calculating Probability Sheds:

Calculate the probability of which burn Step 1: Combine the fact function.

The fact function is a function that finds combinations.

For example, 9 can be combined with 9 digits without repeats, and the following formula =fact(9) can be used.

Calculate the probability step 2: Permut to calculate the permutation calculation to choose 5 out of 11

probability. Example 2, how many permutations are there for 5 out of 11, and you can find permut(11,5) with a formula

Step 3: You can also use the fact function to obtain this result, the formula is =fact(11) fact(11-5).

Three, the combin function calculates the jackpot and the virtual rate of the Fucai two-color ball.

Step 4: There are 33 red balls and 16 blue balls in the Fucai two-color ball, so you should choose 6 red balls and 1 blue ball, so the probability of winning the jackpot is expressed by the formula =1 combin(33,6) combin(16,1).

You want to set the number of decimal points displayed in the cell.

Calculate the probability Step 5: The results are out.

Here is a way to calculate the probability of one number to another using Excel.

Device: Lenovo computer.

System: win7

Software: Excel2019 Personal Edition.

1. First open WPS and create Excel**.

<>3. Select the cell you want to display the result, click the function insert button, and the function search dialog box will pop up.

4. In the function search dialog box, look for the "socks" = function, and then click OK.

5. After it is determined, it can be rolled to see the probability calculated according to the requirements.

Here's how to calculate the probability with Excel:

1. For example, there are six numbers from 1 to 6, let's calculate their permutations and combinations, we first select the cell and input =1 fact (numeric value); This is shown in the following diagram:

2. The fact function is the factorial of the number, in parentheses we can customize the input value, here we enter 6; As shown in the figure below:

3. Click enter to obtain the total number of 6 numbers of permutations, and divide 1 by the total number of flushing beams to obtain the probability value of one of them in the permutation; As shown in the figure below:

4. Return the permutation values of a number of selected objects in a given set (the most common is 5 out of 11 in the lottery). As shown in the figure below:

5. We enter the =1 permut() formula in the cell; As shown in the figure below:

6. The parameters in permut() are the total number of objects, the number of objects in each arrangement, for example, 5 select 2, we enter 5 and 2, and click enter to find the sum of their arrangement; The probability value can be obtained by using 1 place to get the total number. As shown in the figure below:

1. Combine the fact function.

The fact function is a function that finds combinations.

For example, 9 can be combined with 9 digits without repeats, and the following formula =fact(9) can be used.

2. Permut calculates the probability of choosing 5 out of 11.

Example 2, how many permutations are there for 5 out of 11, and you can find permut(11,5) with a formula

You can also use the fact function to get this result by =fact(11) fact(11-5).

3. The combin function calculates the probability of winning the jackpot in the Fucai two-color ball.

There are 33 red balls and 16 blue balls in the Fucai two-color ball, so you have to choose 6 red balls and 1 blue ball, so the probability of winning the jackpot is expressed by the formula =1 combin(33,6) combin(16,1).

You want to set the number of decimal points displayed in the cell.

Fourth, the results are out.

In the case of the lottery, each time the number appears is related to the previous data, that is, the probability is a separate ......The last digit has a chance of 0 9 each, a 10% ah......

fact function to find the combination].

The fact function is a function that finds combinations.

For example, 9 can be combined with 9 digits without repeats, and the following formula =fact(9) can be used.

permut calculates the probability of choosing 5 out of 11].

Example 2, how many permutations are there for 5 out of 11, and you can find permut(11,5) with a formula

You can also use the fact function to get this result by =fact(11) fact(11-5).

The combin function calculates the probability of winning the jackpot in the Fucai two-color ball

There are 33 red balls and 16 blue balls in the Fucai two-color ball, so you have to choose 6 red balls and 1 blue ball, so the probability of winning the jackpot is expressed by the formula =1 combin(33,6) combin(16,1).

You want to set the number of decimal points displayed in the cell.

Result].

Here's how to calculate the probability with Excel:

1. For example, there are six numbers from 1 to 6, let's calculate their permutations and combinations, we first select the cell and input =1 fact (numeric value); As shown in the figure below:

2. The fact function is the factorial of the number, in parentheses we can customize the input value, here we enter 6; As shown in the figure below:

3. Click Enter to find the total number of 6 numbers in the permutation, and divide 1 by the total number to get the probability value of one of the permutations; As shown in the figure below:

4. Return the permutation values of a number of selected objects in a given set (the most common is 5 out of 11 in the lottery). As shown in the figure below:

5. We enter the =1 permut() formula in the cell; As shown in the figure below:

6. The parameters in permut() are the total number of objects, the number of objects in each arrangement, for example, we choose 2 out of 5, we enter 5 and 2, and click enter to find the sum of their arrangement; The probability value can be obtained by using 1 place to get the total number. As shown in the figure below:

Here's a calculation of the probability of conducting a lottery for reference:

1. Fact function to find combination: The fact function is a function to find combination.

For example, there are several ways to combine 9 digits from 1 to 9 without repeats, and you can use the following formula =fact(9).

2. Permut calculates the probability of choosing 5 out of 11.

For example, if there are many permutations of 5 out of 11, you can find =permut(11,5) with a formula

3. You can also use the fact function to obtain this result, the formula is =fact(11) fact(11-5).

Fourth, the combin function calculates the probability of winning the jackpot in the Fucai two-color ball.

There are 33 red balls and 16 blue balls in the Fucai two-color ball, and you should choose 6 in the red ball and 1 in the blue ball, so the probability of winning the jackpot is expressed by the formula =1 combin(33,6) combin(16,1) to set the number of decimal points displayed in the cell:

Fifth, the results are out:

6. So how much does it cost to win the jackpot, which is expressed by the formula =combin(33,6)*combin(16,1)*2, and the result needs to cost 35442176 yuan to win the jackpot.

This is too difficult, the random number is not calculated, even if it is calculated and the actual number will not be the same, just like the lottery ball appears, if that can also **, then go directly to buy a lottery ticket!

Your question is not a statistical problem, it is impossible to calculate at all, or if you admit that there are statistical laws, you can only say what the probability of a certain combination of numbers is.

1. Combine the fact function.

The fact function is a function that finds combinations.

For example, 9 can be combined with 9 digits without repeats, and the following formula =fact(9) can be used.

2. Permut calculates the probability of choosing 5 out of 11.

Example 2, how many permutations are there for 5 out of 11, and you can find permut(11,5) with a formula

You can also use the fact function to get this result by =fact(11) fact(11-5).

3. The combin function calculates the probability of winning the jackpot in the Fucai two-color ball.

There are 33 red balls and 16 blue balls in the Fucai two-color ball, so you have to choose 6 red balls and 1 blue ball, so the probability of winning the jackpot is expressed by the formula =1 combin(33,6) combin(16,1).

You want to set the number of decimal points displayed in the cell.

Fourth, the results are out.

In the example you gave, you must write the calculation formula yourself, and Excel cannot prepare such a smart function for you. This is the probability that a maximum of two critical hits will occur in 5 times, and the other times will not occur, which is in line with Bernoulli's generalization, p=c5(0)*

where c5(2) represents the total number of methods that take two (no order) from any of the 5 (in no order) and the number of combinations.

Just enter this formula into it and you're good to go. If you want it to be a little portable, if 50% of the data is in a1, enter :

combin(5,0)*a1^0*(1-a1)^5+combin(5,1)*a1^1*(1-a1)^4+combin(5,2)*a1^2*(1-a1)^3

But now that you understand the origin of this formula, you can also list the formula yourself in other situations in the future, and then enter it into excel for calculation.

And different hi me.