Saturday, December 24, 2011

How to Find Probability in Excel 2007


1. Open Excel 2007 and select the 'Formulas' tab.
2. Click on the icon for 'Other Formulas.' A pop-out menu will show up. Select 'Statistical Formulas' from the pop-out menu.
3. Select BINOMDIST. A dialog box will appear with four fields.
4. Enter the number of successful tests in for the first field.
5. Enter the number of trials in the second field.
6. Enter the probability of success for a given success in the third field.
7. Enter TRUE or FALSE in the fourth field. Use TRUE if the probability distribution is cumulative, and FALSE if it's not.
8. Read the result from the bottom of the dialog box.

Blogger news