Manuals/calci/BIRTHDAYPROBABILITY

From ZCubes Wiki
Revision as of 11:39, 6 May 2019 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
BIRTHDAYPROBABILITY (NumberOfDuplicates,TotalNumberOfDays)


  • is any real number.
  • is the number of days.

Description

  • This function shows the value of the Birthday probability.
  • In , is the additional number of birthday.
  • is the number of days.
  • Birthday probability is the sum of the probability that an event will happen and the probability that the event won't happen is always 1.
  • In a room of 75 there is a 99.9% chance of two people birthday matching.
  • To work out the probability there is no two people will have the same birthday,the following rules to be followed to find the probability that two people will share a birthday:
 P(two people share birthday) + P(no two people share birthday) = 1
 P(two people share birthday) = 1 - P(no two people share birthday).

Examples

  1. BIRTHDAYPROBABILITY(3,30) = 0.1384203445582639
  2. BIRTHDAYPROBABILITY(20,432) = 0.3686145731391096
  3. BIRTHDAYPROBABILITY(30.3,765) = 0.44899395029084743

Related Videos

Birthday Probability

See Also

References