1 / 37

Project 1 Lecture Notes

Project 1 Lecture Notes. Table of Contents. Basic Probability Word Processing Mathematics Summation Notation Expected Value Database Functions and Filtering Conditional Probability Bayes’ Theorem. Basic Probability. Sometimes outcomes are determined by chance

anoki
Download Presentation

Project 1 Lecture Notes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Project 1 Lecture Notes

  2. Table of Contents • Basic Probability • Word Processing Mathematics • Summation Notation • Expected Value • Database Functions and Filtering • Conditional Probability • Bayes’ Theorem

  3. Basic Probability • Sometimes outcomes are determined by chance • A collection of outcomes is called an event • The probability of an event, denoted P(E), is the likelihood an event E will occur

  4. Basic Probability • P(E) is always between 0 and 1 • This means there is between a 0% chance and 100% chance an event E will occur

  5. Basic Probability • Three ways to determine probability • Empirically (through trials) • Flip a coin a 100 times. How many times do you expect to see heads? What about a 1000 flips? • By Authority (an expert) • Meteorologist says there’s a 30% chance of rain • Common Agreement (universally accepted) • Roll a dice. What are your chances of getting a six?

  6. Basic Probability • Empirically-based probabilities mean: • The fraction of times an event E occurs in a large number of trials will be very close to P(E) • Universally-based probabilities mean: • P(E) =

  7. Basic Probability • Properties of Probability • 0≤P(E)≤ 1 for any event E • If E is guaranteed to occur, then P(E)=1 • If E and F cannot happen at the same time, then P(E or F) = P(E) + P(F)

  8. Basic Probability • Properties of Probability (cont) • The collection of all possible outcomes in an experiment is called the sample space and is denoted by the letter S. • So property (iii) is equivalent to P(S)=1

  9. Basic Probability • Venn diagrams:E F • The union of E andF, represented by E U F is the collection of items that appear in EorF or in both E and F.

  10. Basic Probability • Venn Diagrams • An example: • Let S = {letters in alphabet} • Let V = {vowels} • Let C = {consonants} • Let F = {1st three letters in alphabet}

  11. Basic Probability • V U F = { a, b, c, e, i, o, u } The set of 1st three letters The set of vowels

  12. Basic Probability • Venn diagrams:E F • The intersection of E and F, represented by E∩ F is the collection of terms that appear in both EandF.

  13. Basic Probability • V∩F = { a } V ∩ F The set of 1st three letters The set of vowels

  14. Basic Probability • More Properties: • The empty set, represented by { }, is the set containing no items. • If E∩ F = { }, then there are no members that appear in both E and F. • We say that E and F are mutually exclusive events. They cannot happen both at the same time.

  15. Basic Probability • V ∩ C = { } The set of 1st three letters The set of vowels

  16. Basic Probability • Properties (iv) and EF

  17. Basic Probability • The last statement means property (iii) can be rewritten as: • If E and F are mutually exclusive, then P(EUF) = P(E) + P(F) • If E, F, G are pair-wise mutually exclusive, then P(E U F U G) = P(E) + P(F) + P(G) • For more events, the process is similar

  18. Basic Probability • More Properties: • The complement of an event E, written as EC , is the set of items NOT contained in E. • Notice in the last Venn Diagram, C = VC • P(EC) = 1 – P(E)

  19. Basic Probability • DeMorgan’s Laws: F E EC FC

  20. Basic Probability • DeMorgan’s Laws: So everything minus the intersection F E EC FC

  21. Basic Probability • DeMorgan’s Laws: • This leads to two more properties: (vi) (vii)

  22. Basic Probability • Ex. Suppose we toss a fair coin 3 times. The sample space is given by S = {HHH, HHT, HTH, HTT, THH, THT, TTH, TTT}. What is the probability of getting exactly 2 tails? • Soln. We count all of the times when there are exactly 2 tails: HTT, THT, TTH. Since there are 8 possible outcomes, the answer is 3/8.

  23. Basic Probability • Ex. Suppose the probability of owning a house (H) is 47% while the probability of owning a car (C) is 73%. If the probability of owning a house and a car is 28%, find the probability of owning a house or a car.

  24. Basic Probability • Soln. Therefore, the probability of owning a house or a car is 92%.

  25. Basic Probability • Ex. Suppose the probability of owning a house (H) is 47% while the probability of owning a car (C) is 73%. If the probability of owning a house and a car is 28%, find the probability of not owning a house.

  26. Basic Probability • Soln. Therefore, the probability of not owning a house is 53%.

  27. Basic Probability • Ex. Suppose the probability of owning a house (H) is 47% while the probability of owning a car (C) is 73%. If the probability of owning a house and a car is 28%, find the probability of neither owning a house nor owning a car.

  28. Basic Probability • Soln. We want to find , that is no house and no car.

  29. Basic Probability • Ex. Suppose the probability of owning a house (H) is 47% while the probability of owning a car (C) is 73%. If the probability of owning a house and a car is 28%, find the probability of not owning a house and owning a car.

  30. Basic Probability • Soln. We want to find , that is no house and a car. When you want to find “not A intersect B,” draw a Venn diagram. HC

  31. Basic Probability • Correct & Incorrect notation: Correct Incorrect

  32. Basic Probability • Focus on the Project: • Define variables: • S: successful loan work out • F: failed loan work out • Use Loan Records.xls and COUNTIF function in Excel

  33. Basic Probability • Focus on the Project: • Range is the collection of cells from which you want to count • Criteria is the information you want to count

  34. Basic Probability • Focus on the Project: • Range: G11:G8236 • Criteria: “yes” • Range: G11:G8236 • Criteria: “no”

  35. Basic Probability • Focus on the Project: • 3818 successful work out situations • 4408 failed work out situations • 8226 total records

  36. Basic Probability • Focus on the Project:

  37. Basic Probability • Focus on the Project: • These probabilities are generally true for the typical borrower • However, they do not account for the specific characteristics of John Sanders

More Related