From the course: Learning Excel: Data Analysis
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Analyze a sample problem: Kahneman’s Cabs - Microsoft Excel Tutorial
From the course: Learning Excel: Data Analysis
Analyze a sample problem: Kahneman’s Cabs
- [Instructor] If you haven't worked with Bayesian analysis before dealing with prior probabilities and base rates, then the concept can be a little unclear. I'd like to work through a classic example from Tversky and Kahneman called it the taxicab problem that will demonstrate how Bayesian analysis works and give you better intuition. Let's start with the facts as proposed within the problem, A cab was involved in a hit-and-run accident at night. There are two cab companies working in the city, green and blue. Furthermore, we know that a witness identified the cab as blue. However, 85% of the cabs in the city are green and only 15% are blue. Next, we need to know about witness reliability. The court tested the reliability of the witness under the circumstances that existed on the night of the accident, and concluded that the witness correctly identified each one of the two colors 80% of the time and failed 20% of the time. If there are any attorneys watching this video, don't worry…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Introduce Bayesian analysis2m 4s
-
(Locked)
Analyze a sample problem: Kahneman’s Cabs4m 9s
-
(Locked)
Create a classification matrix3m 10s
-
(Locked)
Calculate Bayesian probabilities in Excel5m 28s
-
(Locked)
Challenge: Perform a Bayesian analysis1m 4s
-
(Locked)
Solution: Perform a Bayesian analysis5m 18s
-
(Locked)
-