The Stats Files

Basic Probabilities Excel Calculator

Students often are given questions that require them to find basic and conditional probabilities for a 2×2 matrix such as this problem: You can work this problem using StatCrunch using the Stat>Tables>Contingency path, but some students get confused by the cluttered output. I have developed an Excel worksheet that makes this much easier for a 2×2 table. You can use the online version below, or you can contact me and I will send you my workbook. When you put your data and the column and row labels in the blue cells, the table below will populate including the correct wording for the probability statements. Here is a link to a video on how to use the calculator to solve this type of problem:  You may download a copy of the calculator workbook here: Basic Probabilities Calculator
Dr. Dawn Wright


Meet Dr. Dawn

I’ll help you find easy solutions to those statistics and analytics problems you love to hate. I show easy ways to use technology to solve them.