# How to Use Excel As a Probability Machine

Written by kevin cavanagh
• Share
• Tweet
• Share
• Pin
• Email

Calculating probability by hand has become a thing of the past, with many people now having access to Microsoft Excel, which is an excellent tool when calculating probability and statistics. Microsoft Excel has hundreds of built-in functions that can assist users with many numerical tasks. One function Excel offers is a probability formula that can calculate probabilities in seconds, instead of hours, doing it by hand.

Skill level:
Moderately Challenging

### Things you need

• Microsoft Excel

## The Probability Function of Microsoft Excel

1. 1

Open the spreadsheet that contains the data you would like analysed. Select an empty cell. The cell you select will be where your answer will appear after you run the formula.

2. 2

Scroll up to the "Insert" tab and select "Function". This should open a new window titled "Insert Function".

3. 3

Select "statistical" from the options and then select "NORMDIST" to open a statistics window in Excel.

4. 4

Highlight the data you want analysed for each option: (Mean, Standard Deviation, etc). Once all of the data has been highlighted, press "APPLY" and the answer will appear in the box selected.

### Don't Miss

#### References

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent