T.DIST

Examples

• =T.DIST(3,10,1)

  The T.DIST function can also be used to calculate the probability of getting a specific number of successes. For example, if you want to know the probability of getting exactly 3 successes out of 10 trials, you can use the preceding syntax. The first argument is the number of successes, the second argument is the total number of trials, and the third argument is the number of successes required for success (in this case, 1, since any success is counted as a success). This will return the probability of getting exactly 3 successes in 10 trials.

• =T.DIST(3,10,TRUE)

  The T.DIST function can also be used to calculate the cumulative probability of getting a certain number of successes or more. For example, if you want to know the probability of getting at least 3 successes out of 10 trials, you can use the preceding syntax. The first argument is the number of successes, the second argument is the total number of trials, and the third argument is TRUE to indicate that we want a cumulative probability (as opposed to the probability of getting exactly 3 successes). This will return the probability of getting at least 3 successes in 10 trials.

• =T.DIST(3,10,TRUE,2)

  The T.DIST function also allows you to specify the type of distribution used to calculate the probability. For example, if you want to calculate the probability using the Poisson distribution, you can use the syntax above. The first three arguments are the same as in the previous example, but the fourth argument is 2 to indicate that we want to use the Poisson distribution. This will return the probability of getting at least 3 successes in 10 trials, using the Poisson distribution.