Calculating probability

Probably you want to get to know how to calculate probability with Excel. You will after you take a look at this easy tutorial.

1. Enter data in Excel sheet.

data table probability

2. Use PROB function to calculate probability.

PROB function

Formula here is =PROB(A2:A10,B2:B10,B13,B14) where

  • A2:A10 is range of marks in this example
  • B2:B10 is a chance of getting the grade from A column
  • B13 is lower range
  • B14 stand for upper range

The probability here is 45%.