A coil of wire has 400 metres of wire. Suppose there are 20 nicks (the most common problem with wire) are randomly distributed on a coil.
What is the probability that in a 40 metre length of wire there will be at least 6 nicks?
What is the probability that in a 49 metre length of wire there will be exactly 4 nick(s)?
I know that I have to use the poisson distribution, but I have to do it in excel using
=POISSON(x,mean,1 or 0), and I have no idea what to do.