Home

How to Work with probabilities in Microsoft Office Excel

May 5, 2010 06:34 PM

Statistical sample space table with values and coordinates.

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:

1. Probability

2. Experiment & Experimental Outcomes

3. Sample Point (Experimental Outcome)

4. Sample Space

5. Multi-step Experiment

6. Tree Diagram

7. Counting Rule for Multi-step Experiment

8. Combinations

9. Permutations

10. Methods of Assigning Probabilities

11. Classical Method

12. Relative Frequency Method & Law of Large Numbers

13. Subjective Method

14. Requirements for Assigning Probabilities

15. Event

16. Probability of an Event

17. P(S) =1

18. Calculating Probability for Classical Method

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.