Chat with us, powered by LiveChat In the discussion forum for this week, you will create a scenario that requires the use of a binomial distribution. Before posting your problem, please review the criteria for | Wridemy

In the discussion forum for this week, you will create a scenario that requires the use of a binomial distribution. Before posting your problem, please review the criteria for

 

In the discussion forum for this week, you will create a scenario that requires the use of a binomial distribution. Before posting your problem, please review the criteria for a binomial distributions by reviewing Week 5 Binomial distribution and Binomial Distribution in Excel Week 5.

Instructions:

  • For your post you will make up a problem that uses binomial distribution similar to the example below. Try to have 3 scenarios. You do not need to solve your own problem. 
  • If you can, try a probability different from .5. In your problem, make sure that the probability stays the same for each trial!  
  • You will answer problems from classmates for your responses. Copy the question and your Excel formulas into your forum posts so your professor and classmates can check your work. Then write a brief summary of the results after the problem you copied in your post. 

_______________________________________________________________

Example initial post:

For this example, assume that a family has 8 children, and the probability that any one child is a boy is .5.

a) Find the probability that the family has exactly 5 boys.

b) Find the probability that the family has more than 5 boys.

c) Find the probability that the family has at most 5 boys.

____________________________________________________________________________________

For your response posts, here is how to solve these problems in Excel.

a) Find the probability that the family has exactly 5 boys.

Type into an Excel cell

=binom.dist(5,8,.5,False)

You should get .21875 

b) Find the probability that the family has at most 5 boys.

Type into an Excel cell

=binom.dist(5,8,.5,True)

.855469 should be your answer

c) Find the probability that the family has more than 5 boys.

Type into an Excel cell:

=1-binom.dist(5,8,.5,True)

.144531 should be your answer

Notice that this answer is just 1 minus the answer from part b.  Then, describe what these results mean by summarizing the results. 

____________

Binomial in Excel Week 4.html

Week 5 – Example 4

Here is an example by the steps

Binomial Distribution

For 2007 and below use binomdist

For n=10 experiments

X=4

P=.6

Type in a cell

=binom.dist(4,10,.6, FALSE) 

 

For n=10

X<=4

P=.6

type in an excel cell

=binom.dist(4,10,.6,TRUE)

 

For n=10

X<4

P=.6

type in a cell

=binom.dist(3,10,.6, TRUE)

 

For n=10

x>=4

type in a cell

=1-binom.dist(3,10,.6,TRUE)

,

Week 4 Binomial distribution illustrated by Bethany Mueller.html

Week 5 – Example 6

Here is an example by the steps

Binomial Distribution in Excel

For binomial distribution exercise, we use the binom.dist command in Excel.

(For Excel 2007 and older, use the command “binomdist.”)

Note: We use "true" if we're calculating a cumulative probability. We use "false" to calculate the exact probability. In a nutshell, type “TRUE” when you have a “less than” probability (like if the exercise has a strictly “<“ sign) and type “FALSE” when you have a strictly “equals” probability.

Example: A recent survey found that 17% of adults dislike Marshmallow Fluff. Suppose you randomly select four adults and ask them if they like Marshmallow Fluff.

  1. What is the probability that exactly two of them dislike Marshmallow Fluff?
  2. What is the probability that fewer than two of them dislike Marshmallow Fluff?
  3. What is the probability that at least two of them dislike Marshmallow Fluff?
  4. What is the probability that 2 or fewer dislike Marshmallow Fluff?

 

Part a: n = 4, P = 0.17 and x = 2 (we use x = 2 and "FALSE" because we're calculating the exact probability for "equals 2")

part a example

 

Part b: n = 4, P = 0.17 and x < 2 (“fewer than two” means zero or one so we use x = 1 and "TRUE" because we're adding the probabilities of 0 and 1)

part b example

 

Part c: n = 4, P = 0.17 and x >= 2 (“at least two” means two, three, or four; note that this is the compliment of part b)

part c example

 

Part d: n = 4, P = 0.17 and x <= 2 (“two or fewer” means zero, one or two so we use x = 2 and "TRUE" because we're adding the probabilities of 0, 1, and 2)

part d example

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA