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.
2. Use PROB function to calculate probability.
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%.