Monday, March 18, 2013

How to Solve Probability Equations With Excel


1. Click the 'Fx' button just under the ribbon.
2. Select the down arrow to the right of 'Or select a category.'
3. Select the type of probability equation you want to solve from the 'Select a function' list. There are dozens of functions to choose from, including NORMSINV, which returns the inverse of the standard normal cumulative distribution and PERMUT, which returns the number of permutations possible from a given number of objects.
4. Follow the directions in the pop-up window to input the data necessary to solve the probability equations. Some functions, like the COMBIN function, ask you to type the data directly into the window. Other statistical functions may require you to input the data into the spreadsheet.

Blogger news