Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 26:
Line 26: − + − =log(55)= 1.740362689+ − =log(10)= 1+ − =log(1)= 0+ − =log(-10)= NaN+ − =log(0.25)= -0.602059991+ + + + +
Manuals/calci/NEGBINOMDIST (view source)
Revision as of 10:05, 26 November 2013
, 10:05, 26 November 2013→Examples
==Examples==
==Examples==
=log 10(5)= 0.698970004
#Find the probability that a man flipping a coin gets the fourth head on the ninth flip.
Here total number of events =9, r= 4(since we define Heads as a success) and x=9-4=5(number of failures)
p=1/2=0.5(Probability of success for any coin flip)
NEGBINOMDIST(5,4,0.5)=0.109375
#A company conducts a geological study that indicates that an exploratory goods well should have a 20% chance of striking goods. What is the probability that the first strike comes on the third well drilled?
Here total number of events=3, r=1,x=3-1=2,and p=0.20
NEGBINOMDIST(2,1,0.20)=0.128
#What is the probability that the fourth strike comes on the eighth well drilled?
Here total number of events=8, r=4, x=8-4=4 and p=0.20
NEGBINOMDIST(4,4,0.20)=0.0229376
==See Also==
==See Also==