Example of probability density function (PDF)

The coach of a baseball team wants to know the probability that a particular player hits one home run during a game in which the player goes up to bat 4 times. Based on the player's past games, the coach assumes that the player has a 0.10 probability of hitting a home run in the current game. Because the player will either hit a home run or will not for each time at bat, the coach uses the binomial distribution.


This example uses the binomial distribution. However, you follow these same steps for any distribution that you select.

  1. In the column name cell of an empty worksheet column, type HRs.
  2. Copy and paste, or type the following data into the HRs column.
    These values represent the number of home runs that the player could hit over the duration of the game.
  3. Choose Calc > Probability Distributions > Binomial.
  4. Select Probability.
  5. In Number of trials, enter 4.
  6. In Event probability, enter 0.10.
  7. In Input column, enter HRs.
  8. Click OK.

Interpret the results

The probability that the baseball player will hit one home run over 4 attempts is 0.2916. The probability that the player does not hit a home run over 4 attempts is 0.6561. The probabilities of hitting more than one home run during the game are much smaller. For example, the probability that the player will hit a home run each of the 4 attempts is 0.0001.

Binomial with n = 4 and p = 0.1

xP( X = x )