Create a Binomial Probability Distribution by following the steps below. 1. Label column A as x...
Create a Binomial Probability Distribution by following the steps below.
1. Label column A as x
2. Label Column B as P(x)
3. In Column A, list the numbers 0 to 12. What do these numbers represent in our situation?
4. Click on cell B2. Click on fx. Choose STATISTICAL then BINOM.DIST.
5. In the dialog box:
Number_s is the number of successes. Click on cell A2
Trials refers to the total number of trials, in our case 12 donors so type in 12.
Probability_s is the probability of success, in our case 40% or .4 since that is the probability of Type A blood.
Cumulative: FALSE or 0 calculates the probability of EXACTLY x successes. TRUE or 1 calculates the probability of X OR FEWER successes. We are constructing the frequency distribution so we want the EXACT probability for each x. In symbols, we want P(x) for each x = 0, 1, 2, ...., 12. Type in FALSE or 0.
6. Use the fill handle to complete the table for all values of x. Format cells to give 3 decimal places.
7. Make a probability histogram (Insert -> Column Chart).
8. What is the shape of your histogram?
ANSWER THE FOLLOWING QUESTIONS: Each donor gives 1 unit of blood. What is the probability that exactly 5 units collected in this drive will be type A?
What is the probability that 5 or fewer units collected in this drive will be type A?
Our patient requires 5 units of of Type A blood for his upcoming surgery. What is the probability that this blood drive will get him what he needs?
(Hint: it's possible that more than 5 donors will have Type A blood, too.)
Homework Answers
Add Answer to:
Create a Binomial Probability Distribution by following the
steps below.
1. Label column A as x...
Styles First we will learn how to evaluate binomial distribution with the help of Excel. Let's...
Styles First we will learn how to evaluate binomial distribution with the help of Excel. Let's flip a coin n times and count how many tails we are going to get. If n=0, then no coin is tossed and the only option is 0 tails. Therefore P(0)=1, the mean is 0 and the standard deviation is 0. We are going to do a simple table for n=0. First we will define columns. Click on cell A1 and type X for...
1.- A random variable follows a binomial distribution with a probability of success equal to 0.72....
1.- A random variable follows a binomial distribution with a probability of success equal to 0.72. For a sample size of n=12, find the values below. a. the probability of exactly 5 successes b. the probability of 6 or more successes c. the probability of exactly 11 successes d. the expected value of the random variable a. The probability of exactly 5 successes is (Round to three decimal places as needed.) b. The probability of 6 or more successes is...
ial Expériments and Binomial Distributions A binomial experiment is a probability experiment with a number of...
ial Expériments and Binomial Distributions A binomial experiment is a probability experiment with a number of repeated trials and the following properties: . Each trial has two outcomes. . The outcomes of each trial are independent of other trials. . The probability of each specific outcome is uniform across tr Example 1: We roll a standard 6-sided die three times. Each time we roll the die, we record whether the die landed on a number less than 5, or not....
Create a Categorical Frequency Table and Grouped Frequency Distribution table in Excel using the above data...
Create a Categorical Frequency Table and Grouped Frequency
Distribution table in Excel using the above data
Example 2-1 Distribution of Blood Types Twenty-five army inductees were given a blood test to determine their blood type. The data set i:s ВВАВ B AO О O A AB B Construct a frequency distribution for the data Categorical Frequency Table (Qualitative or Discrete Data) 1. In an open workbook select cell A1 and type in all the blood types from Example 2-1 down...
Assume that a procedure yields a binomial distribution with nequals7 trials and a probability of success...
Assume that a procedure yields
a binomial distribution with nequals7 trials and a probability of
success of pequals0.30. Use a binomial probability table to find
the probability that the number of successes x is exactly 1.
p(1)-?
We were unable to transcribe this image012345601234567012345678 262 3 9 0+ 0+ 0+ 002 001 220 rps 0 0 0 0 004 on 201 0 0 0 0 0 005 001 95 70++ 001 010 000 ies ZA 200 110 0+ 004 005...
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of...
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of both dice. • Create a new Excel sheet in your document. Click on cell Al, then click on the function icon f. and select Math&Trig, then select RANDBETWEEN. In the dialog box, enter 1 for bottom and enter 6 for top. • After getting the random number in the first cell, click and hold down the mouse button to drag the lower right corner...
X 0 1 2 3 5 6 7 9 10 11 12 Assume that 12 jurors...
X 0 1 2 3 5 6 7 9 10 11 12 Assume that 12 jurors are selected from a population in which 80% of the people are Mexican-Americans. The random variable x is the number of Mexican-Americans on the jury P(x) 0.000 0.000 0.000 0.000 0.001 0.003 0.0160.053 0.133 0.236 0.283 0.2060.069 a. Find the probability of exactly 5 Mexican-Americans among 12 jurors. P(5)-( b. Find the probability of 5 or fewer Mexican-Americans among 12 jurors. The probability of...
Ti 10. Placuice Lidl 2 (FW 4 thu nwb) This Question: 1 pt 11 of 13...
Ti 10. Placuice Lidl 2 (FW 4 thu nwb) This Question: 1 pt 11 of 13 (8 complete) X Assume that 12 jurors are selected from a population in which 50% of the people are Meccan Americans. The random variable x is the number of Mexican Americans on the jury 0 1 2 3 4 5 6 78 9 10 11 12 P(x) 0.000 0.003 0.0160 054 0 1210 1930 2260 1930.1210.0540.0160.003 0.000 2. Find the probability of exactly 4...
Assume that a procedure yields a binomial distribution with n=8 trials and a probability of success...
Assume that a procedure yields a binomial distribution with n=8 trials and a probability of success of p=0.40. Use a binomial probability table to find the probability that the number of successes x is exactly 5. Click on the icon to view the binomial probabilities table. P(5)-(Round to three decimal places as needed) Binomial Probabilities Table х 0 Binomial Probabilities P E 2 OM .us 902 095 10 110 180 30 RO O 100 010 2 20 50 320 140...
For three problems listed below determine the following : (1) what type of probability distribution would...
For three problems listed below determine the following :
(1) what type of probability distribution would be used to solve
each problem and why;
(2) pick one problem only from below and provide a detailed
solution with an explanation;
(3) indicate which problem you selected to solve in your subject
line
i. The reading speed of sixth-grade students is approximately normal, with a mean speed of 125 words per minute and a standard deviation of 24 words per minute. Find...
Styles First we will learn how to evaluate binomial distribution with the help of Excel. Let's flip a coin n times and count how many tails we are going to get. If n=0, then no coin is tossed and the only option is 0 tails. Therefore P(0)=1, the mean is 0 and the standard deviation is 0. We are going to do a simple table for n=0. First we will define columns. Click on cell A1 and type X for...
ial Expériments and Binomial Distributions A binomial experiment is a probability experiment with a number of repeated trials and the following properties: . Each trial has two outcomes. . The outcomes of each trial are independent of other trials. . The probability of each specific outcome is uniform across tr Example 1: We roll a standard 6-sided die three times. Each time we roll the die, we record whether the die landed on a number less than 5, or not....
Create a Categorical Frequency Table and Grouped Frequency
Distribution table in Excel using the above data
Example 2-1 Distribution of Blood Types Twenty-five army inductees were given a blood test to determine their blood type. The data set i:s ВВАВ B AO О O A AB B Construct a frequency distribution for the data Categorical Frequency Table (Qualitative or Discrete Data) 1. In an open workbook select cell A1 and type in all the blood types from Example 2-1 down...
Assume that a procedure yields
a binomial distribution with nequals7 trials and a probability of
success of pequals0.30. Use a binomial probability table to find
the probability that the number of successes x is exactly 1.
p(1)-?
We were unable to transcribe this image012345601234567012345678 262 3 9 0+ 0+ 0+ 002 001 220 rps 0 0 0 0 004 on 201 0 0 0 0 0 005 001 95 70++ 001 010 000 ies ZA 200 110 0+ 004 005...
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of both dice. • Create a new Excel sheet in your document. Click on cell Al, then click on the function icon f. and select Math&Trig, then select RANDBETWEEN. In the dialog box, enter 1 for bottom and enter 6 for top. • After getting the random number in the first cell, click and hold down the mouse button to drag the lower right corner...
X 0 1 2 3 5 6 7 9 10 11 12 Assume that 12 jurors are selected from a population in which 80% of the people are Mexican-Americans. The random variable x is the number of Mexican-Americans on the jury P(x) 0.000 0.000 0.000 0.000 0.001 0.003 0.0160.053 0.133 0.236 0.283 0.2060.069 a. Find the probability of exactly 5 Mexican-Americans among 12 jurors. P(5)-( b. Find the probability of 5 or fewer Mexican-Americans among 12 jurors. The probability of...
Ti 10. Placuice Lidl 2 (FW 4 thu nwb) This Question: 1 pt 11 of 13 (8 complete) X Assume that 12 jurors are selected from a population in which 50% of the people are Meccan Americans. The random variable x is the number of Mexican Americans on the jury 0 1 2 3 4 5 6 78 9 10 11 12 P(x) 0.000 0.003 0.0160 054 0 1210 1930 2260 1930.1210.0540.0160.003 0.000 2. Find the probability of exactly 4...
Assume that a procedure yields a binomial distribution with n=8 trials and a probability of success of p=0.40. Use a binomial probability table to find the probability that the number of successes x is exactly 5. Click on the icon to view the binomial probabilities table. P(5)-(Round to three decimal places as needed) Binomial Probabilities Table х 0 Binomial Probabilities P E 2 OM .us 902 095 10 110 180 30 RO O 100 010 2 20 50 320 140...
For three problems listed below determine the following :
(1) what type of probability distribution would be used to solve
each problem and why;
(2) pick one problem only from below and provide a detailed
solution with an explanation;
(3) indicate which problem you selected to solve in your subject
line
i. The reading speed of sixth-grade students is approximately normal, with a mean speed of 125 words per minute and a standard deviation of 24 words per minute. Find...
Most questions answered within 3 hours.
-
Assume that in a hydrogen atom, the electron circles the nucleus
in a circle of radius...
asked 44 seconds from now -
Describe two obstacles that makes fixing atmospheric nitrogen
difficult.
asked 4 minutes ago -
T
F 53) Most differences
between human groups are the result of biology rather than
culture....
asked 8 minutes ago -
A 5.20 mW helium neon laser emits a visible laser beam with a
wavelength of 633...
asked 11 minutes ago -
Assignment:
Your
organization has made a strategic decision
to
outsourcework
currently performed in house. You have...
asked 10 minutes ago -
A hospital performs 100 surgeries per week. The probability that
complications after surgery occur is 10%....
asked 11 minutes ago -
In preparing its cash flow statement for the year ended December
31, 2018, Green Co. gathered...
asked 12 minutes ago -
Donna is 18 years old and full time accounting student.She is
saving for an overseas holiday...
asked 13 minutes ago -
Service-oriented architectures (SOA) provide
object-oriented architectures for web platforms that represent a
collection of services. SOA...
asked 13 minutes ago -
Le Terroir Winery is considering an expansion project to produce
fine wines. The trial expansion will...
asked 22 minutes ago -
The Bahraini public budget experiences deficit in the last
seven years, what are procedures are taken...
asked 29 minutes ago -
You invested $30,000 in a mutual fund at the beginning of the
year when the NAV...
asked 33 minutes ago