# 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

- AlanLv 71 month agoFavorite 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

- Login to reply the answers

- Anonymous1 month ago
All that typing and not a single question. What a damn shame.

- Login to reply the answers