From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Create a classification matrix

Create a classification matrix - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Create a classification matrix

“

- [Instructor] In the previous movie, I showed you a way to draw a graph that visualizes the way probability is combined to perform Bayesian analysis. In this movie, I will show you how to create a classification matrix, which will take us one step closer to implementing this analysis in Excel. So let's review what we know about our base rates and our accuracy. First, we know that the base rate of green cabs is 85%. That means that 15% of the cabs will be blue. Also, we know that witnesses are accurate as for color identification 80% of the time. And again, the cab can be green or blue. Also, the witness can be accurate or not, and those are the factors that we will use to create a two by two probability or a classification matrix so we know the probability of arriving at each combination. So let's take a look at a classification matrix. Here's the data, again, I won't repeat it, but here is what the matrix looked like and it is the compound probability of reaching each of these four…

Contents