Discrete Random Variables – Excel Tools Instruction

Download Discrete Random Variables – Excel Instructions Data Sets [XLSX].

Binomial Distribution

  • A more valuable probability density function with many applications is the binomial distribution. This distribution will compute probabilities for any binomial process.

Binomial Distribution in Excel

A fair coin is flipped 15 times. Each flip is independent. What is the probability of getting more than ten heads?

Let X = the number of heads in 15 flips of the fair coin. X takes on the values

  1. Enter the value of n and p. Create a table for the probability and cumulative of 0, 1, 2, 3, …, 15.
  2. Enter =BINOM.DIST(A5,$B$1,$B$2,FALSE) in cell B5, click Enter
  3. Click B5, move the mouse to the right bottom corner, a little + shows up
  4. Click on the little + and drag down
Step 1 & 2: Enter the value of n and p. Create a table for the probability and cumulative of 0, 1, 2, 3, …, 15. Enter =BINOM.DIST(A5,$B$1,$B$2,FALSE) in cell B5, click Enter
Step 3 & 4: Click B5, move the mouse to the right bottom corner, a little + shows up. Click on the little + and drag down
  1. Enter =BINOM.DIST(A5,$B$1,$B$2,TRUE) in cell C5, click Enter
  2. Click C5, move the mouse to the right bottom corner, a little + shows up
  3. Click on the little + and drag down
Step 5: Enter =BINOM.DIST(A5,$B$1,$B$2,TRUE) in cell C5, click Enter
Step 6 & 7: Click C5, move the mouse to the right bottom corner, a little + shows up. Click on the little + and drag down

Media Attributions

License

Icon for the Creative Commons Attribution 4.0 International License

Introduction to Business Statistics Problem Ancillary Materials: Yukon Edition Copyright © by Lisa Kanary is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book