Anonymous
Anonymous asked in Science & MathematicsMathematics · 1 month ago

QUANTITATIVE BIO HELP PLEASE?

The binomial formula is Pr (x successes) = (n/X) p^x (1-p)^n-X

In a sample of 13 cats from a population with a probability of 0.05 of having a coat of fur with only one color we want to determine what is the probability of choosing FEWER THAN THREE cats whose coat is monocolor.

First determine the values for the formula, if more than one success is possible, list each separated by a comma:

X =

n =

p =

The Excel formula for binomial distribution is =BINOMDIST(X,n,p,FALSE). But because you're looking for the probability of FEWER THAN THREE cats whose coat is monocolor, what mathematical calculation will you need to perform on the individual probabilities?  (FILL IN THE BLANK)

 (add, subtract, multiply, divide, etc.)

Use Excel to calculate the probability of choosing FEWER THAN THREE cats whose coat is monocolor. (FILL IN THE BLANK)

  (copy & paste your answer from EXCEL to at least 4 significant figures - make sure your probability copies over and not your formula).

 

2 Answers

Relevance
  • Alan
    Lv 7
    1 month ago
    Favorite Answer

    First determine the values for the formula, if more than one success is possible, list each separated by a comma:

    X =   0, 1,2,3,4,5,6,7,8,9,10,11,12,13

    are all the possible values of the X 

    so for

    for the probability fewer than 3  

    X = 0,1,2   

    are the only values less 3 

    n =   13

    p =  0.05

    You can do it Excel in two ways ( addition of 3 numbers) 

    = BINOMDIST(0,13,0.05,FALSE)  +  .BINOMDIST(1,13,0.05,FALSE)  +

    BINOMDIST(2,13,0.05,FALSE)  

    however , this is equivalent to this shorter equation

    so if your textbook was smarter,it would suggest using 

    TRUE and then you wouldn't to add anything 

    = BINOMDIST(2,13,0.05,TRUE)  

    use true for CUMULATIVE for X = 2 gives the sum of X =0 up to 

    X =  2 which is the same as the 1st equation 

    = 0.975492158

    =0.975492158

    • Commenter avatarLogin to reply the answers
  • Anonymous
    1 month ago

    All that typing and not a single question. What a damn shame.

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.