Basic+Excel+functions+_+Q5+derivation+_HW0_

Basic+Excel+functions+_+Q5+derivation+_HW0_ - Basic Excel...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Basic Excel functions Dot product = (1,2,3) ° (4,5,6) T = (1)(4) + (2)(4) + (3,6) “Lock” in a reference for dragging / copying formulas
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Derivation of formula in Q5: “Triple Birthday Problem” We want the probability that three or more people do not have the same birthday. We are going to say that a “triple” is three or more people have the same birthday. So we want to find the probability that there is not a triple This means everyone must either have a “single” birthday or a “double” birthday. So if we have 3 people they could be: 3 singles, e.g. Jan 1, Jan 2, Jan 3 1 single + 1 double, e.g. Jan 1, Jan, 1, Jan 2 1 triple, e.g. Jan 1, Jan 1, Jan 1 We also know that 1 = P(all singles) + P(1 single + 1 double) + P(1 triple) because those are all of the possible outcomes. We are going to use the notation: P( n,k ) is the probability of k doubles when there are n people. P(1,0) = 1.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Basic+Excel+functions+_+Q5+derivation+_HW0_ - Basic Excel...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online