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: https://youtu.be/_n6TAmWJFoM 

You may download a copy of the calculator workbook here: Basic Probabilities Calculator

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top